Re: Connecting to user Thru MySql Prompt

[Roland Bouman]

Hi,

I do this by first opening a command prompt (cmd for winxp/2000/NT , or command with win98/95). Assuming the MYSQLINSTALLDIR\bin directory is in your PATH system variable, you then type the name of the executable mysql.exe, postfixed by whatever options you desire. Check your manual 8.3 on this.
for example:
--------------------------------------------------------------------------
D:\>cd MySQL5.0\bin

D:\MySQL5.0\bin>mysql --database=test --user=root --password=mysqlroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.7-beta-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
---------------------------------------------------------------------------

Good luck