cd /opt
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server
成功安装之后重启mysql服务
service mysqld restart (实际运行Redirecting to /bin/systemctl restart mysqld.service)
初次安装mysql是root账户是没有密码的
设置密码的方法
mysql -uroot
mysql> set password for 'root'@'localhost' = password('root');
mysql> exit
mysql -uroot -p
创建msql账号用来远程登录:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;
查看用户是否有远程登录权限(内置mysql的user表)
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
设置监控日志:
vim etc/my.cnf
找到[mysqlId],添加如下代码:
log =/tmp/mysqls.log
log-slow-requeries = /tmp/mysqlslowquedery.log(如果需要监控慢查询)
long_query_time = 1
msql5.7以上版本改为:
general_log=ON
general_log_file=/var/log/mysql/mysql.log
slow_query_log = on
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 2
service mysqld restart
监控SQL语句
tail -f /var/log/mysql/mysql.log
将mysql升级为5.7
cd /opt
rpm -qa|grep mysql
rpm -e --nodeps mysql-community-common-5.6.37-2.el7.x86_64 ...
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
rpm -ivh mysql57-community-release-el7-7.noarch.rpm
yum install mysql-server
mysql -V
systemctl start mysqld
修改密码
mysql_secure_installation
允许外部访问
update user set host='%' where user='root';
flush privileges;
exit;