#1  
Old 30th September 2008, 16:43
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 432
Thanks: 31
Thanked 0 Times in 0 Posts
Default phpMyAdmin

I just changed my mysql password using

Code:
mysqladmin -u root -pcurrent_password password new_password
and now I can't login to phpMyAdmin at all. I tried using the client username and password, and I tried "root" and the mysql admin password. I tried "root" and the old password. What am I doing wrong?
Reply With Quote
Sponsored Links
  #2  
Old 1st October 2008, 00:53
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Are you able to login with the "mysql" command on the shell?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 1st October 2008, 01:18
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 432
Thanks: 31
Thanked 0 Times in 0 Posts
Default

I can log on just fine as the system user. When I try as root, I get the error:

Quote:
ERROR 1045 (28000): Acess denied for user 'root'@'localhost' (using password: NO)

Last edited by dayjahone; 1st October 2008 at 04:49.
Reply With Quote
  #4  
Old 1st October 2008, 14:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Have you tried to restart MySQL?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 1st October 2008, 16:27
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 432
Thanks: 31
Thanked 0 Times in 0 Posts
Default

I restarted mysql and I restarted the machine. I can now log in as root using the new password, but I am supposed to be able to login using my client login information as well, right? I am still not able to do that.

Is there anywhere else I need to change the password? I did the following:
Quote:
mysqladmin -u root -pcurrent_password password new_password
then, to change it on the line
Quote:
$go_info["server"]["db_password"] = "new_password";
in /home/admispconfig/ispconfig/lib/config.inc.php

Another thing I notice is when I click to logout of phpMyAdmin it asks me for a username and password again and won't accept anything I give it. I eventually just close the window.

Last edited by dayjahone; 1st October 2008 at 17:04.
Reply With Quote
  #6  
Old 2nd October 2008, 16:31
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Do you see any MySQL errors in the syslog?
Does your new password contain any special characters?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 2nd October 2008, 16:48
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 432
Thanks: 31
Thanked 0 Times in 0 Posts
Default

Where is the syslog?

There is one special character in the new password, but, like I said, I can log in as root, so I'm guessing that's not the problem.
Reply With Quote
  #8  
Old 2nd October 2008, 16:58
dpakulski dpakulski is offline
Junior Member
 
Join Date: Oct 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Cool

I think I know where the problem might be. You set password to mysql root account and before access from localhost was without any password. I'd advice to configure root account permission in mysql that password from localhost is not required. All should come back to previous state after that.

I can't give you now more precise instruction how to do it, but using man pages I suppose it should take 2-5 min to reset mysql root account permission to state that password from localhost is not required providing you know current root mysql password.
Reply With Quote
  #9  
Old 3rd October 2008, 09:40
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 432
Thanks: 31
Thanked 0 Times in 0 Posts
Default

Uh...so, how can I fix it?
Reply With Quote
  #10  
Old 3rd October 2008, 13:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
 
Default

Try this to set another password: http://www.howtoforge.com/reset-forg...-root-password
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
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
drupal, phpmyadmin and localhost: drupal installation blesbok Server Operation 7 8th October 2008 10:46
phpMyAdmin goes PHP5 & MySQL5 Hans General 5 28th September 2008 21:46
phpmyadmin problem on ubuntu mail server virtual domains almeister9 HOWTO-Related Questions 1 19th September 2008 17:52
phpMyAdmin 2.11.5.2 package available for ISPConfig Hans General 4 30th April 2008 09:39
phpMyAdmin question? ctroyp Installation/Configuration 1 21st March 2006 00:19


All times are GMT +2. The time now is 16:38.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.