Solved: Reset Root Login It seems that someone played around with my ISPConfig installation. Now I can't seem to login on either ISPConfig, nor phpMyAdmin. I know I can reset login count through phpMyAdmin (I know that from my days in a webhosting company), but I also don't seem to be able to login on that. MySQL hasn't been hacked, I can still login on MySQL through SSH. So I want to know this: What do I have to do, so I can login on phpMyAdmin? If that's done, I know the rest. Thanks in advance.
Please see FAQ: http://www.faqforge.com/linux/controlpanels/ispconfig2/how-to-reset-the-mysql-root-password/
I can't seem to stop MySQL. Code: [root@client319 mysql]#/etc/init.d/mysqld stop Stoppen van MySQL: [MISLUKT] [root@client319 mysql]#mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2847 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> update user set Password=PASSWORD('***************') WHERE User='root'; ERROR 1046 (3D000): No database selected mysql> quit Bye [root@client319 mysql]#
Please follow the steps in the tutorial exactly. The command to connect to mysql is: mysql -u root mysql and not: mysql -p
I know that. But like I said before, I can't stop MySQL. If I can't stop it, logging in without "-p" is useless. Update: I'm in! I just used the wrong IP address. D'oh! Update2: Finding the failed login count is harder then I thought (I used Kloxo at the Webhosting Company). Where is it? Update3: Sorry for this, it seems I just confused 'admin' with 'root'. Well, problem solved.