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

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?
 

Laird Knox

macrumors 68000
Jun 18, 2010
1,956
1,343
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?

Take a look at http://hintsforums.macworld.com/showthread.php?t=58057 there seems to be some good info in there.
 

frocco

macrumors 6502
Jan 27, 2009
494
43
Take a look at the config.inc.php file in the phpMyAdmin directory.
You can set the password there.
 

kyoussef

macrumors newbie
Dec 5, 2012
1
0
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.