安装Mysql碰到的一些问题整理

问题1  &＃xff0c;安装的时候&＃xff0c;提示错误&＃xff0c;原因&＃xff0c;OS是Min安装&＃xff0c;需要安装numactl包 

-- server log begin --
/mysql/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

问题2  &＃xff0c;原因&＃xff0c;需要创建mysql用户

2019-04-18T02:22:30.796541Z 0 [ERROR] Fatal error: Can&＃39;t change to run as user &＃39;mysql&＃39; ; Please check that the user exists!

问题3 &＃xff0c;这个先不用管 &＃xff0c;在5.6的时候&＃xff0c;不出现这个问题&＃xff0c;在5.7出现这个问题。5.7建议使用初始化&＃xff0c;而不是5.6的db_install脚本

2019-04-18 10:23:59 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2019-04-18 10:24:03 [WARNING] The bootstrap log isn&＃39;t empty:
2019-04-18 10:24:03 [WARNING] 2019-04-18T02:23:59.493413Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2019-04-18T02:23:59.494078Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-04-18T02:23:59.494085Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)

问题4 &＃xff0c;设置mysql服务后&＃xff0c;可以关闭&＃xff0c;发现无法启动&＃xff0c;原因&＃xff0c;在/etc/下有my.cnf&＃xff0c;删除或者重命名即可

[root&＃64;mysql1 init.d]# service mysql start
Starting MySQL.2019-04-18T06:04:51.569263Z mysqld_safe Directory &＃39;/var/lib/mysql&＃39; for UNIX socket file don&＃39;t exists.ERROR! The server quit without updating PID file (/mysql/mysql/data/mysql1.pid).
[root&＃64;mysql1 init.d]# service mysql statusERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

问题5 &＃xff0c;原因&＃xff0c;要设置下密码  

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> alter user user() identified by &＃39;mysql&＃39;;
Query OK, 0 rows affected (0.00 sec)

问题6 &＃xff0c;没有开通GTID&＃xff0c;开通就可以了。

ERROR 1777 (HY000): CHANGE MASTER TO MASTER_AUTO_POSITION &＃61; 1 cannot be executed because &＃64;&＃64;GLOBAL.GTID_MODE &＃61; OFF.

问题7 &＃xff0c;原因同上面&＃xff0c;需要开通GTID。

mysql> change master to master_host&＃61;&＃39;192.168.54.230&＃39;,master_user&＃61;&＃39;rep1&＃39;,master_password&＃61;&＃39;mysql&＃39;,master_log_file&＃61;&＃39;master-bin.000002&＃39;,master_log_pos&＃61;1029;
Query OK, 0 rows affected, 2 warnings (0.03 sec)mysql> show warning;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &＃39;warning&＃39; at line 1
mysql> show warnings;
&＃43;-------&＃43;------&＃43;-----------------------------------------------------------------------------------------------------------------------------------------------------------&＃43;
| Level | Code | Message |
&＃43;-------&＃43;------&＃43;-----------------------------------------------------------------------------------------------------------------------------------------------------------&＃43;
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &＃39;warning&＃39; at line 1 |
&＃43;-------&＃43;------&＃43;-----------------------------------------------------------------------------------------------------------------------------------------------------------&＃43;
1 row in set (0.00 sec)


-- 2019-04-30 add

坑8 &＃xff0c;原因&＃xff0c;不需要逗号&＃xff0c;去掉逗号就可以了。&＃xff08;测试用&＃xff0c;所以这里没有加那个trancasction参数&＃xff0c;会锁表&＃xff09;

[root&＃64;test ~]# mysqldump -uroot -p --socket&＃61;/tmp/mysql3306.sock --databases acdm,tes,test,tes_db,zoo > /mysql/mysql/dump20190430.sql
Enter password:
mysqldump: Got error: 1049: Unknown database &＃39;acdm,tes,test,tes_db,zoo&＃39; when selecting the database

坑9 &＃xff0c;启动mysql服务的时候&＃xff0c;提示没有updating pidfile。 原因&＃xff0c;my.cnf里面设置socket文件为/tmp/mysql3306.sock即可&＃xff0c;原来设置的是/mysql/mysql3306.sock

[root&＃64;redhat762100 init.d]# service mysql3306 start
Starting MySQL... ERROR! The server quit without updating PID file (/mysql/mysql3306/data/redhat762100.pid).


END