Hi!
{FromDOcs}
There two accounts are created with a username of root.The initial root account passwords are empty, so anyone can connect to the MySQL server as root without a password .
Try this..
Start the mysql server
c:\mysql\bin\>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(root@localhost) [(none)]>
or
c:\mysql\bin\>mysql -uroot -p
Enter Password: Press Enter
C:\mysql\bin>mysql -u root -p
Enter password: Press Enter
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(root@localhost) [(none)]>
Take a look at here for how to change initial passwotd etc..
http://dev.mysql.com/doc/mysql/en/default-privileges.html
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221