centos6.5 mysql5.7安装

下载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;