linux安装mysql

参考：https://www.cnblogs.com/nicknailo/articles/8563456.html 卸载
https://www.cnblogs.com/renjidong/p/7047396.html rpm安装
https://www.cnblogs.com/davidgu/p/3706663.html 允许远程连接

卸载干净老的（删除mysql.sock,和/etc/my.cnf）
安装新的
允许远程链接

以下是编译安装的
参考：https://www.cnblogs.com/wangdaijun/p/6132632.html （过程）
https://blog.csdn.net/qq_30770095/article/details/79404726
https://blog.csdn.net/qq_32218457/article/details/79790494

wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz （一般选linux generic）

解压后里面的全部移到/usr/local/mysql

chown -R mysql:mysql ./       // 修改权限
./scripts/mysql_install_db --user=mysql // 安装
./support-files/mysql.server start // 开启mysql服务
./bin/mysqladmin -u root -h localhost.localdomain password '123456' // 以管理身份修改进入密码
./bin/mysql -uroot -p // 密码就是上面的123456
ln  -s /usr/local/mysql/bin/mysql  /usr/bin      // 建立快捷使用

如果报这个错` Can't connect to local MySQL server through socket '/tmp/mysql.sock'`
// 就建立个软连接
ln -s /var/lib/mysql/mysql.sock /tmp
或者！
./support-files/mysql.server start（我的vagrant需要先开下这个，搞了半天）

允许本地电脑登陆mysql，
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@"172.16.16.152" IDENTIFIED BY "123456" WITH GRANT OPTION;
FLUSH PRIVILEGES;

关闭防火墙：service iptables stop 或者 systemctl stop firewalld.service或者setenforce 0

重启mysql服务：/usr/local/mysql/support-files/mysql.server restart

// 安装log-bin
到/etc/my.cnf的mysqld模块添加`log-bin=mysql-bin`重启
再到mysql程序中执行`show variables like '%log_bin%';检查