linux下的mysql安装
首先下载linux下的mysql-5.7.11.tar.gz
mysql安装
1.移除有关mysql相关内容
#rpm -qa |grep mysql 查找有关mysql的安装内容
#rpm -e --nodeps akonadi-mysql-1.9.2-4.el7.x86_64
#rpm -e --nodeps qt5-qtbase-mysql-5.6.1-10.el7.x86_64
#rpm -e --nodeps qt-mysql-4.8.5-13.el7.x86_64
2.移除有关mariadb相关内容
#rpm -qa |grep mariadb* 查看所有有关mariadb的内容
#rpm -e mariadb 错误:依赖检测失败
#rpm -e mariadb-devel
#rpm -e mariadb-server
#rpm -e mariadb
#rpm -e mariadb --nodeps 错误:未安装软件包mariadb
#rpm -e mariadb-libs --nodeps
3.安装:
解压mysql-5.7.11.tar.gz
#tar -xzvf mysql-5.7.11.tar.gz
#cd mysql
#rpm -ivh mysql-community-common、lib、client、server-*.rpm
打开配置文件
vim /etc/my.cnf
添加以下配置
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
4.启动:
systemctl start mysqld.service
获取初始密码:
vim /var/log/mysqld.log
登录:
mysql -u root -p
5.修改密码:
mysql> set PASSWORD=PASSWORD(‘root’);
如果修改密码时出现以下错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
错误原因:密码过于简单
这个其实与validate_password_policy(密码策略)和validate_password_length(密码长度)的参数值有关。
解决:
首先,修改validate_password_policy参数的值
mysql> set global validate_password_policy=0;这个参数设置为0以后密码即只受长度限制
再设置validate_password_length参数值
mysql> set global validate_password_length=1; 此时密码长度为4
重新设置密码:
mysql> set PASSWORD=PASSWORD(‘root’);
6.设置远程连接:
mysql> use mysql
进行远程授权
mysql> grant all on . to root@’%'identified by ‘root’ with grant option;
刷新权限
mysql> flush privileges;
mysql启动失败:
systemctl status mysqld 失败
查看日志:tail -200f /var/log/mysqld.log 发现是缺少目录
新建目录: mkdir -p /var/run/mysqld/
更改授权: chown mysql.mysql /var/run/mysqld/
重新启动: service mysqld start
查看状态: systemctl status mysqld