August 21st, 2005, 02:00 PM
problem with mysql
I have installed Apache, Php, Mysql, and phpmyadmin. At the end I wanted to check if phpmyadmin goes well by entering http://localhost/phpmyadmin/index.php. But it appeared that there was an error like this:
Access denied for user: 'firstname.lastname@example.org' (Using password: YES)
Can anybody tell me what it is, and how to fix it.
Thank you very much indeed.
I have already configured config.inc.php in phpmyadmin as following:
$cfgServers['host'] = 'localhost';
$cfgServers['user'] = 'root';
$cfgServers['password'] = 'password';
thanx a lot
August 21st, 2005, 02:04 PM
This is a MySQL issue not a PHP issue. And you should change your subject line because when you try to use a URL is displays as ...
August 21st, 2005, 02:14 PM
did you try to access the mysql server through the command line client?
does it work there?
August 21st, 2005, 02:16 PM
what do you mean?? sorry, I am just a beginner
Originally Posted by busmaster
August 21st, 2005, 02:26 PM
where have you installed mysql?
we will assume c:\mysql
got to c:\mysql\bin using the command prompt.
then type "mysql -u root -p"
it will ask you for your password. enter it. if it does notwork, then either
1. your mysql server is not running
2. your password is wrong.
to check your mysql server, type "net start mysql" in the command prompt.
if it says, service already started, well and good, else it will start the service.
then try the above command again.
August 21st, 2005, 02:29 PM
Why do people think that if they have a problem it belongs in the PHP section?
Comments on this post
August 21st, 2005, 02:41 PM
yes, but when I typed c:\mysql\bin it was written : it is not recognized as an internal or external command, operable program or batch file.
I am sure I have mysql in c:\mysql
August 21st, 2005, 03:15 PM
try this, instead of saving the user and pass for mysql in the config file so anyone can open it and have access to your db, change the auth_type to cookie
$cfg['Servers'][$i]['auth_type'] = 'cookie';
then you can type in your mysql user and pass.
August 21st, 2005, 04:27 PM
Hura! it works, thank you very much
August 21st, 2005, 04:52 PM
One little comment: unlike most things, MySQL thinks localhost and 127.0.0.1 are different locations. Therefore, if the user root@localhost has permissions, but email@example.com doesn't then you need to use root@localhost (or grant the privs. to firstname.lastname@example.org).
Comments on this post