Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 01-09-2003, 06:13 AM   #1
LQ Newbie
Registered: Jan 2003
Posts: 1

Rep: Reputation: 0
Unhappy Lost privileges for MySQL !!!


Thought I might see if you could help ??

I have a small office network with a Cobalt Qube 3 acting as our in-house server. On the cobalt is our MySQL database. I did have everything set up with privileges, tables, asp applications etc, but yesterday I had a problem and think I have flushed all privileges, and so cannot even connect back into mysql.

I use telnet from my Win 2000 desktop, put in my username & password as if I was logging directly into the cobalt, which then prompts me:

[admin admin]$

I have tried all my old access details but nothing works, all i get is:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I just cannot log back into mysql, how can I set up new access rights if i cannot even log in through root ???

Appreciate your soonest response.

David Gordon
Old 01-09-2003, 08:15 AM   #2
Registered: Dec 2002
Location: In front of a computer
Distribution: UPS, DHL, FedEx
Posts: 466

Rep: Reputation: 38
i presume you've tried restarting the computer?
it looks like the database didn't start at all.

look for the mysql log files, maybe in /var/lib/mysql
and see the last few lines for any errors.
Old 01-09-2003, 07:00 PM   #3
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
Second that, looks like MySQL server isn't running, not that you have lost access. A "bad" password gives a different error:

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


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
Grant Privileges - MySQL Jannyno Linux - General 2 06-23-2012 02:00 AM
mySQL - local user privileges Genjix Programming 2 12-03-2004 08:03 AM
Mysql privileges question everythingand2 Linux - General 0 12-14-2003 02:29 PM
New Table Privileges in MySQL chrisk5527 Linux - General 0 11-19-2003 04:22 PM
MySQL problem with user privileges jriis Linux - Software 3 10-02-2003 09:20 AM > Forums > Linux Forums > Linux - Newbie

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

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