第三百九十九节，Django+Xadmin打造上线标准的在线教育平台—生产环境部署CentOS6.5安装mysql5.6
1.检测系统是否已经安装过mysql或其依赖，若已装过要先将其删除，否则第4步使用yum安装时会报错：
[root@192 ~]# yum list installed | grep mysql mysql-libs.x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 [root@192 ~]#
2.删除已安装的MySQL
[root@192 ~]# yum -y remove mysql-libs.x86_64
3.从mysql的官网下载.rpm安装库，有了安装库才能在线安装
到官网下载系统对应的版本
https://dev.mysql.com/downloads/repo/yum/
wget dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm 下载安装库
如果报以下错误
wget --no-check-certificate dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm
4.安装刚才下载的mysql安装库
yum install mysql57-community-release-el6-11.noarch.rpm
5.安装成功后，我们可以看到/etc/yum.repos.d/目录下增加了以下两个文件
[root@192 ~]# ls /etc/yum.repos.d CentOS-Base.repo CentOS-Debuginfo.repo CentOS-Media.repo CentOS-Vault.repo mysql-community.repo mysql-community-source.repo [root@192 ~]#
6.查看mysql5.6的安装源是否可用
[root@192 ~]# yum repolist enabled | grep mysql mysql-connectors-community MySQL Connectors Community 42 mysql-tools-community MySQL Tools Community 51 mysql57-community MySQL 5.7 Community Server 201 [root@192 ~]#
7.可以看到现在mysql安装源是5.7版本，我需要修改成5.6版本
使mysql5.6下面的enable=1
若有mysql其它版本的安装源可用，也请自行修改配置文件使其enable=0
vim /etc/yum.repos.d/mysql-community.repo 修改文件
8.使用yum命令安装mysql
[root@bogon ~]# yum -y install mysql-server
9.设置开机启动
[root@bogon ~]# chkconfig mysqld on
10.启动MySQL服务
启动文件在/usr/sbin/mysqld
[root@bogon ~]# service mysqld start
11.设置MySQL的root用户设置密码
[root@bogon ~]# mysql -u root //登录数据库 mysql> select user,host,password from mysql.user; //查看数据库用户名和密码 +------+-----------+----------+ | user | host | password | +------+-----------+----------+ | root | localhost | | | root | bogon | | | root | 127.0.0.1 | | | | localhost | | | | bogon | | +------+-----------+----------+
可以看到用户名root的密码为空，用下面的命令设置root的密码为root
mysql> set password for root@localhost=password('root'); mysql> exit
12.用新密码登陆
[root@bogon ~]# mysql -u root -p Enter password:
13.查看mysql默认存储引擎,保证储引擎是InnoDB，因为InnoDB引擎才支持事务
[root@bogon etc]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql> show variables like 'storage_engine'; +----------------+--------+ | Variable_name | Value | +----------------+--------+ | storage_engine | InnoDB | +----------------+--------+ 1 row in set (0.00 sec)
14.CentOS6.5开放mysql端口3306，CentOS6.5默认是不开放端口的，如果要让外部的系统访问CentOS6.5上的mysql，必须开放mysql的端口3306，修改/etc/sysconfig/iptables
vim /etc/sysconfig/iptables
在文件里加上
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
# Firewall configuration written by system-config-firewall # Manual customization of this file is not recommended. *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT -A INPUT -p icmp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT #添加配置项 -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT -A INPUT -j REJECT --reject-with icmp-host-prohibited -A FORWARD -j REJECT --reject-with icmp-host-prohibited COMMIT
15.重启防火墙
[root@bogon etc]# service iptables restart
16.创建新用户test_user，远程登录mysql
create user '用户名'@'IP地址' identified by '密码'; 创建一个用户
%表示任意ip
create user 'test_user'@'%' identified by 'test_user';
17.给新用户test_user授权，让他可以从外部登陆和本地登陆
1
grant all privileges(除授权外的所有权限) on *.*(表示所有数据库的所有表) to 'test_user(授权的用户名)'@'localhost(授权ip)' identified by 'test_user(用户密码)';
grant all privileges on *.* to 'test_user'@'localhost' identified by 'test_user';
2
grant all privileges(除授权外的所有权限) on *.*(表示所有数据库的所有表) to 'test_user(授权的用户名)'@'%(所有ip)' identified by 'test_user(用户密码)';
grant all privileges on *.* to 'test_user'@'%' identified by 'test_user';
18.查看用户授权后的情况
mysql> select user,host,password from mysql.user; +-----------+-----------------+-------------------------------------------+ | user | host | password | +-----------+-----------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 192.168.158.128 | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | 192.168.158.128 | | | test_user | % | *8A447777509932F0ED07ADB033562027D95A0F17 | | test_user | localhost | *8A447777509932F0ED07ADB033562027D95A0F17 | +-----------+-----------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql>
19.使用授权用户远程登陆
可以远程登陆了
