linux rpm包安装并配置mysql

一、下载安装mysql

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server

二、安装后重启服务

service mysqld restart

三、初次安装mysql，root账户没有密码。

[root@yl-web yl]# mysql -u root 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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 databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.01 sec)

四、设置密码

mysql> set password for 'root'@'localhost' =password('password');
Query OK, 0 rows affected (0.00 sec)

五、配置编码（展示的为已配好）

[root@localhost ~]# cat /etc/my.cnf|grep -v "#"
[mysql]
default-character-set =utf8
[mysqld]
character_set_server=utf8
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
bind-address = 0.0.0.0
symbolic-links=0

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

六、远程连接

mysql> use mysql;
把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户
mysql>grant all privileges on *.* to root@'%'identified by 'password';
如果是新用户而不是root，则要先新建用户
mysql>create user 'username'@'%' identified by 'password';
刷新（*）
mysql> flush privileges;

七、关闭防火墙

[root@localhost ~]# systemctl stop firewalld.service
[root@localhost ~]# systemctl disable firewalld.service
rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
rm '/etc/systemd/system/basic.target.wants/firewalld.service'

八、在windows中测试是否可连通（命令符）

telnet yourip 3306
类telnet 127.0.0.1 3306