MySQL Data installation Issues summary

1.mysql installation conflict: Conflicts with file from the package

See "Conflicts", is a conflict, the file "/usr/share/mysql/charsets/*" needs mysql-server-5.6.19-1.linux_glibc2.5.x86_64 version, And the system already exists mysql-libs-5.1.71-1.el6.x86_64 version!

Workaround:

Execute the following command to delete the mysql-libs-5.1.71-1.el6.x86_64:

Yum-y Remove mysql-libs-5.1.71*

Then execute the following command to install MySQL:

RPM-IVH mysql-server-5.6.19-1.linux_glibc2.5.x86_64.rpm

Everything OK, the installation was successful.

2. when installing MySQL on CentOS 7, encounter fatal Error:please install the following Perl modules before executing Tall_db:data::D umper

To resolve this error, you need to install the Perl module with the following command: Yum install perl-data-dumper.x86_64

3. MySQL [ERROR] Table ' mysql.user ' doesn ' t exist workaround:

The datadir specified when #由于编译安装时指定的路径为/opt/data and mysql_install_db are also/opt/data, and MY.CNF is the default path. Therefore, after modifying the datadir to the correct path, the problem is resolved

See also: http://blog.csdn.net/leshami/article/details/41801395

4. MySQL root User default password problem above 5.7:

CentOS system use Yum to install MySQL friends, use the grep "temporary password"/var/log/mysqld.log command, return the result the string following the last quotation mark is the default password for root.

(If the/var/log/mysqld.log file does not exist, make sure you have started the MySQL service once.) CentOS 7 command to start the MySQL service is: Systemctl start Mysqld.service)

See also: https://www.yanning.wang/archives/379.html

Some versions have no password after installation. The first time you log in, you need to set a password.

5. Error 2002 (hy000) Mysql.sock/var/lib/mysql/mysql.sock

CentOS 7 already integrates the default mariadb instead of MySQL, which needs to be updated manually for most applications that rely on MySQL.

If you encounter such an error, remove all MARIADB installation packages and install MySQL on your own.

See also: http://blog.csdn.net/furzoom/article/details/49466565

6. CentOS 7 mariadb boot issue:

After installing MARIADB one day, restarting the machine will not start the mariadb.service.

Systemctl start Mariadb.service//Then find the following question

Job for Mariadb.service failed because the control process exited with error code.

See "Systemctl Status Mariadb.service" and "Journalctl-xe" for details

According to the above view nothing but see the "Journalctl-xe" in the start mariadb when there is logging to '/var/log/mariadb/mariadb.log ' and then go to check the log

Find the last below on aborting there is a row Character set ' UTF8 ' is not a compiled Character set and is not specified in the '/usr/share/mysql/ Charsets/index.xml '

After that, check out this index.xml and find UTF8 this configuration.

Then guess the server configuration might not specify a character set

Then find the server configuration

Inside the/ETC/MYCNF.D there is a server.cnf added under [mysqld]

Character-set-server=utf8 Save

Then Systemctl start Mariadb.service

OK, fix it.

See also: http://www.cnblogs.com/CodeWu91/p/6142958.html

7. centos7 MySQL database installation and configuration, see: https://www.cnblogs.com/starof/p/4680083.html

Installation and configuration of MySQL database under CentOS6.4: http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html

8. CentOS 7 Uninstall mariadb the correct command, see: http://www.cnblogs.com/kluan/p/4809895.html

9. Compare several important documents:

/etc/my.cnf

/var/log/mysqld.log

several commonly used commands:

1). Using use in MySQL database to switch databases

2). Use show databases; See what databases are on the server:mysql> show databases;

3). If you want to switch to the test database, then we can use the Using command: Mysql> uses test

MySQL Data installation Issues summary