mysql启动后在哪里编程_Mysql启动的方式(四种)

废话不多说了，直奔主题了。

MysqL的四种启动方式:

启动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 <> /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启动方式，希望对大家有所帮助！

总结

以上是编程之家为你收集整理的Mysql启动的方式(四种)全部内容，希望文章能够帮你解决Mysql启动的方式(四种)所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250