linux mysql8安装详细步骤

linux mysql 8安装及操作:

1、cd到任一目录,如/usr/local/mysql
cd /usr/local/mysql

2、下载安装包源 未找到wget命令的，请执行 yum install wget
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm


3、安装mysql的依赖包
yum -y install mysql80-community-release-el7-3.noarch.rpm

4、在线安装 默认8
yum -y install mysql-community-server
启动命令：systemctl start mysqld
查看运行状态：systemctl status mysqld.service

5、获取默认密码
grep "password" /var/log/mysqld.log

6、登录
mysql -uroot -p

7、修改密码策略
SHOW VARIABLES LIKE 'validate_password%';
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;

8、修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

9、设置mysql远程访问权限 123456为设置的密码
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'；
flush privileges; 
select * from user;

启动:
service mysqld start

停止:
service mysqld stop

重启:
service mysqld restart


10、如遇到插入信息时有则更新无则添加ID无法自动递增时，请设置my.cnf添加以下信息后重启服务。
my.cnf默认在 /etc/my.cnf 如找不到可执行查找命令 find / -name 'my.cnf'
innodb_autoinc_lock_mode = 0

然后查看是否更改
SHOW VARIABLES LIKE 'innodb_autoinc_lock_mod%';

11、实现有则更新无则添加的sql语句:
ON DUPLICATE key UPDATE