Page 1 of 1

MySql console problem

PostPosted: 06. January 2009 17:34
by 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?

Re: MySql console problem

PostPosted: 06. January 2009 19:39
by 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.

Re: MySql console problem

PostPosted: 07. January 2009 15:42
by DirtyDawg
Image

mysql console works as a standalone as seen above.

EDIT : someone said add "add -u root"

how would i type the line lol.

Re: MySql console problem

PostPosted: 07. January 2009 21:34
by 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.)

Re: MySql console problem

PostPosted: 08. January 2009 14:34
by DirtyDawg
Found the answer :)

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

Sorted. :lol: