Running MySQL from command line [closed]

Question

I have very recently installed MySQL using Zend Server in an effort to learn PHP and MySQL.

Installation went perfectly, however I installed it in my E: Drive as opposed to installing it in C drive. To launch it from the command line I am given to understand one must type, the following.

"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" -u root

or some variant. In my case, mysqld is in E:\Zend\MySQL55\bin.

However when I type in E:\Zend\MySQL55\bin\mysqld, the command line freezes and I can no longer enter anything. If I simply open the .exe file from the folder it's in, a command prompt window opens up and in the same sense freezes and I can't access it.

Is there another way to open it or is what I'm doing close but slightly wrong?

Answer 1

For starting the server,

 C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console

To login, open a new command prompt window,

 C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql -u root

Then it will ask for password and you can enter

Answer 2

In fact, mysqld is the server. If you want to launch the client you have to call mysql

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql -u root