MySQL01-安装mysql

yum remove mariadb*  #卸载mariadb
tar -xf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.28-linux-glibc2.12-x86_64 /usr/local/mysql
vim /etc/profile
PATH=/usr/local/mysql/bin:$PATH
groupadd mysql
useradd -r -g mysql -s /sbin/nologin mysql
mkdir /usr/local/mysql/data
chown -R mysql.mysql /usr/local/mysql
mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
cp mysql/support-files/mysql.server /etc/init.d/
/etc/init.d/mysql.server start
mysql -uroot -p #回车，没密码
ALTER USER 'root'@'localhost' identified by 'password';
flush privileges;

create database zabbix character set utf8 collate utf8_bin;
create user zabbix@'127.0.0.1' identified by 'password';
grant all privileges  on zabbix.* to zabbix@'127.0.0.1';
flush privileges;
exit