mysql 5.6.35--libc.so.6(GLIBC_2.14)(64bit),libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

欢迎访问我的个人博客网站：http://www.yanmin99.com/

centos 6.5 安装mysql 5.6.35–libc.so.6(GLIBC_2.14)(64bit),libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

• 1、原因应该是centos6应该是el/6，centos应该是el/7的源

  Error: Package: mysql-community-server-5.6.30-2.el7.i686 (mysql56-community)Requires: systemdError: Package: mysql-community-server-5.6.30-2.el7.i686 (mysql56-community)Requires: libstdc++.so.6(GLIBCXX_3.4.15)Error: Package: mysql-community-client-5.6.30-2.el7.i686 (mysql56-community)Requires: libc.so.6(GLIBC_2.17)Error: Package: mysql-community-server-5.6.30-2.el7.i686 (mysql56-community)Requires: libc.so.6(GLIBC_2.17)You could try using --skip-broken to work around the problemYou could try running: rpm -Va --nofiles --nodigest  

• 2、解决方案

  • A、删除yum remove "mysql56-community-release-el7.*"

    yum remove "mysql56-community-release-el7.*"

  • B、清楚缓存yum clean all

    yum clean all   

  • 修改mysql56-community中baseurl的值

    //修改之前# enable to use MySQL 5.6[mysql56-community]name=MySQL 5.6 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql//修改之后# enable to use MySQL 5.6[mysql56-community]name=MySQL 5.6 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

  • 解决ERROR 1130: Host ‘xxxx’ is not allowed to connect to this MySQL server方法

• 分析原因
  
  • 应该是该账号不能远程登陆，所以要看一下，mysql库中的User表改用的访问权限设置。

• 方案一：改表法

  • 1、登陆数据库

    mysql -u root -p

  • 查看mysql库中的user表

    mysql> use mysql;mysql> select host,user from user;+-----------------------------+------+| host                        | user |+-----------------------------+------+| localhost                   | root || 127.0.0.1                   | root || ::1                         | root || node404v.add.bjsc.qihoo.net | root |+-----------------------------+------+

    查看发现root用户只有本机可以访问

  • 把User表中的host字段”localhost”改称”%”

    mysql> update user set host = '%' where user = 'root';mysql> select host,user from user;+-----------------------------+------+| host                        | user |+-----------------------------+------+| %                           | root || 127.0.0.1                   | root || ::1                         | root || node404v.add.bjsc.qihoo.net | root |+-----------------------------+------+

• 方案二：授权法

  • 1、如果你想myuser使用mypassword从任何主机连接到mysql服务器的话。

    GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

    这样有点不安全，所以建议指定ip才能访问。

  • 2、如果你想允许用户myuser从ip为192.168.1.18的主机连接到mysql服务器，并使用mypassword作为密码。

    GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.18' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

  • 操作如下：

    GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.18' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;Query OK, 0 rows affected (0.23 sec)mysql> select user,host from user ;+-----------------------------+------+| host                        | user |+-----------------------------+------+| 10.255.9.79                 | root || 127.0.0.1                   | root || localhost                   | root || ::1                         | root || node404v.add.bjsc.qihoo.net | root |