Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.


  Search this Thread
Old 05-02-2005, 03:19 PM   #1
LQ Newbie
Registered: Mar 2005
Posts: 19

Rep: Reputation: 0
Access old data with newly installed MySQL

Hi all:
I am stuck on this for days , please help me if you can. All suggestions are wellcomed.

I have a RHEL 3.0 server running. Mysql 3.X was installed, and i removed that and its related packages (to get rid of the installation conflict).

Before i install 4.x rpm , runing "rpm -q -a | grep -i mysql " returned nothing. After runing these two commands below, i didnt do anything, and when i logged in again, i can get a promt by typing mysql at the shell.

rpm -i MySQL-client-4.1.11-0.i386.rpm
rpm -i MySQL-server-4.1.11-0.i386.rpm

My old data is in /var/lib/mysql/old_data, and the data created by the newly installed mysql 4.x is in the same directory: /var/lib/mysql/test
I tried create table in database test, it works, and i can see those file in the /var/lib/mysql/test/ folder.

At the mysql promt

mysql> use olddata;
ERROR 1044 (42000): Access denied for user ''@'localhost' to 'database olddata'

mysql> use test;
====> OK for creating table

I tried the above command as user 'mysql', and 'normal user'
As a root, i couldnt get the mysql promt.

So I want to access those old data again, any sugguestions ?

Many Thanks

Old 05-05-2005, 10:53 PM   #2
LQ Newbie
Registered: Sep 2004
Location: China
Distribution: Debian 3.0r2 unstable
Posts: 28

Rep: Reputation: 15
I suggest you can check the folder's permission first.
It's must owned by mysql user, the mysqld daemon owner.
Old 05-06-2005, 06:02 PM   #3
LQ Newbie
Registered: Mar 2005
Posts: 19

Original Poster
Rep: Reputation: 0
Hi NetSnake:

No luck. I checked the right for old_data, and test, and they have the same right.
Any other suggestions?

Thank you very much.

Old 05-06-2005, 06:11 PM   #4
LQ Newbie
Registered: Mar 2005
Posts: 19

Original Poster
Rep: Reputation: 0
It's Wired that when i types in rpm -q -a |grep mysql

However, when i tried "rpm -e MySQL-server-" , it said packet is not installed. I can get the access to mysql> promt.

Any one know what is gonning on?




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
Access old data with newly installed MySQL dt4stat Linux - Newbie 5 12-05-2005 01:51 AM
Newly Installed Apps arpanetguru Linux - Newbie 2 11-25-2005 09:41 PM
How to configure newly installed Macintosh access to Linux shared drives mrmandms Linux - Networking 4 09-08-2005 05:04 PM
MySQL Access problem from Aqua Data Studio stedo Linux - Software 0 10-03-2003 02:57 AM
newly installed programs... tang Linux - Software 2 09-10-2003 08:41 AM > Forums > Enterprise Linux Forums > Linux - Enterprise

All times are GMT -5. The time now is 09:37 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