LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


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

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


Hi,

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, 09:15 AM   #2
niknah
Member
 
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, 08:00 PM   #3
wdingus
Member
 
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)
 
  


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


All times are GMT -5. The time now is 10:39 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration