Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th July 2010, 15:13
YamiHoshi YamiHoshi is offline
Junior Member
 
Join Date: Jul 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Last edited by YamiHoshi; 27th July 2010 at 16:15.
Reply With Quote
Sponsored Links
  #2  
Old 27th July 2010, 15:14
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,453
Thanks: 813
Thanked 5,222 Times in 4,092 Posts
Default

Please see FAQ:

http://www.faqforge.com/linux/contro...root-password/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th July 2010, 15:27
YamiHoshi YamiHoshi is offline
Junior Member
 
Join Date: Jul 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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]#
Reply With Quote
  #4  
Old 27th July 2010, 15:31
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,453
Thanks: 813
Thanked 5,222 Times in 4,092 Posts
Default

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

mysql -u root mysql

and not:

mysql -p
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 27th July 2010, 15:33
YamiHoshi YamiHoshi is offline
Junior Member
 
Join Date: Jul 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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.

Last edited by YamiHoshi; 27th July 2010 at 16:15.
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
Flash Player (version 10.0r22) did not load bobwdn HOWTO-Related Questions 10 11th September 2011 11:08
automatic webmail link admins Installation/Configuration 16 22nd June 2009 16:42
Setting up a new server - Suse 11.1 londonman Server Operation 34 10th April 2009 13:16
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36
Add Webmin to the system sushestvo Installation/Configuration 44 21st August 2007 16:52


All times are GMT +2. The time now is 18:03.


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