HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   General (
-   -   Critical: Reset Root Login (

YamiHoshi 27th July 2010 16:13

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.

till 27th July 2010 16:14

Please see FAQ:

YamiHoshi 27th July 2010 16:27

I can't seem to stop MySQL.

[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
[root@client319 mysql]#

till 27th July 2010 16:31

Please follow the steps in the tutorial exactly. The command to connect to mysql is:

mysql -u root mysql

and not:

mysql -p

YamiHoshi 27th July 2010 16:33

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.

I'm in!
I just used the wrong IP address.

Finding the failed login count is harder then I thought (I used Kloxo at the Webhosting Company).
Where is it?

Sorry for this, it seems I just confused 'admin' with 'root'.
Well, problem solved.

All times are GMT +2. The time now is 06:08.

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