centos7安装mysql6_2018年第四周-在centos7安装mysql6

“Most good programmers do programming not because they expect to get paid or get adulation by the public, but because it is fun to program.”- Linus Torvalds

yum安装mysql

1.先添加mysql的yum库下载mysql57-community-release-el7-11.noarch.rpm，地址https://dev.mysql.com/downloa...

2.安装mysql的yum库

sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

3.查看mysql的yun库

yum repolist all | grep mysql

4.启动mysql6

shell> sudo yum-config-manager --disable mysql57-community

shell> sudo yum-config-manager --enable mysql56-community

如果提示yum-config-manager命令不存在，则可以直接修改文件/etc/yum.repos.d/mysql-community.repo，把mysql56-community的enabled置为1，mysql57-community的enabled置为0

vim mysql-community.repo

#启动使用MySQL 5.6

[mysql56-community]

name=MySQL 5.6 Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

5.安装mysql

sudo yum install mysql-community-server

6.启动mysql

sudo service mysqld start

7.初始化mysql(可以设置root密码等)

mysql_secure_installation

8.登录mysql

mysql -uroot -p

mysql常用命令(用root用户登录)

查看数据库有哪些用户

SELECT User, Host, Password FROM mysql.user;

创建一个数据库名为"mydb_name"

create database mydb_name default character set utf8;

创建用户"jevoncode"，任意域名都能登录，密码为jevoncodepassword

create user 'jevoncode'@'%' identified by 'jevoncodepassword';

授权mydb_name数据的所有权限给jevoncode用户

grant all privileges on mydb_name.* to 'jevoncode'@'%';

刷新数据库权限

flush privileges;

查看用户的权限

show grants for jevoncode@'%';

常见问题

查看3306端口是否监听，执行命令后没有返回消息，则没有监听此端口

netstat -tunpl |grep 3306

查看防火墙是否允许访问，执行命令后没有返回消息能用则表明不能方位该端口

iptables -L -n|grep 3306

设置防火墙允许访问端口3306

iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

保存防火墙策略

iptables-save > iptables.rules

中文乱码时，用这命令SHOW VARIABLES LIKE 'char%';查看mysql-server的编码

mysql> SHOW VARIABLES LIKE 'char%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

mysql默认server编码为latin1，所以设置为utf8，修改/etc/my.cnf，在[mysqld]下添加：

[mysqld]

character-set-server=utf8