creating mysql database
 

hello everybody..

i'm trying to get php to workwith mysql...and having problem.

before i used php to access mysql i did the following to create a database...
mysql> create database egineer;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE
ON egineer.*
TO egineer@localhost
IDENTIFIED BY 'mypass';

i have redhat9, php and mysql installed...

when i runn throught the above inst. i found on the net.. it creates a folder but nothing in the folder. so, i'm assuming thats why php isn't able to locate the databse causing the problem...
when i run this, i'm not getting any err msg either...

Should the above actually create a database that i should see?

what am i doing wrong...

Can you login via the console/text client with this user/pass combo?

# mysql -uengineer -pmypass

Chnages to the grant tables require reloading.. When MySQL starts up these tables are read from disk and cached in RAM. Changes require them to be re-cached.

# mysqladmin -uroot -ppassword reload

Or just stop/start the database...