Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

#1045 cannot log in to the mysql server - PhpMyAdmin

L

lukaz32

macrumors newbie
Original poster
Sep 14, 2011
1
0
I don't know what else to try, I just can't get this working. I open the login page of phpmyadmin trying to log in as root an it keeps giving me the message "#1045 Cannot log in to the MySQL server"

I try to set a new password to root by typing:


/usr/local/mysql/bin/mysqladmin -u root password NEWPASSWORD

and it gives me:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I think that it might be missing some extra configs. in my php.ini

Can anyone help me out?
 
lukaz32 said:
I don't know what else to try, I just can't get this working. I open the login page of phpmyadmin trying to log in as root an it keeps giving me the message "#1045 Cannot log in to the MySQL server"

I try to set a new password to root by typing:


/usr/local/mysql/bin/mysqladmin -u root password NEWPASSWORD

and it gives me:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I think that it might be missing some extra configs. in my php.ini

Can anyone help me out?
Click to expand...

Take a look at http://hintsforums.macworld.com/showthread.php?t=58057 there seems to be some good info in there.
 
Take a look at the config.inc.php file in the phpMyAdmin directory.
You can set the password there.
 
Modify Configuration in config.inc.php

First Rename the configuration file name from config.sample.inc.php to config.inc.php

Then change the line:
$cfg['Servers'][$i]['AllowNoPassword'] = false;
to:
$cfg['Servers'][$i]['AllowNoPassword'] = true;

hope this helps.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back