1、切换到root身份
2、安装命令
sudo apt-get update
apt-get install mysql-client-core-5.6
apt-get install mysql-client-5.6
apt-get install mysql-server-5.6
3、检查mysql进程是否运行
ps -ef | grep mysql
4、查看mysql监听的端口:
netstat -tap | grep mysql
5、启动mysql服务
service mysql start
停止mysql服务:
service mysql stop
重启:
service mysql restart
6、远程服务访问
vim /etc/mysql/my.cnf
注释掉bind address地址 并重启数据库:service mysql restart
授权非本机用户登陆数据库:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '941219' WITH GRANT OPTION;--对用户名为root并且密码为941219的用户授予对mysql中所有对象的所有权限。
最后刷新权限:
FLUSH PRIVILEGES;
7、卸载mysql数据库
sudo apt-get autoremove --purge mysql-server-5.0
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get remove mysql-common
8、清理残留数据
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
9、mysql数据库更新用户密码
alter user 'root'@'localhost' identified by 'Root@941219';
flush privileges;
10、mysql新建用户并授权
CREATE USER dev@'%' IDENTIFIED BY '123456';
CREATE USER dev@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON mycat_eye.* TO dev@'%';
GRANT ALL PRIVILEGES ON mycat_eye.* TO dev@'localhost';
flush privileges;
11、Mysql慢查询开启
-- 显示慢查询时间
SHOW VARIABLES like 'long_query_time'
-- 显示慢查询文件位置
SHOW VARIABLES like 'slow_query_log_file'
-- 显示慢查询的日志保存形式 可以为TABLE可以为FILE
show variables like '%log_output%';
set global log_output='TABLE'