i have just installed ubuntu 8 on my system, being new to the linux platform i am working my way up... i also have installed php5 and apache along with mysql server. The former two works fine.
I logged on to mysql, using just the mysql command, i tried to create a database named test.. all went fine, on this specific name 'test' every command works
Once again i tried to create another dbase this time named test2.... it showed the error " Access denied to user @ localhost to database test2 "
The same message was prompted whenever i used the create command using any other database name.
... now i tried to start mysql using the command mysql-u -p where the password is a default "NO", still the problem persisted...can anyone help!!!

Posted 8 years ago