centos7安装mysql用bunder

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

mysql_install_db --datadir=/home/mysql/data --user=mysql

密码是/root/.mysql_secret

mysql登陆后:

SET PASSWORD = PASSWORD('123456');

---

5.6:

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

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

5.7:

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

---

flush privileges;

添加用户:

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