centos7下bunder.tar格式安装mysql

yum install -y perl-Module-Install.noarch

vi /etc/my.cnf

mkdir /home/mysql

mkdir /home/mysql/data

mkdir /home/mysql/log

tar xvf MySQL-5.6.34-1.el7.x86_64.rpm-bundle.tar

yum install -y My*.rpm

chown mysql:mysql -R mysql

关闭selinux

5.6,5.7:mysql_install_db --datadir=/home/mysql/data --user=mysql

8:mysqld --initialize --user=mysql  --datadir=/home/mysql/data

密码是/root/.mysql_secret

mysql登陆后:

---

5.6:

SET PASSWORD = PASSWORD('123456');

delete from mysql.user where host!='127.0.0.1';

UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';

5.7:

SET PASSWORD = PASSWORD('123456');

delete from mysql.user where host!='127.0.0.1';

update mysql.user set Host='127.0.0.1';

update mysql.user set authentication_string=password('123456') where user='root';

8.0:

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

---

flush privileges;

添加用户:

grant all on zabbix.* to zabbix@localhost identified by 'zabbix';