Go Back   MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Reply
 
Thread Tools Search this Thread Display Modes
Old Sep 14, 2011, 12:59 PM   #1
lukaz32
macrumors newbie
 
Join Date: Sep 2011
#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?
lukaz32 is offline   0 Reply With Quote
Old Sep 15, 2011, 12:12 AM   #2
Laird Knox
macrumors 65816
 
Join Date: Jun 2010
Quote:
Originally Posted by lukaz32 View Post
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.
Laird Knox is offline   0 Reply With Quote
Old Sep 15, 2011, 03:50 AM   #3
Hansr
macrumors 6502a
 
Join Date: Apr 2007
Reset the password and flush the privileges:
http://ubuntu.flowconsult.at/en/mysq...root-password/
Hansr is offline   0 Reply With Quote
Old Sep 15, 2011, 02:32 PM   #4
frocco
macrumors 6502
 
Join Date: Jan 2009
Take a look at the config.inc.php file in the phpMyAdmin directory.
You can set the password there.
__________________
Regards, Frank
frocco is offline   0 Reply With Quote
Old Dec 5, 2012, 02:49 AM   #5
kyoussef
macrumors newbie
 
Join Date: Dec 2012
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.
kyoussef is offline   0 Reply With Quote

Reply
MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 02:14 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC