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连接成功
