How to stop,start and restart mysql in command line
we can stop,start or restart mysql by simply passing parameters to mysqld process. mysqld is the main program that does the most of the work in mysql. Look at the following examples.
In case if you are working in LAMPP environment then the above commands would be,
/opt/lampp/bin/mysql stop
/opt/lampp/bin/mysql start
/opt/lampp/bin/mysql restart
Some of the linux distributions offers this process as service too, so there you have to provide commands as following:
service mysql stop
service mysql start
service mysql restart
--- OR ---
service mysqld stop
service mysqld start
service mysqld restart
Not all kind of linux distributions follows same method to start,stop or restart mysql, So I have given various types, use any one which works for you.
Stop MySQL
/etc/init.d/mysqld stop
Start MySQL
/etc/init.d/mysqld start
Restart MySQL
/etc/init.d/mysqld restart
In case if you are working in LAMPP environment then the above commands would be,
/opt/lampp/bin/mysql stop
/opt/lampp/bin/mysql start
/opt/lampp/bin/mysql restart
Some of the linux distributions offers this process as service too, so there you have to provide commands as following:
service mysql stop
service mysql start
service mysql restart
--- OR ---
service mysqld stop
service mysqld start
service mysqld restart
Not all kind of linux distributions follows same method to start,stop or restart mysql, So I have given various types, use any one which works for you.
Comments (0)