删库跑路与腾讯云服务器CenterOS安装mysql8

腾讯云服务器CenterOS安装mysql8

1.删库跑路

1.1查询数据库进程状态

systemctl status mysqld

1.2.关闭进程

systemctl stop mysqld

1.3.开始卸载

find / -name mysql

1.4.删除所有文件夹

rm -rf 对应的文件名录

1.5.删除my.cnf

rm -rf /etc/my.cnf

1.6.查看是否还存在mysql的残余部队

systemctl start mysql

1.7.删除成功。

跑吧！！-_-

2.重新安装

2.1进入usr/local

cd /usr/local

2.2创建mysql文件夹

mkdir mysql

2.3进入mysql文件目录

cd mysql

2.4下载压缩包

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

2.5解压xz压缩包

tar xvJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz 

2.6改名

mv mysql-8.0.20-linux-glibc2.12-x86_64 mysql-8.0

2.7创建data文件夹

mkdir data

2.8创建用户组以及用户和密码

groupadd mysql

useradd -g mysql mysql

2.9 授权用户 权限

chown -R mysql.mysql /usr/local/mysql/mysql-8.0

2.10.切换到mysql8.0/bin目录下

2.11初始化基础信息

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

记住临时密码5gmNek7)>!uf

2.12编辑my.cnf文件

vim /etc/my.cnf

my.cnf文件内容如下

[mysql]
default-character-set=utf8mb4
[client]
#port=3306
socket=/var/lib/mysql/mysql.sock
[mysqld]
#port=3306
#server-id=3306
user=mysql
general_log = 1
general_log_file= /var/log/mysql/mysql.log
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql/mysql-8.0
datadir=/usr/local/mysql/data
log-bin=/usr/local/mysql/data/mysql-bin
innodb_data_home_dir=/usr/local/mysql/data
innodb_log_group_home_dir=/usr/local/mysql/data/
character-set-server=utf8mb4
lower_case_table_names=1
autocommit=1
default_authentication_plugin=mysql_native_password
symbolic-links=0
# Disabling symbolic-links is recommended to prevent assorted security risks
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/usr/local/mysql/data/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid

#
# include all files from the config directory

2.13添加mysqld服务到系统(回到上级目录cd…)

 cp -a ./support-files/mysql.server /etc/init.d/mysql

2.14赋予权限

chown 777 /etc/my.cnf
chmod +x /etc/init.d/mysql
chmod +x /etc/init.d/mysqld

2.15检查一下/var/lib/mysql是否存在，否则进行创建

mkdir /var/lib/mysql 

2.16赋予权限

chown -R mysql:mysql /var/lib/mysql/  

2.17启动数据库

service mysql start  

2.18使用随机生成的密码进入数据库修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; 

2.19完美运行

2.20遇到的异常

 ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM-24-13-centos.pid).

开始的时候把data文件的目录建立在mysql/mysql-8.0/目录下了，即下图！

应该是在mysql/data

具体原因是我们在配置的my.cnf文件中，路径已经写好了！！！

2.21后记

在创建my.cnf文件的时候，一定要注意下面这几个路径和自己配置的是否一致！！

basedir=/usr/local/mysql/mysql-8.0
datadir=/usr/local/mysql/data
log-bin=/usr/local/mysql/data/mysql-bin
innodb_data_home_dir=/usr/local/mysql/data
innodb_log_group_home_dir=/usr/local/mysql/data/

记得配置环境变量

vim ~/.bash_profile

最后一行加入

export PATH=$PATH:/usr/local/mysql/mysql-8.0/bin

参考文献
1.MySQL8.0安装教程，在Linux环境安装MySQL8.0教程，最新教程 超详细
2.linux 安装mysql8.0 超详细教程