Home > Database > Mysql Tutorial > Mysql启动的方式(四种)_MySQL

Mysql启动的方式(四种)_MySQL

PHP中文网
Release: 2016-05-27 13:44:26
Original
1274 people have browsed it

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

mysql的四种启动方式:

1、mysqld

启动mysql服务器:./mysqld --defaults-file=/etc/my.cnf --user=root

客户端连接:

mysql --defaults-file=/etc/my.cnf
or
mysql -S /tmp/mysql.sock
Copy after login

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
Copy after login

3、mysql.server

cp -v /usr/local/mysql/support-files/mysql.server /etc/init.d/
chkconfig --add mysql.server
Copy after login

启动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 &#39;mysqladmin&#39;@&#39;localhost&#39; identified by &#39;mysqladmin&#39; with grant option;
#mysql -S /tmp/mysql3307.sock
mysql>GRANT SHUTDOWN ON *.* TO &#39;mysqladmin&#39;@&#39;localhost&#39; identified by &#39;mysqladmin&#39; with grant option;
Copy after login

启动mysql服务器:./mysqld_multi --defaults-file=/etc/my.cnf start 3306-3307

关闭mysql服务器:mysqladmin shutdown

以上就是Mysql启动的方式(四种)_MySQL的内容,更多相关内容请关注PHP中文网(m.sbmmt.com)!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template