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 (Sorry for duplicatoin)


--DT

Try:
mysql> use old_data;
Also check if your old_data database has the correct rights.

hi bathory:
Thanks for replying.

I changed the rights of old_data folder, so its right is identical to "test". However, i still can not access the old_data at the mysql promt:

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

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)



How can i make old_data one the the database the i can use ?




--DT

You don't have the "mysql" database, which is used to store users, passwords, rights etc.
I don't know if the installation using RPMs should have created it, but since it does not exist you must create it prior running mysqld for the first time. In the source and binary distributions there is a script named "mysql_install_db" which creates the initial mysql database. Search for it in your installation location and run it.
Another thing you have to take care is that perhaps old_data uses isam tables while mysql 4.x uses myisam. If that's the case you must run another script named "mysql_convert_table_format" to convert isam to myisam. Take a look here for more details about upgrading from 3.x to 4.x.

Regards

can anyone tell me from where i can read mysql in linux


and i also need to know how to know about errors

is there any directory or sth which tells which error means what

whenever i am writing create database helo;

it gives error

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'helo'

please tell me why this is happening

and how to use mysql i have istalled it
when i am givien command
show databases;
it shows but others not working
tell me please