mysql 8.0.13 tar安装教程_mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz 安装步骤

1、解压mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz到一个文件夹中，随便一个文件夹，后面需要转移的。

# tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz

如果报如下错误，请安装组件

[root@iZ8vbf0nw945emer2xmpdhZ soft]# tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz

tar (child): xz: Cannot exec: No such file or directory

tar (child): Error is not recoverable: exiting now

tar: Child returned status 2

tar: Error is not recoverable: exiting now

[root@iZ8vbf0nw945emer2xmpdhZ soft]# yum install -y xz

2、将解压的文件重命名mysql，并移动到/usr/local目录下

# mv mysql-8.0.13-linux-glibc2.12-x86_64 mysql

# mv mysql /usr/local/

3、进入到/usr/local目录下，创建用户和用户组并授权

# cd /usr/local/

# groupadd mysql

# useradd -r -g mysql mysql

# cd mysql/ #注意：进入mysql文件下授权所有的文件

# chown -R mysql:mysql ./

4、再/usr/local/mysql目录下，创建data文件夹

# mkdir data

5、初始化数据库，并会自动生成随机密码，记下等下登陆要用

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

要是初始化报这个错误：

请安装：yum -y install libaio 和yum -y install numactl就可以了

6、修改/usr/local/mysql当前目录得用户

# chown -R root:root ./

# chown -R mysql:mysql data

7、# cp support-files/my-default.cnf /etc/my.cnf

复制过去，其实也就是空白页，一开始没有my-default.cnf这个文件，可以用# touch my-default.cnf命令创建一个，并配置权限 # chmod 777 ./my-default.cnf

# cd support-files/

# touch my-default.cnf

# chmod 777 ./my-default.cnf

# cd ../

# cp support-files/my-default.cnf /etc/my.cnf

8、配置my.cnf

# vim /etc/my.cnf

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

socket = /tmp/mysql.sock

log-error = /usr/local/mysql/data/error.log

pid-file = /usr/local/mysql/data/mysql.pid

tmpdir = /tmp

port = 3306

#lower_case_table_names = 1

# server_id = .....

# socket = .....

#lower_case_table_names = 1

max_allowed_packet=32M

default-authentication-plugin = mysql_native_password

#lower_case_file_system = on

#lower_case_table_names = 1

log_bin_trust_function_creators = ON

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

如果后期mysql运行报错，可以直接到log-error = /usr/local/mysql/data/error.log目录下直接查看错误日志

命令:cat /usr/local/mysql/data/error.log

9、开机自启，进入/usr/local/mysql/support-files进行设置

# cd support-files/

# cp mysql.server /etc/init.d/mysql

# chmod +x /etc/init.d/mysql

10、注册服务

# chkconfig --add mysql

如果命令没有，在需要处理chkconfig

# rpm -aq |grep chkconfig

# export PATH=/sbin:$PATH

# chkconfig

# echo $PATH

# PATH="$PATH":/sbin

# echo $PATH

11、查看是否成功

12、etc/ld.so.conf要配置路径，不然报错

# vim /etc/ld.so.conf

添加如下内容:

/usr/local/mysql/lib

13、配置环境变量

# vim /etc/profile

# source /etc/profile

添加如下内容：

#MYSQL ENVIRONMENT

export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

14、登陆，这里输入上面第6步随机生成得密码，细心点输入，没有显示的，登陆成功如图所示

你可能因为丢失套接字文件而不能连接(如上截图错误)，你可以简单地通过重启服务器重新创建得到它。因为服务器在启动时重新创建它。

15、开启Navicat远程连接

mysql> use mysql; #如果报以下该错误

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> ALTER USER USER() IDENTIFIED BY 'root'; #解决方式

然后继续下面操作，没有错误也是继续下面操作

# mysql -uroot -p #进入数据库

> use mysql;#进入数据库

> select host, user, authentication_string, plugin from user;#查看用户信息

> GRANT ALL ON *.* TO 'root'@'%';#授权root用户可以远程登陆

> flush privileges;#立即生效

> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Kuaigui2019!';#修改root用户密码

> FLUSH PRIVILEGES;#立即生效

> exit;#退出

# service mysql restart#重启mysql服务

16、navicat连接成功