Hi

I have installed Mysql 4.1 on fedora core 4.
after starting mysqld for first time ,i set root password using
mysqladmin -u root password 'pass'
after this i was able to do every thing after loging using
mysql -u root -p
but now when i login using the same command and i issue tke command
show databases;
it shows only test database, not the mysql database.
when i isue command
use mysql;
it gives me error
access denied for user root@localhost on database mysql;
Please help me in finding out why this happen.

Thanks & Regards
Ashish tyagi

My comes here...

Are you sure that the mysql-database has been created in the install procedure.
If it isn't , you will need to create it with

Second solution that comes to my mind, is the user right for the folder, where MySQL stores its data. Maybe the MySQL-user group is missing?
Check if user and group have correct right to that folder. In suse its /var/lib/mysql

Hi
mysql database was created at the time of installation and i was able to use it.
I have checked folder permissions of /var/lib/mysql it belongs to mysql. and permissions are
755 mysql mysql

Don't you need to supply the password for MySql's root user too?

You can also add "-D database_name" to directly start using one of the databases.

Furthermore, I think your syntax in
is incorrect too.
You're supposed to use either:
--password='some_passwd'
or -p 'some_passwd'
where you need to replace 'some_passwd' with the actual password, of course.
Don't mix the 2 syntaxes, otherwise it may still work, but it won't do what you are trying to accomplish.