Access old data with newly installed MySQL
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 ?