Page 1 of 1

MySQL Newbie issues

PostPosted: 21. February 2007 04:17
by kk2die4
This is probably a very dumb question , but here goes

I have XAMPP installed and am trying to figure out how to start and use
mySQL. In the main window, it says , MySQL started, but I am unable
to find out how to start the SQL> prompt.

I tried running this on the cmd line , but nothing was happening. This is
while mysql was running thro' XAMPP. What am I doing wrong ? How do I get the sql prompt ?

-------------------------------------------------------------------------------

C:\Program Files\xampp\mysql\bin>mysqld

C:\Program Files\xampp\mysql\bin>
C:\Program Files\xampp\mysql\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\Program Files\xampp\mysql\bin>
C:\Program Files\xampp\mysql\bin>
C:\Program Files\xampp\mysql\bin>mysqltest
mysqltest: Could not open connection 'default': 1045 Access denied for user 'ODBC'@'localhost' (using password: NO)
not ok

C:\Program Files\xampp\mysql\bin>
C:\Program Files\xampp\mysql\bin>
C:\Program Files\xampp\mysql\bin>

PostPosted: 21. February 2007 08:32
by Wiedmann
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

I guess, the user/password you are used for the connection is wrong.

C:\Program Files\xampp\mysql\bin>mysql

Oh funny :wink:, you don't use any user/password.

Question:
You have looked in the MySQL manual how to use the (any) command line client?

Maybe that'a a good starting point:
http://dev.mysql.com/doc/refman/5.0/en/ ... grams.html
(a list with all clients with links how to use them)

Thanks

PostPosted: 21. February 2007 14:48
by kk2die4
C:\Program Files\xampp\mysql\bin>mysql

Oh funny :wink:, you don't use any user/password.


Touche' Mr Weidmann :oops:

Thanks for the starting info. That's why we are called Newbies
:P

Question:
You have looked in the MySQL manual how to use the (any) command line client?

Maybe that'a a good starting point:
http://dev.mysql.com/doc/refman/5.0/en/ ... grams.html
(a list with all clients with links how to use them)[/quote]