LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-10-2007, 05:07 AM   #1
Buddhike G
Member
 
Registered: Jun 2007
Distribution: RHEL, CentOS, Solaris
Posts: 63

Rep: Reputation: 16
location of tables in mysql database in linux


hi

QUESTION 1


can anybody tellme the place where the tables of mysql database is stored in Read Hat linux.

QUESTION 1


All the users in the datbase was accidently deleted by me during a delete query, so that i can't login as any user to the database.
can anybody please suggest a method for me to login to the database.


Thanx in advance.

Buddhike G
 
Old 09-10-2007, 05:27 AM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,908

Rep: Reputation: 356Reputation: 356Reputation: 356Reputation: 356
1) look around in /var/lib/mysql.

2) this might help you regain access to mysql: http://dev.mysql.com/doc/refman/5.0/...rmissions.html
 
  


Reply



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
lowercase windows mysql tables became uppercase import to linux Niceman2005 Linux - Software 2 06-06-2006 02:18 AM
Finding What Tables Exist In A MySQL Database taylor_venable Programming 7 12-19-2005 09:52 PM
Update database tables on different servers securely daveedj Linux - General 0 12-13-2005 12:40 PM
mysql reinstallation distorted by previous tables in /var/mysql mad4linux Linux - Software 0 10-04-2005 01:39 PM
mysql count tables in a database Longinus Programming 2 04-11-2004 01:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:22 AM.

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
Open Source Consulting | Domain Registration