Centos安装Mysql 迁移
下载mysql
创建mysql目录
bash
cd /usr/local/software
mkdir mysql
下载源到服务器
bash
cd /usr/local/software/mysql
wget https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
rpm -Uvh mysql80-community-release-el7-1.noarch.rpm
yum安装mysql
bash
yum install mysql-community-server
启动配置
设置表名字段名不区分大小写
提示
在mysql8.x版本不能在mysql初始化后修改 lower_case_table_names
参数,所以如果有需要修改此参数的话 需要在初始化前修改
bash
vim /etc/my.cnf
##加入下面的配置 不区分表名字段名大小写
lower_case_table_names=1
启动mysql
bash
service mysqld start
登录mysql
bash
mysql -u root -p (你的密码)
设置密码
修改密码
sql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
修改密码策略
sql
##查看密码策略
show variables like '%password%';
##设置密码安全等级为最低,密码长度为6
set global validate_password.policy=LOW;
set global validate_password.length=6;
创建远程用户
mysql远程连接root用户
sql
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxxx';
FLUSH PRIVILEGES;
给远程账户最高权限(慎重)
sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;