MySQL monitor

[JoanW]

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?

[cj_nza]

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]

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

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.

[dtommy79]

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

[Dave_L]

Which version of Windows?

On WinXP:

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

[dtommy79]

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)

[Wiedmann]

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