How to starting MySQL?
The following will not be needed if you have installed MySQL as a service.
Start MySQL Database:
Lets see how to starting MySQL from the windows command line manually.
To start the mysqld
from the command line, first you should open a console window i.e., Start -> Run.., type cmd or command to open the console window. After opening the console window, enter the path where your MySQL is installed. For example:
C:> "C:Program FilesMySQLMySQL Server 4.1bin"
After giving the path, starting MySQL as given below:
C:Program FilesMySQLMySQL Server 4.1bin> mysqld
The version depends upon the mysql server you have installed. The path may also vary depending on the MySQL installation on your system.
You can stop the MySQL server using the below command:
C:> "C:Program FilesMySQLMySQL Server 4.1binmysqladmin" -u root shutdown