Access to MySQL database and Creating new databases

[Digital_fx]

OK. I installed MySQL on my box and had no trouble creating users for the new database that I created. The problem I run into is when I install phpMyAdmin that I cannot seem to, from the phpMyAdmin admin page, access the MySQL database or create a new database. In the create new database area it simply states that I do not have the proper privileges. I will try to fix that. If I list the databases from phpMyAdmin it only shows the database I created and the text database. The MySQL database is not displayed. I know I've covered some area here but can anyone give me some advice. I will continue to pour through the documentation.

Thanks,

julian

[weekender]

you need to run mysql at the command prompt (which i can't remember how to do!) and execute the following query;

GRANT ALL PRIVILEGES ON . TO "user"@"%" IDENTIFIED BY "password" WITH GRANT OPTION ;

but this assumes the default user has access to create privileges