Topic: Any issues with MySQL &phpmyadmin and v5

[Scott Lewis]

I am having issues getting phpmyadmin to work with MYSQL.

Basically pc name is Linux, and domain is scott-lewis.d2g.com
I installed phpmyadmin in html directory, and altered the config file accordingly. Left the user as root.

When I go to the url:-

http://www.scott-lewis.d2g.com/php/index.php

I get the error

Host 'Linux.scott-lewis.d2g.com' is not allowed to connect to this MySQL server

Now, I know php is working - heres a test page of all the settings of it:-

http://www.scott-lewis.d2g.com/php/test.php

Now, I have tried altering and adding localhost as the host but localhost is not recognised, even when I type it in the url is gooes to msn search page.

Now, I have tried getting into mysql via command line using:-

shell> mysql -h host -u user -p


I enter the password I have of root - and it wont let me in.

Any ideas???
Is this a issues with mysql or e-smith v5.0.3. ALso tried on v5.1.2.

Scott

[Dan Brown]

In config.inc.php, the hostname should be set to 'localhost', not the name of your server.

[Jon Blakely]

Also make sure that the root password you are using is the one in /root/.my.conf
not the one you made when you configured the server.

[mongolito404]

By the way, you should not use the 'config' identifiation mode of phpMyAdmin 2.2.3 (or later), the 'http' one is far more flexible and secure.
Follow the steps in the Documentation.txt (not .html) and it will works with many different user. So you don't need to connect as root you can use different user too. (usefull if many people use the DB buy should not do it as root).

[Mike]

I looked at .my.cnf and the password is so long is that what I'm suppost to use to log on?

[JonB]

for root access to mysql, yes.