MySql console problem

[DirtyDawg]

Hi i am new to xampp and am confused lol.

When i try and use the console ver of mysql.exe to create a database using
"create database testing;"

i get
"ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'testing'"

i have set up the database password using the security page etc, any ideas what i am doing wrong?

[Nobbie]

>When i try and use the console ver of mysql.exe

Run a "mysql.exe --help" and find out, which options and command line parameters to supply, what you didnt. You cannot run mysql.exe standalone without any parameters.

[DirtyDawg]

mysql console works as a standalone as seen above.

EDIT : someone said add "add -u root"

how would i type the line lol.

[Wiedmann]

how would i type the line lol.

With your keyboard? ...

(BTW: Don't doubleclick the exe in explorer. Use the "Run" button in your start menu.)

[DirtyDawg]

Found the answer

Just had to type "mysql -u root -p"

Sorted.