青铜剑 2019-09-23 1062浏览量
yum -y remove mariadb-libs.x86_64
mkdir /home/vitess/
cd /home/vitess/
wget http://dev.mysql.com/get/mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
service mysqld start
cat /var/log/mysqld.log|grep -n password
mysql -u root -p输入刚刚的密码登录
set global validate_password_policy =0;
set global validate_password_length=6;
alter user root@localhost identified by '`123qwer';
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '`123qwer';
flush privileges;
vi /etc/my.cnf
最后一行加上下面一句
lower_case_table_names=1
max_connections=512
systemctl restart mysqld
set global validate_password_policy =0;
set global validate_password_length=6;
create user 'vitess'@'%' identified by '`123qwer';
grant all on . to vitess@'%' identified by '`123qwer';
grant all on . to vitess@'%' with grant option;
flush privileges;
systemctl stop firewalld;
systemctl disable firewalld;
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
分享数据库前沿,解构实战干货,推动数据库技术变革