MYSQL Server start and stop in Windows

 Before i start, i want to introduce you with MYSQL server. MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems .

Now we discuss about the issue we face during starting and stopping the MySQL server. It is irritating issue for the beginners. After the full installation of MySQL server in windows, You need to understand how can you make a smooth start for MYSQL. The Steps are given below.

For Linux 

Start MySQL Server

1. sudo service mysql start.
2. sudo /etc/init.d/mysql start.
3. sudo systemctl start mysqld.

For Windows

1. Start cmd
2. Go to the "C:\Program Files\MySQL\MySQL Server 5.1\bin"  // check your version
3. mysqld

But sometimes this cause error then 

We need to add this as a service to easy start

1. "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" --install
   If you don't run cmd as Administrator, you'll see Install/Remove of service denied.,

2. net start MYSQL //for version upto 5.0

use   net start MySQL80  // above version 5.0