#1045 - Access denied for user 'root'@'localhost' (using password: YES)

[Harley]

Hello,

 

I hope someone can help here. I am new to PHP and MySQL.

 

I have recently installed PHP, Apache, MySQL successfully it seems. I am running Uniform Server to run them all which seems to be fine but when I open phpMyAdmin it gets a little hazey here. This is what I am getting:

 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

 

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Invalid hostname for server 2. Please review your configuration.

Invalid hostname for server 3. Please review your configuration.

 

Where does it want me to set the configuration? In phpMyAdmin or MySQL? How do I go about this?

 

Any info would be great, ps remember I am new to all this and need these things spelling out to me until I fully come round to the OS school of thought.

 

Thank

 

Harley

[Ric]

Hi Harley,

Well that sounds like fun three servers, seriously I have not come across those error messages. What would be of help if we know what your OS is (Windows XP home, XP pro).

 

Where does it want me to set the configuration? In phpMyAdmin or MySQL? How do I go about this?”

 

With a clean installation there is no need to change a thing (until you go on-line) however with Apache and MySQL running there should be no problem with phpMyAdmin.

 

Need to resolve this first, hence what OS, have you ever used another WAMP or MySQL on your machine (and uninstalled it) any other error messages.

[Harley]

Thanks for the reply, no I have never installed MySQL before, first time getting into all this stuff. I am currently running Windows xp Home edition.

 

Do you think a clean install of MySQL could do the trick?

[Ric]

With XP Home there really should be no problem. Download a fresh copy of UniServer 3.3 (yours may have been corrupted). Extract the files to any folder you like and run that version to see what happens.

 

That’s the beauty of UniServer you can have as many copies of it as you like in different folder. Experiment with it, once you break it beyond repair just use another copy and delete the old one.

 

Yes do a clean install, run the server using Server_Start.bat wait a little while for your browser to start. This will display a page named Apanel from this start the MySQL server and then run phpMyAdmin (again from apanel). Note: if challenged by any firewall or other security allow connections on all ports for both Apache and MySQL.

 

If the problem remains do not hesitate, come back and we will try to resolve it.

[olajideolaolorun]

I think you also have single copies of Apache, MySQL and PHP installed. If you have their single installtions installed, please uninstall them as they might interfere with Uniform Server.

 

Go to C:/Windows and C:/Windows/System32

 

Look for a file called LIBMYSQL.DLL

 

Delete it if you find it in both locations....

 

*By single install i meant you went on their websites and downloaded them each and installed them. If you didn't, reply....

[Harley]

*By single install i meant you went on their websites and downloaded them each and installed them. If you didn't, reply....

 

Yes I did a 'single install' for each of them as you said, I'll try both your advice and come back on this one anyway, it sounds promising!

 

Many thanks

[olajideolaolorun]

K.

[Ric]

Some time ago I produced a Perl script to automate this process may be worth looking at.

http://center.uniformserver.com/us_35/us35...s_3.html#tester

 

All the best

Ric

[Satinka]

Well, please let me "borrow" this topic since I had EXACTLY the same problem

(error #1045) and use exactly the same OS (Windows XP) as Harley did/does.

 

Of course I read the whole topic and applied the advice, meaning I re-installed a new copy of Uniform Server (actually the latest version currently, 3.5)

 

Then I followed every instruction I found on the support site: changed password for server/private/Mysql and uncommented the validation lines in www/.htaccess

Thereafter I launched phpmyadmin from aconsole, tried to create a database and, indeed, a folder with my database name was created. So far, wonderful.

 

Then I went to the mysql directory (W:\usr\local\mysql\bin), typed "mysql --help" and it worked, I had the correct display.

Finally I tried to type just: "mysql" and... got the same old #1045 error message.

 

I beg your help since my aim is to use mysql at the prompt line, and I´m stuck at this point.

 

Please forgive my poor English.

 

Thanks a lot

Satinka

[Minute]

You should use "mysql -uroot -p<password>" instead (-u specifies your username and -p specifies the password for that username). From your post, I understand that you've changed your password, so just replace <password> with the password you've set. More information can be found here.

[Satinka]

Thank you so much.

Everything OK now