LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 10-17-2007, 09:31 PM   #1
nitro_punk85
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, 09:43 PM   #2
zaichik
Member
 
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, 09:52 PM   #3
nitro_punk85
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?
 
  


Reply


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 01:00 AM
Locked myself out of mysql...root user db table destroyed organica Linux - Server 2 12-08-2006 11:35 AM
Duplicate root user in MySQL buddhahat Linux - Newbie 4 08-29-2004 11:34 PM
Starting mysql daemon as user rather than root arubin Slackware 8 05-10-2004 05:03 PM
Connect to mysql as non root(linux) user dublinclontarf Slackware 1 02-09-2004 05:19 AM


All times are GMT -5. The time now is 12:12 PM.

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