删除mysql相干的依赖
查问已装置的rpm包
rpm -qa | grep mysql
若查问有后果,需删除
rpm -e --nodeps mysql-libs-xxx
删除相干mysql目录并删除
查问mysql目录
find / -name mysql
查问mysql命令
whereis mysql
下载mysql二进制包
进入/user/local/src/
cd /user/local/src/
下载mysql
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
解压
tar -zxvf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
构建mysql目录
创立mysql BaseDir
mkdir -p /usr/local/mysql/data
挪动mysql文件至BaseDir
mv mysql-5.7.37-linux-glibc2.12-x86_64/* /usr/local/mysql/
初始化mysql用户
创立mysql用户、创立用户组并将mysql退出mysql用户组
groupadd mysqluseradd -r -g mysql mysql
扭转mysql目录所属组和所属用户
chown -R mysql:mysql /usr/local/mysql
赋予mysql用户及用户组对mysql目录对最大拜访权限
chmod +775 /usr/local/mysql
装置mysql
初始化mysql,须要保留以下命令输入后的最初一段的长期明码,至关重要!
sh /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
启动mysql
/usr/local/mysql/support-files/mysql.server start
增加软连贯,并重启mysql服务
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlservice mysql restart
登陆mysql
mysql -u root -p 刚刚的保留的长期明码
输出以下sql语句,批改root用户明码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
近程拜访
use mysql;update user set user.Host='%' where user.User='root';
容许root用户在任何中央进行近程登录,并具备所有库任何操作权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新权限
FLUSH PRIVILEGES;
设置mysql零碎服务
复制mysql服务并赋予执行权限
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqld
增加mysql零碎服务
chkconfig --add mysqld