Linux mysql安装卸载

MySQL卸载

# 检查是否安装mysql
rpm -qa|grep -i mysql
# 查看mysql状态
service mysql status
./mysql status
# 停止mysql
service mysql stop
./mysql stop
# 卸载mysql组件
rpm -ev MySQL-devel-5.6.23-1.linux_glibc2.5
# 查找muysql安装目录
whereis mysqlm
find / -name mysql
# 删除文件
rm -rf /usr/share/mysql /usr/lib64/mysql /usr/include/mysql
# 删除配置文件
rm -rf /etc/my.cnf /etc/init.d/mysql.server
# 删除mysql用户组
id mysql
userdel mysql

MySQL安装

下载地址

# 下载
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar
# 解压
tar -xzvf mysql-5.7.26-linux-glibc2.12-x86_64.tar
mkdir /usr/local/mysql
mkdir /usr/local/mysql/data
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql/mysql-5.7.26
# 权限错误，添加mysql用户，赋权
groupadd mysql
useradd -r -g mysql mysql
# mysql 权限
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
# 编译安装mysql
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
# 报错 ./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No suc 
yum -y install numactl
# 配置my.cnf
vim /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/data/mysql.err
pid-file=/usr/local/mysql/data/mysql.pid
#character config
character_set_server=utf8
symbolic-links=0
explicit_defaults_for_timestamp=true

# 启动mysql
/usr/local/mysql/support-files/mysql.server start
# 添加软连接
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
# 重置密码
alter user root@localhost identified by 'root';
# 远程连接
update user set Host='%' where User='root';
# 忘记密码
vim /etc/my.cnf
# 加上
skip-grant-tables
# 重启
service mysql restart
use mysql;
UPDATE user SET authentication_string = password('root') WHERE User = 'root';
# 刷新权限
flush privileges;

# 开机自启
# 服务文件拷贝到init.d下，重命名为mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# 赋予可执行权限
chmod +x /etc/init.d/mysqld
# 添加服务
chkconfig --add mysqld
# 服务列表
chkconfig --list