Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
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 04:07 PM
Cannot log in to Apple Discussion Forum JohnnyBgood Apple, Industry and Internet Discussion 3 Apr 23, 2009 09:53 AM
cannot log in to mac mini wedge234 Mac mini 2 May 18, 2008 06:19 PM
cannot log in to network dadio2002 MacBook Pro 0 Aug 24, 2007 08:37 AM


All times are GMT -5. The time now is 09:11 AM.

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

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