How To Start MySql From Command Line

How To Start MySql Server From Microsoft Command Line In Microsoft Windows 8.1

1. Open your Microsoft Windows Command Line As Administrator.
   To learn how to open Microsoft Windows Command Prompt, click
   How To Launch Command Prompt
   or
   How To Launch Command Prompt In Windows 8
2. Go To MySql Server directory
   Type D: and press Enter.
3. Type CD \softRun\xampp-win32-1.6.7\mysql\bin\


   
   
   
4. Type this following command:
   mysqld --console
5. Press Enter
6. This will display mysqld status, mysql version and mysql port.
   
   
   
   
   

How To Find Out Is Mysql Running?

1. Open your Microsoft Windows Command Line As Administrator.
   To learn how to open Microsoft Windows Command Prompt, click
   How To Launch Command Prompt
   or
   How To Launch Command Prompt In Windows 8
2. Go To MySql Server directory
   Type D: and press Enter.
3. Type CD \softRun\xampp-win32-1.6.7\mysql\bin\
   
   
   
   
4. Type this following command:
   mysqladmin --user=root ping
5. Press Enter
6. This will display mysqld status is alive.
   
   
   
   
   

How To Find Out Which Mysql Port Running?

1. Open your Microsoft Windows Command Line As Administrator.
   To learn how to open Microsoft Windows Command Prompt, click
   How To Launch Command Prompt
   or
   How To Launch Command Prompt In Windows 8
2. Type this following command:
   netstat -ano | findstr 3306
3. Press Enter
4. This will display ip address and port status is LISTENING.
   
   
   

Notes

• Adjust the path based on your MySQL installation.
• To learn how to Go to MySQL directory, click Top Command Prompt (CD / CHDIR)

< to check MySql version, click How To Check MySQL Version