1、下载安装文件
$ wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
2、解压安装文件
$ tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
3、移动文件到/usr/local/目录下
$ mv mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql
4、创建数据存储文件夹
$ mkdir /usr/local/mysql/data
5、创建用户及用户组
#用户组
$ groupadd mysql
#用户 (用户名/密码)
$ useradd -g mysql mysql
#授权
$ chown -R mysql.mysql /usr/local/mysql/
6、初始化数据库
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize
7、建立MySQL服务
$ cp -a ./support-files/mysql.server /etc/init.d/mysql # 若mysqld,以下mysql相应的修改mysqld
$ chmod +x /etc/init.d/mysql
$ chkconfig --add mysql
$ chkconfig --list mysql #检查服务是否生效
8、 修改my.cnf文件
vim /etc/my.cnf
配置信息如下:
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
character-set-server=utf8
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /usr/local/mysql/mysql.sock
default-character-set=utf8
9、启动mysql服务
#启动
$ service mysql start;
#查看启动状态
$ service mysql status;
10、建立一个链接文件
$ ln -s /usr/local/mysql/bin/mysql /usr/bin
11、client链接mysql
$ mysql -u root
如果提示错误ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO),root账户没有设置密码,可以在安装账户下设置密码
#关闭服务
$ service mysql stop
#安全模式登录(需要cd 到 /usr/local/mysql/bin )
./mysqld_safe --skip-grant-tables
#需要打开新的终端,登录mysql
$ ./mysql -u root
#设置密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY'自己要设置的密码';
如果提示错误ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
可以先执行
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY'Test@123_sh';
Query OK, 0 rows affected (0.08 sec)
密码添加成功,可以登录使用mysql了