Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Scott Lewis on February 09, 2002, 06:49:57 PM

Title: Any issues with MySQL &phpmyadmin and v5
Post by: Scott Lewis on February 09, 2002, 06:49:57 PM

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

Title: Re: Any issues with MySQL &phpmyadmin and v5
Post by: Dan Brown on February 09, 2002, 07:26:59 PM

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

Title: Re: Any issues with MySQL &phpmyadmin and v5
Post by: Jon Blakely on February 10, 2002, 05:05:44 AM

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.

Title: Re: Any issues with MySQL &phpmyadmin and v5
Post by: mongolito404 on February 10, 2002, 02:04:18 PM

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).

Title: Re: Any issues with MySQL &phpmyadmin and v5
Post by: Mike on February 10, 2002, 05:28:50 PM

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

Title: Re: Any issues with MySQL &phpmyadmin and v5
Post by: JonB on February 11, 2002, 12:48:27 AM

for root access to mysql, yes.