MySQL卸载
rpm -qa|grep -i mysql
service mysql status
./mysql status
service mysql stop
./mysql stop
rpm -ev MySQL-devel-5.6.23-1.linux_glibc2.5
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
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
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
yum -y install numactl
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_set_server=utf8
symbolic-links=0
explicit_defaults_for_timestamp=true
/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;
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig --list