Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 10-17-2007, 08:31 PM   #1
LQ Newbie
Registered: Jul 2007
Posts: 6

Rep: Reputation: 0
MySQL Root User problems

After hours of working on this I have made little progress. I am unable to connect to MySQL as the root user. I couldn't even login to mysql to find out why. I finally got it restarted with the --skip-grant-tables switch and was able to login and found out that I don't have a root mysql user setup, but I do have an admin user. So I logged in as admin and created a root user. But I still cannot login as the root user and I know the password is correct because the encrypted form that it lists in the table is the same as the admin password. When I try to login I get:

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

Not sure what to do now, but if admin can do all the things that root can, then I really don't care.

Thanks in advance.
Old 10-17-2007, 08:43 PM   #2
Registered: May 2004
Location: Iowa USA
Distribution: CentOS
Posts: 419

Rep: Reputation: 30
An admin user? This box isn't running Plesk by chance, is it? If so, the admin user is the root user. Just log in with

mysql -uadmin -p

and the password for admin. If this is a Plesk box, then I would simply delete the root user you created and use admin. If not, and you still want a root user, then you have to grant the user "root" access from localhost before you can log in from localhost as root.
Old 10-17-2007, 08:52 PM   #3
LQ Newbie
Registered: Jul 2007
Posts: 6

Original Poster
Rep: Reputation: 0
I did have Plesk on there for a day, but I thought I took care of everything that plesk did to it. How would I grant the "root" user access from localhost then?


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql Adding back root user? wh33t Linux - Software 6 10-26-2007 12:00 AM
Locked myself out of mysql...root user db table destroyed organica Linux - Server 2 12-08-2006 10:35 AM
Duplicate root user in MySQL buddhahat Linux - Newbie 4 08-29-2004 10:34 PM
Starting mysql daemon as user rather than root arubin Slackware 8 05-10-2004 04:03 PM
Connect to mysql as non root(linux) user dublinclontarf Slackware 1 02-09-2004 04:19 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 01:39 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration