No command line/MySQL.exe (XAMPP).

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

No command line/MySQL.exe (XAMPP).

Postby itxweather » 07. November 2005 21:21

Hello,

Am trying to work through Sitepoint's Database Driven Website 2nd Edition and have downloaded XAMPP. php seems to be working but i'm having problems in logging on to MySQL via c:\mysql\bin or Program Files\xampp\mysql as mysql isn't installed in root from what I can gather, double-clicked on mysql.exe, command line window quickly appears but disappears .

Am running WinXP with SP2. Any idea's where i'm going wrong and how I can get a command line, ready to run the MySQL client program and connect to MySQL server?.

Any comments would be appreciated.
Thank you.

Best Regards.
itxweather
 
Posts: 2
Joined: 07. November 2005 19:43

Postby deepsurfer » 08. November 2005 15:53

to use XAMPP-mysql with command line
open CMDwindow

cd c:\xampp\mysql\bin
and now you can use mysql commands
chirio Deep
Wie sagte einst der MCP aus Tron auf dem Bildschirm zu schreiben Pflegte
" ... end of communication ... "
User avatar
deepsurfer
AF Moderator
 
Posts: 6440
Joined: 23. November 2004 10:44
Location: Cologne
Operating System: Win-XP / Win7 / Linux -Debian

Postby itxweather » 08. November 2005 18:21

deepsurfer wrote:to use XAMPP-mysql with command line
open CMDwindow

cd c:\xampp\mysql\bin
and now you can use mysql commands


Hi, Thank you for your reply. xampp wasn't installed in root of c:\ however has now been copied into root. Typed in mysql.exe and the following error message appears: ERROR 1045 (28000): Access denied for user 'ODBC'@ localhost' (using password: NO). Any idea's how I can get this up and running?. Your comments would be appreciated. Thank you. Best Regards.
itxweather
 
Posts: 2
Joined: 07. November 2005 19:43

Postby GaryHobson2002 » 29. November 2005 16:09

Ich erhalte exakt die gleiche Fehlermeldung wie itxweather, wenn ich den Anweisungen folge, also

ERROR 1045 (28000): Access denied for user 'ODBC'@ localhost' (using password: NO).

Soweit ich weiß, ist doch standardmäßig kein Passwort eingestellt... ?
GaryHobson2002
 
Posts: 5
Joined: 26. November 2005 20:25

Postby deepsurfer » 29. November 2005 16:25

Hi, Thank you for your reply. xampp wasn't installed in root of c:\ however has now been copied into root. Typed in mysql.exe and the following error message appears: ERROR 1045 (28000): Access denied for user 'ODBC'@ localhost' (using password: NO). Any idea's how I can get this up and running?. Your comments would be appreciated. Thank you. Best Regards.


ok.... i see you have this:
c:\Program Files\xampp\mysq\bin ;)
and then you can use mysql -u root localhost ............
chirio Deep
Wie sagte einst der MCP aus Tron auf dem Bildschirm zu schreiben Pflegte
" ... end of communication ... "
User avatar
deepsurfer
AF Moderator
 
Posts: 6440
Joined: 23. November 2004 10:44
Location: Cologne
Operating System: Win-XP / Win7 / Linux -Debian


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 2 guests