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-server-ubuntu-9.04-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
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.
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