一、启动和关闭mysql服务
1、windows下
(1)noinstall安装的mysql,可以在dos窗口
C:\Users\v_liuyang20>cd C:\Program Files\MySQL\MySQL Server 5.6\bin
C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --console
C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --console
(2)在命令行中手工启动和关闭
C:\Program Files\MySQL\MySQL Server 5.6\bin>net start mysql5
C:\Program Files\MySQL\MySQL Server 5.6\bin>net stop mysql5
2、Linux下
(1)查看mysql服务状态
C:\Program Files\MySQL\MySQL Server 5.6\bin>netstat -nlp
(2)通过命令行方式
cd /usr/bin
./mysqld_safe &
starting mysqld daemon with databases from /var/lib/mysql
mysqladmin -uroot shutdown
(3)通过服务方式,RPM方式安装
service mysql start
service mysql restart
service mysql stop