“Slave2上安装mysql server”的版本间的差异
201708010242(讨论 | 贡献) (→获取mysql密码) |
|||
(未显示同一用户的2个中间版本) | |||
第1行: | 第1行: | ||
− | |||
− | == | + | == 解压mysql == |
− | + | tar -xvf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar | |
− | + | [[文件:Mysql.png]] | |
+ | == 安装mysql == | ||
− | + | ||
+ | rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm | ||
+ | 会报错误 | ||
+ | [[文件:Mysql报错.png]] | ||
+ | |||
+ | 解决方法: | ||
+ | |||
+ | yum remove mysql-libs | ||
+ | |||
+ | 再次执行 | ||
+ | |||
+ | rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm | ||
+ | |||
+ | rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm | ||
+ | |||
+ | rpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm | ||
+ | |||
+ | rpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm | ||
+ | |||
+ | rpm -ivh mysql-community-devel-5.7.18-1.el7.x86_64.rpm | ||
+ | |||
+ | |||
+ | == 启动mysql服务 == | ||
+ | |||
+ | 启动mysql服务 | ||
+ | |||
+ | systemctl start mysqld | ||
+ | |||
+ | 查看mysql状态 | ||
+ | |||
+ | systemctl status mysqld | ||
+ | |||
+ | [[文件:Mysqlstatus.png]] | ||
+ | |||
+ | |||
+ | |||
+ | 让mysql开机自启 | ||
+ | |||
+ | systemctl enable mysqld | ||
+ | |||
+ | |||
+ | [[文件:开机启动mysql.png]] | ||
+ | |||
+ | |||
+ | |||
+ | == 获取mysql密码 == | ||
+ | |||
+ | cat /var/log/mysqld.log | grep password | ||
+ | |||
+ | [[文件:获取mysql密码.png]] | ||
+ | |||
+ | |||
+ | 登录mysql | ||
+ | |||
+ | mysql -uroot -p | ||
+ | |||
+ | 复制刚才获取的密码 | ||
+ | 、 | ||
+ | 登进mysql修改密码强度 | ||
+ | |||
+ | set global validate_password_policy=0; | ||
+ | |||
+ | [[文件:修改mysql密码强度.png]] | ||
+ | |||
+ | 修改mysql最低密码长度 | ||
+ | |||
+ | set global validate_password_length=4; | ||
+ | |||
+ | |||
+ | [[文件:Mysql密码长度.png]] | ||
+ | |||
+ | 修改密码为123456, | ||
+ | |||
+ | |||
+ | |||
+ | alter user 'root'@'localhost' identified by '123456'; | ||
== 设置远程登录 == | == 设置远程登录 == | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | 创建用户: | ||
+ | |||
+ | create user 'root'@'%' identified by '123456'; | ||
+ | |||
+ | |||
+ | |||
+ | 允许远程连接: | ||
+ | |||
+ | |||
+ | grant all privileges on *.* to 'root'@'%' with grant option; | ||
+ | |||
+ | |||
+ | [[文件:修改mysql.png]] | ||
+ | |||
+ | |||
+ | 刷新权限: | ||
+ | |||
+ | |||
+ | flush privileges; | ||
+ | |||
+ | [[文件:刷新权限.png]] |
2018年11月26日 (一) 12:02的最新版本
解压mysql
tar -xvf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
安装mysql
rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm
会报错误
解决方法:
yum remove mysql-libs
再次执行
rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.18-1.el7.x86_64.rpm
启动mysql服务
启动mysql服务
systemctl start mysqld
查看mysql状态
systemctl status mysqld
让mysql开机自启
systemctl enable mysqld
获取mysql密码
cat /var/log/mysqld.log | grep password
登录mysql
mysql -uroot -p
复制刚才获取的密码 、 登进mysql修改密码强度
set global validate_password_policy=0;
修改mysql最低密码长度
set global validate_password_length=4;
修改密码为123456,
alter user 'root'@'localhost' identified by '123456';
设置远程登录
创建用户:
create user 'root'@'%' identified by '123456';
允许远程连接:
grant all privileges on *.* to 'root'@'%' with grant option;
刷新权限:
flush privileges;