| Posted: 22 Oct 2007 13:23 | |
|
Registered User Currently Offline |
Posts: 8 Join Date: May 2007 |
|
Hi,
I deinstalled 2.1.1 and installed 3.0. But now MySQL didn't allow localhost to login. I tried this on another PC without a previous WAMP installation. Same problem. What's the problem? What can I do? cu jc |
|
| Posted: 24 Oct 2007 15:39 | |
|
Administrator |
Posts: 125 Join Date: Feb 2005 |
| Please provide a better description: Are you using phpMyAdmin or the command line? Which username are you using? What is the error message? | |
| Posted: 24 Oct 2007 19:41 Last Edited By: jc_ | |
|
Registered User Currently Offline |
Posts: 8 Join Date: May 2007 |
|
Hi,
I tried phpMyAdmin as well as command line. The error message is like I said "ERROR: #1130 - Host 'localhost' is not allowed to connect to this MySQL server". Every username I try, it's always the same error. It seams, as if there are no entries in the database for user / db. I also tried to connect from another pc (remote), same problem. Then I tried to install WAMP on a complete new PC without any prev. WAMP and/or MySQL installtion. Same problem. Quote:
As for the MySQL server: did you keep the database files of a previous installation? No. cu jc |
|
| Posted: 25 Oct 2007 13:56 | |
|
Registered User Currently Offline |
Posts: 8 Join Date: May 2007 |
|
Hi,
is it possible, that someone send me the whole "C:\Programme\e-novative\WAMP\MySql" directory from a mysql installation that works? cu jc |
|
| Posted: 01 Nov 2007 13:46 | |
|
Administrator |
Posts: 125 Join Date: Feb 2005 |
|
Well, if you have successfully installed WAMP on another system, use the files from that machine.
It seems that you do not allow "localhost" to connect to MySQL. You could try connecting from a remote computer, maybe this is still allowed. Then you could fix the rights table from remotely. I seem to recall that MySQL has an option you can start the server with to fix the rights table. Have a look at the MySQL documentation to see if this might work for you. |
|
| Posted: 04 Dec 2007 13:50 | |
|
Registered User Currently Offline |
Posts: 6 Join Date: Oct 2005 |
|
I ran into the same problem with 3.0 release, the reason is empty (!) table users in database mysql (installer bug?)
Solution: net stop mysql mysqld-nt.exe --skip-grant-tables In another DOS-Box run mysql -u root In the mysql console: insert into mysql.user (host, user, password, process_priv) values ('localhost', 'root', password('mypwd'), 'y'); insert into mysql.user (host, user, password, process_priv) values ('%', 'root', password('mypwd'), 'y'); --> Reboot Now you can connect as user "root" with password "mypwdE: |
|
| Posted: 04 Dec 2007 13:59 | |
|
Registered User Currently Offline |
Posts: 6 Join Date: Oct 2005 |
|
Typo in the previous post, the password is "mypwd".
Obviously my solution is not complete, I can connect as root now but have no privileges to create any database. I will do some further research and provide some fixed insert into mysql.user... commands. |
|
| Posted: 04 Dec 2007 16:44 | |
|
Registered User Currently Offline |
Posts: 6 Join Date: Oct 2005 |
|
Improved command to create the root user:
insert into mysql.user (host, user, password, process_priv, super_priv) values ('localhost', 'root', password('mypwd'), 'y', 'y'); insert into mysql.user (host, user, password, process_priv, super_priv) values ('%', 'root', password('mypwd'), 'y', 'y'); |
|