root权限
1、下载解压安装包
centOS7下载redhat的rpm版本d
tar解压
2、添加用户
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql
3、安装解压后所有文件
rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-devel-8.0.19-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm --nodeps --forc
rpm -ivh mysql-community-server-debug-debuginfo-8.0.19-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-test-8.0.19-1.el7.x86_64.rpm --nodeps --force
4、查询安装情况
rpm -qa|grep mysql
5、初始化mysql
mysqld --initiallize
ls -hlt /var/lib/mysql
chown mysql:mysql /var/lib/mysql -R
ls -hlt /var/lib/mysql
6、开机自启
systemctl status mysqld.service
systemctl start mysqld
systemctl enable mysqld
7、首次登陆
cat /var/log/mysqld.log |grep password
最后一行冒号后就是初始化root密码
mysql -u root -p
输入上面的密码
修改root密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ROOT的新密码'
8、远程访问授权
mysql> create user 'root'@'%' identified with mysql_native_password by '你上面设置的ROOT密码';
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
mysql> flush privileges;
mysq>exit
9、firewall添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --add-port=8080/tcp --permanent
firewall-cmd --reload
10、设置mysql服务端和客户端字符集为utf8
vi /etc/my.cnf
在文件顶部添加
[client]
default-character-set=utf8
在原有[mysqld]下添加,为直观,添加到socket=/var/lib/mysql/mysql.sock下
character-set-server=utf8
collation-server=utf8_general_ci
编辑完成,服务mysqld重启
service mysqlq restart