CentOS 7 Installing MySQL 5.6 Encountering problems and solutions

Installing MySQL under CentOS is really not as easy as it is imagined, here I summarize the problems encountered

1. ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)

This problem typically occurs when the Mysql-server is not successfully installed and can be reinstalled via the Yum install mysql-server-5.6.25-1.el7.x86_64.rpm

2. Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

Executive Mysql_install_db–user=mysql

3. RPM After installing MySQL/etc/directory can not find MY.CNF

Whereis mysql view mysql installation directory MySQL:/usr/bin/mysql/usr/lib64/mysql/usr/include/mysql/usr/share/mysql/usr/share/man/ Man1/mysql.1.gzcp/usr/share/mysql/my-default.cnf/etc/my.cnf

4.ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

#/etc/init.d/mysql stop# mysqld_safe–user=mysql–skip-grant-tables–skip-networking mysql-u root mysqlmysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root '; mysql> FLUSH privileges; mysql> quit#/etc/init.d/mysql Restart

5.RPM-IVH Install-time package appears file/usr/share/mysql/charsets/swe7.xml from install of mysql-server-5.6.27-1.el6.x86_64 conflicts With file from the package mariadb-libs-1:5.5.41-2.el7_0.x86_64

Install Yum Remove Mysql-libs  

6.mysql indicates a case-sensitive issue in Linux

Edit/etc/my.cnf in [mysqld] Insert lower_case_table_names=1 After the modification is complete restart the MySQL service via show variables like '% case % ' to see if the modification was successful

7.MySQL cannot connect remotely to the host allowed to connect to host ' 10.72.35.8 ' isn't allowd to connect to this MySQL server

GRANT all privileges on. To ' root ' @ '% ' withGRANT OPTION; FLUSH Privileges

8. The following error occurred

 [[email protected] jirasetup]# rpm-ivh mysql-server-advanced-5.6 . Span style= "COLOR: #800080" >20 -1   100 % Span style= "COLOR: #000000" >]updating / installing ...  1 : Mysql-server-advanced-5.6 . 20 -1 . rh################################# [100 %]fatal error:please  install  the following Perl modules before Executing/usr/bin/mysql_install_db:data::D umper[[email protected] jirasetup]#  

At this point, run Yum install-y perl perl-devel

CentOS 7 Installing MySQL 5.6 Encountering problems and solutions