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,