#1  
Old 14th September 2009, 15:07
flevoict flevoict is offline
Junior Member
 
Join Date: Aug 2009
Posts: 8
Thanks: 0
Thanked 2 Times in 2 Posts
Default BIG! mysql-PHPmyadmin problem

Dear all,

I hope somebody can help me because I have a big problem. I can't login anymore to the PHPmyadmin of my main ispconfig server.

All the servers are setup with http://www.howtoforge.com/perfect-se...ispconfig-3-p1

When I added the second server to het ISPConfig network I run the following commands on the phpmyadmin:
update user set Host='second server' where user='root';

update db set Host='second server' where Db='mysql';

After this I could add the ISPConfig installation through the expert mode.

Today I wan't to add the third server and now I can't login to PHPmyadmin. It gives me the error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

And in shell mode:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

And now the funniest thing, if i connect on the second server through shell mode to the first server I have access.

I know for sure that the passwords are correct so that isn't the problem. I think that with adding the users for the second server the localhost login is disabled/changed/deleted or something.

I hope someone can help me with this issue.

And if there is anybody who can easily explain me how to give a server access to the main database for the expert setup it would be appreciated.

Thnx in advance,

Bas
Reply With Quote
Sponsored Links
  #2  
Old 14th September 2009, 15:28
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,033
Thanks: 260
Thanked 145 Times in 127 Posts
Default

This might help you.
http://www.howtoforge.com/forums/showthread.php?t=36418
Reply With Quote
  #3  
Old 14th September 2009, 15:46
flevoict flevoict is offline
Junior Member
 
Join Date: Aug 2009
Posts: 8
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I already tried this. It didn't help.

The option is already on cookie, if I change it to config I just get an access denied message.
Reply With Quote
  #4  
Old 14th September 2009, 17:05
flevoict flevoict is offline
Junior Member
 
Join Date: Aug 2009
Posts: 8
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Fixed it!!!

- I restarted the mysql server like this so I could login:
Stop the MySQL server by using either of the following command
#/etc/init.d/mysql stop
Now you need to Start MySQL server without password
# mysqld_safe --skip-grant-tables &

- Now I could login again in phpmyadmin and I added a new localhost root user (this one was lost).

- Then I ran the following commands
Now you need to Stop MySQL Server using the following command
# /etc/init.d/mysql stop

- Test Your New Mysql root password
First you need to start mysql server using the following command
# /etc/init.d/mysql start
# mysql -u root -p
Now it will prompt for root password and enter your new root password
Reply With Quote
The Following User Says Thank You to flevoict For This Useful Post:
ArchiMark (24th December 2009)
  #5  
Old 24th December 2009, 03:54
ArchiMark ArchiMark is offline
Junior Member
 
Join Date: Dec 2009
Location: USA
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
 
Question

Quote:
Originally Posted by flevoict View Post
Fixed it!!!

- I restarted the mysql server like this so I could login:
Stop the MySQL server by using either of the following command
#/etc/init.d/mysql stop
Now you need to Start MySQL server without password
# mysqld_safe --skip-grant-tables &

- Now I could login again in phpmyadmin and I added a new localhost root user (this one was lost).

- Then I ran the following commands
Now you need to Stop MySQL Server using the following command
# /etc/init.d/mysql stop

- Test Your New Mysql root password
First you need to start mysql server using the following command
# /etc/init.d/mysql start
# mysql -u root -p
Now it will prompt for root password and enter your new root password
So glad that I found your post, flevoict.....have read post upon post upon post around the net looking for info like yours....

I tried your suggestions and the good news is that after I did the first part above I was finally able to login to phpmyadmin and see the page where you can make adjustments, etc....

However, after I tried adding a new user there, and clicked the 'Go' button (think that is what is was called...) to save the new user, I got error message that it could not save new user as '-skip-grant-tables' was in effect....so, seems like a 'Catch 22' situation, where if I restart MySQL server again, then I can't login to create new user....

Am I missing something here?

Do you or anyone else have any suggestions as to how get over this vicious circle I am in where either I can't login to phpmyadmin or if I can login via flevoict's suggestions, then I can't actually save any changes I make....

Thanks for any and all help with this....have spent hours trying to get this working right...

Happy Holidays,

Mark
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
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
phpmyadmin "Cannot load mysql extension. Please check your PHP configuration" rjamesd Programming/Scripts 4 23rd October 2007 16:27
mysql connect problem again Danielss89 Installation/Configuration 3 15th January 2007 21:02
Site with MySQL problem?! edge Server Operation 2 13th August 2006 19:57
MySQL related Installation Problem crn_admin Installation/Configuration 5 10th August 2006 19:03


All times are GMT +2. The time now is 13:42.


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