WampServer

Hello,

I use wamp to build sites offline, when Im finished:
1. I copy files to live server,
2. export DB using wamps phpmyadmin
3. import DB using cpanels phpmyadmin.

But now I installed wamp on fresh windows 7 copy and this doesn't work for me anymore, I do everything exactly the same as before, but on step 3, when I'm importing DB using cpanel phpmyadmin, I get this error -

SQL query:

--
-- Database: `3aboli`
--
CREATE DATABASE IF NOT EXISTS `3aboli` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'cpses_abRgP4GEiX'@'localhost' to database '3aboli'


I'm not sure if I used wamp 2.2 or 2.4 before reinstalling windows.


Version of Operating system? Windows 7 x64
Version of Wamp Server installed? 2.4
Version of Apache you are running? 2.4.4
Version of MySQL you are running? 5.6.12
Version of PHP you are running? 5.4.12

Well it seems you have logged into mysql with a userid of 'cpses_abRgP4GEiX' but that userid is not allowed to access this version of MySQL from the localhost domain or it does not have the privileges to create databases..



Either setup the user correctly or use the 'root' userid to run your import.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Actually I didn't log into any account specifically, I just used wamp as I do always. I don't even need to log in to phpmyadmin when using wamp. As goes for cpanel on a live webserver, the user I'm using there can create databases, database users, etc.

Actually I didn't log into any account specifically, I just used wamp as I do always. I don't even need to log in to phpmyadmin when using wamp. As goes for cpanel on a live webserver, the user I'm using there can create databases, database users, etc.

If you are using WAMPServer 2.4 you now have a login screen shown to you when you run phpMyAdmin.

Do you see a login screen when you run phpMyAdmin ( on a WAMP install ).

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-