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


--DT

I suggest you can check the folder's permission first.
It's must owned by mysql user, the mysqld daemon owner.

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.

--DT

It's Wired that when i types in rpm -q -a |grep mysql
==>
MySQL-server-4.1.11.0
MySQL-client-4.1.11.0

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

Any one know what is gonning on?

Thanks.

-DT