MYSQL教程详解腾讯云CentOS7.0使用yum安装mysql及使用遇到的问题

MYSQL应用
[root@VM_47_56_centos ~]# yum list | grep mysql
akonadi-mysql.x86_64          1.9.2-4.el7          base   
apr-util-mysql.x86_64          1.5.2-6.el7          base    
mysql-proxy.x86_64           0.8.5-2.el7          epel   
mysql-proxy-devel.x86_64        0.8.5-2.el7          epel   
mysql-router.x86_64           2.0.2-1.el7          mysql-tools-community
mysql-router-debuginfo.x86_64      2.0.2-1.el7          mysql-tools-community
mysql-utilities.noarch         1.5.6-1.el7          mysql-tools-community
mysql-utilities-extra.noarch      1.5.6-1.el7          mysql-tools
mysqlreport.noarch           3.5-11.el7           epel   
mysqltuner.noarch            1.2.0-7.el7          epel   
省略部分内容....
[root@VM_47_56_centos ~]# 

MYSQL应用
$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

MYSQL应用
$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

MYSQL应用
$ sudo yum install mysql-server

MYSQL应用
[root@VM_47_56_centos ~]# sudo yum install mysql-server
已加载插件：fastestmirror, langpacks          
| 2.5 kB 00:00:00   
mysql-tools-community                                 | 2.5 kB 00:00:00   
mysql56-community                                     | 2.5 kB 00:00:00   
(1/3): mysql-connectors-community/x86_64/primary_db                    | 8.6 kB 00:00:00   
(2/3): mysql-tools-community/x86_64/primary_db                      | 22 kB 00:00:00   
(3/3): mysql56-community/x86_64/primary_db                        | 109 kB 00:00:01   
Loading mirror speeds from cached hostfile
 * base: mirrors.sina.cn
 * extras: mirrors.sina.cn
 * updates: mirrors.sina.cn
正在解决依赖关系
--> 正在检查事务
省略内容...
依赖关系解决
=================================================================================================================
 Package              架构       版本            源              大小
=================================================================================================================
正在安装:
 mysql-community-libs       x86_64      5.6.27-2.el7        mysql56-community      2.0 M
   替换 mariadb-libs.x86_64 1:5.5.44-1.el7_1
 mysql-community-server      x86_64      5.6.27-2.el7        mysql56-community      58 M
为依赖而安装:
 mysql-community-client      x86_64      5.6.27-2.el7        mysql56-community      19 M
 mysql-community-common      x86_64      5.6.27-2.el7        mysql56-community      256 k
 numactl-libs           x86_64      2.0.9-5.el7_1       
事务概要
=================================================================================================================
安装 2 软件包 (+9 依赖软件包)
总下载量：80 M
Is this ok [y/d/N]: y

MYSQL应用
$ mysql -u root

MYSQL应用
$ sudo chown -R mysql:mysql /var/lib/mysql #这里的mysql是用户名(需要设置用户组合用户)

MYSQL应用
$ service mysqld restart

MYSQL应用
$ mysql -u root
mysql > use mysql;
mysql > update user set password=password('xu827928') where user='root';
mysql > exit;

MYSQL应用
$ sudo vim /etc/sysconfig/iptables

MYSQL应用
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

MYSQL应用
$ sudo service iptables restart

MYSQL应用
mysql>mysql -h localhost -u root //这样应该可以进入MySQL服务器 
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //赋予任何主机访问数据的权限 
mysql>FLUSH PRIVILEGES //修改生效 
mysql>EXIT //退出MySQL服务器

MYSQL应用
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) 
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) 
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) 

MYSQL应用
mysql> select user,password,host from mysql.user;

MYSQL应用
+--------+-------------------------------------------+--------------------+
| user  | password                 | host        |
+--------+-------------------------------------------+--------------------+
| root  |                      | %         |

MYSQL应用
mysql> grant all privileges on *.* to root@"%" identified by "your password";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)