安装

1、通过 yum 命令安***r> 可以先通过 yum list |grep mysql 方式查看有哪些版本的 mysql

#yum install mysql-server mysql-devel mysql
#service mysql start/service mysql stop
#mysqladmin -u root password 123456
#show variables like '%character%'   //编码

如果mysql-server没有被安装，安装如下教程

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server

远程连接

1.授权法

mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES

2.改表法
在localhost登入mysql后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，将"localhost"改称"%"

#mysql -u root -p
   Enter password:
    ……
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;