Shulou(Shulou.com)06/01 Report--

Operating system: CentOS release 6.7 (Final) 64 bit

Kernel: 2.6.32-573

Database: mysql5.6.30 (RPM installation)

Problems that have occurred:

1. The problem of mysql-libs conflict occurred when the rpm package installed mysql5.6.30, and it was uninstalled, but the following error occurred when installing php-mysql (several lines)

From install of mysql-libs-5.1.69-1.el6_4.x86_64 conflicts with file from package MySQL-server-5.6.13-1.linux_glibc2.5.x86_64

Failure to install php-mysql will cause Mysql not to be displayed in the database connection when we install Zabix (one of the reasons)

To find relevant information, you can download a compatibility package of Mysql5.6.

Reference: http://www.linuxidc.com/Linux/2013-11/92831.htm

Install after wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.14-1.el6.x86_64.rpm download: rpm-ivh MySQL-shared-compat-5.6.14-1.el6.x86_64.rpm and then install php-mysqlyum install php-mysql successfully

2. Install zabbix 2.4.8 database initialization problem

After creating the zabbix database and authorizing zabbix users, the following error was reported when initializing the database: BLOB/TEXT column 'xxxxxx (table name)' can't have a default value query, which means that table fields of type TEXT cannot have default values. The problem was not found in the version of mysql5.1. Look for relevant information and say it is due to the following reasons:

1. MYSQL5.x does not allow fields of type BLOB/TEXT to have default values.

2. Because MySQL works in 'strict mode' strict mode, if you change to non-strict mode, the above statement can be executed successfully

Solution:

Change the configuration file of the database by adding the following

Sql-mode= "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Restart the database, reload the initialization database, and this kind of error no longer occurs.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.