本篇文章给大家分享的是有关MySQL四种启动方式分别是什么，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。
 
 
 
mysql的四种启动方式:
 
1、mysqld
 
启动mysql服务器:./mysqld –defaults-file=/etc/my.cnf –user=root
 
客户端连接:
 
mysql –defaults-file=/etc/my.cnf
 
or
 
mysql -S /tmp/mysql.sock
 
2、mysqld_safe
 
启动mysql服务器:./mysqld_safe –defaults-file=/etc/my.cnf –user=root &
 
客户端连接:
 
mysql –defaults-file=/etc/my.cnf
 
or
 
mysql -S /tm/mysql.sock
 
3、mysql.server
 
cp -v /usr/local/mysql/support-files/mysql.server /etc/init.d/
 
chkconfig –add mysql.server
 
启动mysql服务器:service mysql.server {start|stop|restart|reload|force-reload|status}
 
客户端连接:同1、2
 
4、mysqld_multi
 
mkdir $MYSQL_BASE/data2
 
cat <<-eof>> /etc/my.cnf
 
[mysqld_multi]
 
mysqld = /usr/local/mysql/bin/mysqld_safe
 
mysqladmin = /user/local/mysql/bin/mysqladmin
 
user = mysqladmin
 
password = mysqladmin
 
[mysqld3306]
 
port            = 3306
 
socket          = /tmp/mysql3306.sock
 
pid-file = /tmp/mysql3306.pid
 
skip-external-locking
 
key_buffer_size = 16M
 
max_allowed_packet = 1M
 
table_open_cache = 64
 
sort_buffer_size = 512K
 
net_buffer_length = 8K
 
read_buffer_size = 256K
 
read_rnd_buffer_size = 512K
 
myisam_sort_buffer_size = 8M
 
basedir = /usr/local/mysql
 
datadir = /usr/local/mysql/data
 
[mysqld3307]
 
port            = 3307
 
socket          = /tmp/mysql3307.sock
 
pid-file = /tmp/mysql3307.pid
 
skip-external-locking
 
key_buffer_size = 16M
 
max_allowed_packet = 1M
 
table_open_cache = 64
 
sort_buffer_size = 512K
 
net_buffer_length = 8K
 
read_buffer_size = 256K
 
read_rnd_buffer_size = 512K
 
myisam_sort_buffer_size = 8M
 
basedir = /usr/local/mysql
 
datadir = /usr/local/mysql/data2
 
EOF
 
#mysql -S /tmp/mysql3306.sock
 
mysql>GRANT SHUTDOWN ON *.* TO 'mysqladmin'@'localhost' identified by 'mysqladmin' with grant option;
 
#mysql -S /tmp/mysql3307.sock
 
mysql>GRANT SHUTDOWN ON *.* TO 'mysqladmin'@'localhost' identified by 'mysqladmin' with grant option;
 
启动mysql服务器:./mysqld_multi –defaults-file=/etc/my.cnf start 3306-3307
 
关闭mysql服务器:mysqladmin shutdown
 
以上就是MySQL四种启动方式分别是什么，小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注亿速云行业资讯频道。