#1  
Old 5th April 2013, 23:04
cwtudor cwtudor is offline
Junior Member
 
Join Date: Jul 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql root login

unable to login as root, mysql seems to be running fine. I can login to a database just not as root.

root@shv:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


Try to stop mysql so I could start in safe mode with no luck. I get this

root@shv:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld failed!.


what does daemon.error mean here

root@shv:~# ps ax | grep mysql
719 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
720 ? S 0:00 logger -t mysqld -p daemon.error
805 pts/0 S+ 0:00 grep mysql
1442 ? S 0:00 /bin/sh /usr/bin/mysqld_safe

this should be my password.
root@shv:~# cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf
<?php

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = 'imhotep';

?>

can not login as admin it ISP Config now either. HELP Please
Reply With Quote
Sponsored Links
  #2  
Old 6th April 2013, 06:39
darinpeterson darinpeterson is offline
HowtoForge Supporter
 
Join Date: Nov 2011
Posts: 153
Thanks: 35
Thanked 13 Times in 13 Posts
Default

I had a similar problem. Maybe see here to find a solution: http://stackoverflow.com/questions/1...317679_6927879

Regards,
Darin
Reply With Quote
  #3  
Old 8th April 2013, 15:26
cwtudor cwtudor is offline
Junior Member
 
Join Date: Jul 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default can not log in as root

Sorry none of the suggestions worked. Can not log in as root and can not stop mysql service.
Reply With Quote
  #4  
Old 8th April 2013, 16:00
cwtudor cwtudor is offline
Junior Member
 
Join Date: Jul 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks got it fixed

Thanks for all the help. I was able to fix the problem this morning. Using pkill -p mysql I was able to stop mysql. I was afraid to try this before because I did not want to lose any data, but it worked without any loss. So Thanks for answer Darin.
Reply With Quote
  #5  
Old 8th April 2013, 19:58
darinpeterson darinpeterson is offline
HowtoForge Supporter
 
Join Date: Nov 2011
Posts: 153
Thanks: 35
Thanked 13 Times in 13 Posts
 
Default

Sure. Glad it worked for you...

Regards,
Darin
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
Error output from "oracle__locks" plugin on "CentOS 6.2" with "Munin 1.4.7" hakantuna Installation/Configuration 6 7th May 2012 12:35
Fail2ban error nokia80 Installation/Configuration 15 21st February 2012 04:49
saslauthd Error while Sending Mail Naja Server Operation 6 1st April 2009 20:41
Missing Email dayjahone General 7 30th June 2008 15:29
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36


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


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