|Sep 14, 2011, 12: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, 12:12 AM||#2|
|Dec 5, 2012, 02: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|
|Webhost small business recommendation please? - cpanel,php,mysql,phpmyadmin||whitedragon101||Web Design and Development||8||Jan 24, 2014 06:07 AM|
|Trying to set up a testing server & MySQL Problem||mripah||Web Design and Development||7||Jul 6, 2013 09:31 AM|
|Phpmyadmin & mamp problem||cool11||Web Design and Development||5||Apr 24, 2013 04:33 PM|
|MySQL Server Connection||aceiswild||Web Design and Development||6||Jun 30, 2012 01:14 PM|
|Mamp Pro phpMyAdmin Error||firedept||Web Design and Development||0||Jun 24, 2012 10:16 PM|
All times are GMT -5. The time now is 05:09 AM.