mysql安装过程-错误解决

mysql开启远程访问

解决方法：https://blog.csdn.net/konglongaa/article/details/80996829

安装过程可能出现错误，问题列表：
1、提示：Can’t locate ExtUtils/MakeMaker.pm in @INC 错误的解决方式
https://blog.csdn.net/w87848608/article/details/13997271

yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker就可以了

2、gcc 安装
https://www.cnblogs.com/xiyushimei/p/8550930.html

1、提示：Can’t locate Data/Dumper.pm
解决方法：https://blog.csdn.net/zhengwei125/article/details/79093068

2、提示：Installing MySQL system tables…/usr/local/mysql/bin/mysqld: error while loading shared libraries:
解决方法：https://blog.csdn.net/songmao3145/article/details/77676402

3、提示：Starting MySQL.The server quit without updating PID file (/[FAILED]ql/mysql.pid).
解决方法：安装的过程会有警告：WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by
只要把 /etc/my.cnf里面的pid-file注释掉，或者创建对应的目录

参照文章：https://blog.51cto.com/fengyunshan911/2070818

4、提示：Starting MySQL.The server quit without updating PID file
解决方法：目录所属权限和执行权限导致
chown -R mysql:myGroup /usr/local/mysql
chmod -R 755 /usr/local/mysql

5、提示：ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
解决方法：进入系统手工执行：

mysql -uroot -h 127.0.0.1 -p
或者
mysql -u root -p

change master to master_host=‘192.168.0.104’,
master_port=3306,
master_user=‘mysql’,
master_password=‘123456’,
master_log_file=‘mysql-bin.001780’,
master_log_pos=16612;

启动Slave开启同步

start slave;