CentOS 7 安装MySQL 5.6遇到问题及解决方案

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 mysql
mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’; 
mysql> FLUSH PRIVILEGES; 
mysql> quit
# /etc/init.d/mysql restart

5.rpm -ivh安装时包 出现 file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.6.27-1.el6.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64

[root@localhost install-files]# yum remove mysql-libs  

6.mysql在linux表明大小写敏感问题

编辑/etc/my.cnf在[mysqld]下插入lower_case_table_names=1
修改完成后重启mysql服务
通过show variables like ‘%case%‘，查看是否修改成功

7.MySQL不能远程连接Host is not allowed to connect to Host ‘10.72.35.8’ is not allowd to connect to this MySQL server

GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘WITH GRANT OPTION; 
FLUSH PRIVILEGES

8.出现以下错误

[root@azrlnx06 jirasetup]# rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm 
Preparing... ################################# [100%]
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::Dumper
[root@azrlnx06 jirasetup]# 

此时运行 yum install -y perl perl-devel

CentOS 7 安装MySQL 5.6遇到问题及解决方案

标签：har   net   exist   str   this   修改   fat   pre   oca