seems you are not logged in as root.
When you first install MySQL, there are 2 users: " " and "root". As they both run on your localhost in this instance.
so if u have not set a password for the root user (root@localhost) just log in as root.
if you DO have a password just log in as root:
without password:
C:\MySQL\bin\mysql -u root [ENTER]
("mysql" to start, -u <username> to spcify username)
WITH password:
C:\MySQL\bin\mysql -u root -p
("mysql" to start, -u <username to specify username and -p to let mysql know you want to be asked for a password)
You should get something like this:"
Code:
C:\MySQL\bin>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL conection id is 2 to server version 4.1.12a-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> _
If it works, good luck,
if not, you can contact me through MSN messenger (club662@hotmail.com) i will try to help you as much as i can as these forums are kinda slow.