Shulou(Shulou.com)05/31 Report--

This article focuses on "error reporting and its solutions often encountered in MySql". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the error reports and their solutions that are often encountered in MySql.

When initializing MySql, the error FATAL ERROR: please install the following Perl modules before executing / usr/bin/mysql_install_db:

Data::Dumper

Reason: autoconf is not installed.

Solution: use yum to install autoconf, and you can install dependent packages directly.

Yum install autoconf.noarch

Start the database error Starting MySQL. ERROR! The server quit without updating PID file

There are many reasons for this error, and the situations I have encountered are:

1.mysql folder permissions problem, that is, the mysql user does not have permission to write pid files.

Workaround: modify folder permissions.

Chown mysql.mysql / var/lib/mysql-R

2. An error occurred in the modification of my.cnf configuration file.

Solution: check the part you just modified to make sure it is written correctly.

Connect to mysql using navicat and report ERROR 1130: Host X.X.X.X is not allowed to connect to this MySQL server

Reason: the remote ip does not have permission to log on to the user.

Solution: assign permissions to the user.

Grant all privileges on *. * to 'your users' @ 'your ip' identified by' * 'with grant option

When logging in to the mysql client from the linux command line, report ERROR 2002 Can't connect to local MySQL server through socket

There are two reasons for this error:

The 1.mysql service is not started. Check the mysql process through lsof or ps to make sure that mysql starts normally.

Note: if you do not start normally, you need to solve the problem of mysql service first.

The 2.socket file path is not fully configured in the configuration file.

This is generally caused by modifying the my.cnf file, such as modifying the socket parameter path under [mysqld], but not specifying the socket parameters of [mysql] and [client]. As a result, the mysql client will use the default socket file path to find it, and an error will be reported if it cannot be found.

Solution: in my.cnf, add the socket parameter to the [mysql] and [client] configuration items and use the same value as [mysqld].

Use select.. Error ERROR 1290 (HY000): The MySQL server is running with the-- secure-file-priv option so it cannot execute this statement when into outfile exports data

Reason: mysql has restrictions on exported directories by default.

Solution: query the directory that mysql allows to export by default, and then set the outfile file directory to that directory.

Show global variables like 'secure_file_priv'; here, I believe you have a deeper understanding of "errors often encountered in MySql and their solutions". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.