Linux restart MySQL command

 linux restart MySQL commandTags: mysqllinuxservice script Web Service server2010-06-25 10:21 62152 People read comments (0) favorite reports Classification:Linux (6)

How to start/stop/restart MySQL

First, the starting mode

1. Start with service: Service mysqld start

2. Start with mysqld script:/etc/inint.d/mysqld start

3. Use Safe_mysqld to start:safe_mysqld&

Second, stop

1. Start with service: Service mysqld stop

2. Start with mysqld script:/etc/inint.d/mysqld stop

3, mysqladmin shutdown

Third, restart

1. Start with service: Service mysqld restart

2. Start with mysqld script:/etc/inint.d/mysqld restart
Question Editor Summary


How to start/stop/restart MySQL
First, the starting mode

1. Start with service: Service mysqld start

2. Start with mysqld script:/etc/inint.d/mysqld start

3. Use Safe_mysqld to start:safe_mysqld&

Second, stop

1. Start with service: Service mysqld stop

2. Start with mysqld script:/etc/inint.d/mysqld stop

3, mysqladmin shutdown

Third, restart

1. Start with service: Service mysqld restart

2. Start with mysqld script:/etc/inint.d/mysqld restart

When I first started to learn MySQL, I brought it with Redhat. What's the start/rc.d/init.d/start
This is very simple, but later the more learning, the system comes with MySQL, some versions are too low, some with
The low version of MySQL that you want the Web service to install


Later I learned to install MySQL in tar, my MySQL installed in the/usr/local/mysql directory


Have encountered many problems. The most common are:
ERROR 2002:can ' t connect to local MySQL server through socket


'/tmp/mysql.sock ' (111)


Workaround:
[Email protected] mysql]#/usr/local/mysql/bin/mysqladmin-u root/
>-s/var/lib/mysql/mysql.sock password ' your.passwd '
or make a connection.
Ln-s/var/lib/mysql/mysql.sock/tmp
In fact, the hint can not find/tmp/mysql.sock sometimes not the/tmp directory does not have this file, is the boot
The order is wrong, I've met
Common several start-up methods, themselves also not remember very clearly, if you are sure TMP under has mysql.sock this
Files you might want to try a few other commands.
/usr/local/mysql/bin/mysql-u root-p
/usr/local/mysql/bin/mysqld--user=mysql&
/usr/local/mysql/bin/mysqld--user=root&
/usr/local/mysql/bin/mysqld_safe--user=root&
/usr/local/mysql/bin/mysqld_safe--user=mysql&
/usr/local/mysql/bin/safe_mysqld--uer=root& (note that safe_mysqld and Mysqld_safe are different,& that MySQL runs in the background) I'll get an error.
Stopping server from PID file
/usr/local/mysql/data/localhost.localdomain.pid
060304 11:46:21 Mysqld Ended
This is a permissions issue, my MySQL directory belongs to the root user, also belongs to the root group, switch to Mysqld_safe boot is no problem,
You just have to pay attention to these few mysql,safe_mysqld,mysqld_safe,mysqld,mysqladmin. Try More
Several times
In fact, sometimes MySQL has started normally, check whether MySQL starts the command
Ps-aux | grep mysqld
You'll see something like this
MySQL 6394 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
MySQL 6395 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
MySQL 6396 0.0 1.5 10528 992 PTS/3 S 16:16 0:00
/usr/local/mysql/
Root 6422 0.0 1.1 2408 732 PTS/3 S 16:20 0:00 grep
Mysql


See if MySQL is listening on the port command
Netstat-tl | grep MySQL
You'll see something like this
TCP 0 0 *:mysql *:* LISTEN

Linux restart MySQL command