#1  
Old 14th February 2013, 14:43
dimas dimas is offline
Senior Member
 
Join Date: Jul 2006
Posts: 125
Thanks: 7
Thanked 27 Times in 8 Posts
Default MySQL problem

Hello everybody, I have a big problem on a production server (ISPConfig 3.0.4.6, Debian Squeeze 64-bit, Perfect Setup)

I noticed that I can't create new mysql databases via ISPConfig interface. A line with a new database actually appears, but no new database is actually created - and there's nothing new in /var/lib/mysql

I tried to log in as mysql root user via shell - and there was another nasty surprise - it said access denied (wrong credentials)!

So something - or someone - changed my root mysql password.

I still CAN login as other regular mysql users.

I tried to reset the root user password by using this howto:

http://www.howtoforge.com/reset-forg...-root-password

but this line

mysqld_safe --skip-grant-tables

doesn't start mysql, it just hangs...

So - was the server hacked, or something just went wrong?

Is there a way to somehow revive the server?

I'd welcome any advice!
Reply With Quote
Sponsored Links
  #2  
Old 14th February 2013, 15:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
Default

Quote:
doesn't start mysql, it just hangs...
Thats ok, the prompt does not return when mysql runs. Please see guide from ispconfig faq, you have to add a & after the command to send it to background so that you can continue with the next commands:

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 14th February 2013, 16:13
dimas dimas is offline
Senior Member
 
Join Date: Jul 2006
Posts: 125
Thanks: 7
Thanked 27 Times in 8 Posts
Default

Dear Till, thank you, but this is what is happening:

root@server2:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@server2:~# mysqld_safe skip-grant-tables &
[1] 5790
root@server2:~# 130214 19:07:47 mysqld_safe Logging to syslog.
130214 19:07:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130214 19:07:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

- and no prompt appears (I waited a long time)

If I try to input the next command from another shell window, I get:

root@server2:~# mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Reply With Quote
  #4  
Old 14th February 2013, 16:27
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
 
Default

Quote:
- and no prompt appears (I waited a long time)
Thats ok, the mysql program has no prompt. It just starts and gets to the background as ID [1] 5790.

Quote:
If I try to input the next command from another shell window, I get:

root@server2:~# mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
[ask] MYSQL and PhpMyAdmin Problem Login m4l41k4t General 1 11th October 2012 08:47
MySQL problem - Sometimes cann't connect to MySQL Ronniea Server Operation 2 16th July 2012 21:01
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 18:40


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


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