|Sep 14, 2011, 01:59 PM||#1|
#1045 cannot log in to the mysql server - PhpMyAdmin
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?
|Sep 15, 2011, 01:12 AM||#2|
|Dec 5, 2012, 03:49 AM||#5|
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;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
hope this helps.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|#1045 Cannot log in to the MySQL server (Different than most cases)||Chriss316||Web Design and Development||2||Jun 5, 2010 05:07 PM|
|Cannot log in to Apple Discussion Forum||JohnnyBgood||Apple, Industry and Internet Discussion||3||Apr 23, 2009 10:53 AM|
|cannot log in to mac mini||wedge234||Mac mini||2||May 18, 2008 07:19 PM|
|cannot log in to network||dadio2002||MacBook Pro||0||Aug 24, 2007 09:37 AM|
All times are GMT -5. The time now is 10:54 PM.