下载mysql5.7.35
链接:https://pan.baidu.com/s/1hTmnGNLmILOqqD2eMFPyOw
提取码:k22r
创建用户组
groupadd mysql
新增用户
useradd mysql -g mysql
解压
tar zxvf /usr/local/mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
cd /usr/local/mysql
mkdir data
chown -R mysql:mysql mysql/
chmod -R 755 mysql/
cd mysql
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
查找密码,一般在命令的末尾,
2021-09-27T02:11:46.227102Z 1 [Note] A temporary password is generated for root@localhost: r?(Fp+mh,3rQ
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
service mysqld restart
mysql -uroot -po*s#gqh)F4Ck
alter user ‘root’@‘localhost’ identified by ‘newpswd’
设置所有ip都可以访问
update user set user.Host=’%’ where user.User=‘root’;
flush privileges;