手机可以安装mysql_linux 安装mysql

操作系统:centos7

mysql版本: mysql-8.0.16-el7-x86_64.tar.gz

配置文件: my.cnf

Mysql 8.0.5 提示 consider upgrading MySQL client 解决方法

USE mysql;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

FLUSH PRIVILEGES;

1.安装前准备:

rpm -qa|grep mariadb 查看是否安装mariadb

如果存在，

用rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 卸载

2.创建mysql组与用户

groupadd mysql

useradd -g mysql mysql

3.初始化mysql

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

4.初始化权限问题：

chown -R mysql:mysql /tmp/mysql

5.修改密码:

5.1service mysqld start --skip-grant-tables

5.2 mysql命令进入mysql窗口

5.3 ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';

5.4 重启服务 systemctl restart mysql.service

5.5 允许远程访问

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;

FLUSH PRIVILEGES;