Starting MySQL from the command line

Question

I recently installed MySQL using Zend Server to learn PHP and MySQL.

The installation went fine, but I installed it on my E: Drive, and not in the installation on drive C. To start it from the command line, I was given to understand what to type, the following.

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

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

However, when I type E:\Zend\MySQL55\bin\mysqld , the command line freezes and I can no longer enter anything. If I just open the .exe file from the folder in which it is located, the command prompt window opens and freezes in the same sense, and I cannot access it.

Is there any other way to open it or what am I doing, but a little wrong?

Answer 1

To start the server

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

To log in, open a new command prompt window,

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

Then it will ask for a password, and you can enter

Answer 2

In fact, mysqld is a server . If you want to start the client, you must call mysql

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