Once you have Installated MySQL server on your Windows Dedicated server you will have to Start MySQL on it. Now, this process can be difficult if you do not follow the steps properly. You can follow the steps given below to Start MySQL from the Windows Command Line :

Note : These steps can be used to start MySQL on any Version of Windows. There are no such restrictions depending on the version.

1) You will have to start the Console Window which is also known as DOS window to start the mysqld server from the Command Line and enter the Command given below :

C:\> “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld”

2) Path of mysqld on your Windows Dedicated server will depend on the Location on which MySQL is installed on your Windows Dedicated server.

It is also possible for you to stop the working of MySQL Server on your Windows Dedicated server by simply executing the below Command :

C:\> “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin” -u root shutdown

Important : You will have to bring in the mysqladmin with the -p option if the MySQL root user account has a password and you will need to provide the password when it is asked for.

3. Once the above command is used, it brings the MySQL Administrative utility into action and informs mysqladmin to establish a connection with the server and tells it to shutdown.

4. The Default Administrative account in the MySQL System is the MySQL Root user and the command is responsible to connect as the same.

Important : Users in the MySQL Grant system are independent from any other users using logins under Windows.

5. Now, if you are facing a problem with the starting of MySQL then you should check the error logs to see whether the Server dropped any messages there to indicate the main reason for the problem.

6. Most probably, the error logs in Windows Dedicated server is found in the C:\Program Files\MySQL\MySQL Server 5.1\data which is a directory. This file is found with a suffix which is .err (which basically means error).

Note : If the above steps don’t work for you, you can also try to start the server using mysqld –console. If you use this command to start the server, you may get some useful information on the Screen that will help you to get rid of the problem which you are facing.

7. Now, if the above solutions don’t work for you then you will only have a single option available for you which is to start mysqld with the –standalone and debug options.

8. In the above solution, mysqld writes a log file C:\mysqld.trace which should give you the answer why mysqld does not start.

Note : You can also use the Command mysqld –verbose –help to check all the options which is avialable and are supported by mysqld.

Social Bookmarking

Trackback URI | Comments RSS