MySQL monitor

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL monitor

Postby JoanW » 31. October 2005 16:41

I cannot access the MySQL monitor... cannot get to the mysql> prompt.

Double clicking on mysql.exe or mysqld.exe causes a dos window to open but it quickly beeps and disappears. MySQL is running. How can I execute a command if I can't get to a prompt? After fighting with MySQL for over two weeks, I am about to come to the conclusion that I do not have the mental apptitude for MySQL. I thought downloading XAMPP package would help but it doesn't. Can / will someone kindly explain to me what is evidently my own personal operator problem?
JoanW
 
Posts: 17
Joined: 31. October 2005 16:32
Location: Hattiesburg, MS USA

Postby cj_nza » 01. November 2005 09:15

There are several ways of getting to mySQL.

One way is to connect through the windows command prompt. This is achieved by
1) opening the windows command prompt (don't double click mysql.exe)
2) navigate to the directory where mysql.exe is located.
3) call mysql with user parameters eg "mysql -u [root] -p" press return

Another way is to use phpmyadmin (bundled with xampp) which provide a html interface to mySQL (navigate to this through from the XAMPP screen)
enter 127.0.0.1 in your browser address.

Personally I use mySQL Admin and mySQL Query browser from mysql.com for server admin and client.
cj_nza
 
Posts: 53
Joined: 06. September 2005 11:49

Postby JoanW » 01. November 2005 23:30

Thank you very much for responding. It is working now. I appreciate your help.


cj_nza wrote:There are several ways of getting to mySQL.

One way is to connect through the windows command prompt. This is achieved by
1) opening the windows command prompt (don't double click mysql.exe)
2) navigate to the directory where mysql.exe is located.
3) call mysql with user parameters eg "mysql -u [root] -p" press return

Another way is to use phpmyadmin (bundled with xampp) which provide a html interface to mySQL (navigate to this through from the XAMPP screen)
enter 127.0.0.1 in your browser address.

Personally I use mySQL Admin and mySQL Query browser from mysql.com for server admin and client.
JoanW
 
Posts: 17
Joined: 31. October 2005 16:32
Location: Hattiesburg, MS USA

Postby dtommy79 » 25. August 2008 06:45

Hi,

I have the same problem. But I don't really know what a "windows command prompt" is. Could you explain me how to bring up the mysql monitor?

Thanks
dtommy79
 
Posts: 9
Joined: 24. June 2008 21:43
Operating System: Windows 10

Postby Dave_L » 25. August 2008 10:37

Which version of Windows?

On WinXP:

Start menu >> Programs >> Accessories >> Command Prompt
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43

Postby dtommy79 » 25. August 2008 10:48

Dave_L wrote:Which version of Windows?

On WinXP:

Start menu >> Programs >> Accessories >> Command Prompt


Yes xp thanks.

I tried but I cannnot access the mysql monitor.

When i try to start I get this message:

ERROR 1045 (28000): Access denied for user 'ODBC'@' localhost' (using password: NO)
dtommy79
 
Posts: 9
Joined: 24. June 2008 21:43
Operating System: Windows 10

Postby Wiedmann » 25. August 2008 12:03

When i try to start I get this message:

The MySQL command lien tool have some parameters. Especially for user and password.

See the MySQL-Manual for an example:
http://dev.mysql.com/doc/refman/5.0/en/mysql.html
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests