Hello,
I recently installed MySQL 5 and PHP 5 and am having problems. I am working from a book which tells me that my next step is to delete the anonymous user and to set the password for the root user. The first thing the book had me do was to open mysql.exe from the bin directory and type SHOW DATABASES. The book showed that there were two databases: mysql, and test. When I do it I only have test. I thought this was wierd. Anyways, I went on to delete the anonymous user. It directed me to open the Windows command prompt and type the following:
c:\mysql\bin\mysql -u root
use mysql
delete from user where User=' ';
quit
c:\mysql\bin\mysqladmin -u root reload
Im not sure if I need to be pressing [ENTER] at the end of each line or not. I pressed enter at the end of each line, the result was a bunch of info being displayed. None of which confirmed that I had deleted the anonymous user. Can anyone steer me in the right direction? Also, the book gives the same confusing method of setting the password for the root user, but does not give me a means of confirming that ive done it successfully. Please help!!!!!!
Oh yeah, when I attempt to CREATE DATABASE database_name, i get a "you do not have the authority" type message....
