mysql 安装

【mysql-5.6版本安装】


1、下载mysql的repo源
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2、安装mysql-community-release-el7-5.noarch.rpm包
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3、安装并启动mysql
yum install mysql-server

service mysql start

4、设置密码

mysql -uroot 
use mysql;
update user set password=password('1327') where user='root';
flush privileges;
5、给root账户远程登陆权限
grant all privileges on *.* to 'root'@'%' identified by '1327';
flush privileges;
\q
6、重启mysql，并设置开机自启
service mysql restart;
systemctl enable mysqld;


【mysql-5.7版本安装】-------官网上有详细的安装步骤;


1、配置yum源
# 下载mysql源安装包
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
# 安装mysql源
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
# 检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
2、安装MySQL
yum install mysql-community-server
3、启动MySQL服务
systemctl start mysqld
查看MySQL的启动状态
systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: active (running) since 五 2016-06-24 04:37:37 CST; 35min ago
 Main PID: 2888 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─2888 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
10月 02 18:55:34 h22 systemd[1]: Starting MySQL Server...
10月 02 18:56:27 h22 systemd[1]: Started MySQL Server.

4、开机启动
systemctl enable mysqld
systemctl daemon-reload
5、修改root本地登录密码
mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：
grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; 
或者
set password for 'root'@'localhost'=password('MyNewPass4!'); 
注意：mysql5.7默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误。
禁用插件
vim /etc/my.cnf
validate_password = off
重新启动mysql服务使配置生效：
systemctl restart mysqld
6、添加远程登录用户
默认只允许root帐户在本地登录，如果要在其它机器上连接mysql，必须修改root允许远程连接，或者添加一个允许远程连接的帐户，为了安全起见，我添加一个新的帐户：
GRANT ALL PRIVILEGES ON *.* TO 'yangxin'@'%' IDENTIFIED BY 'Yangxin0917!' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
flush privileges;
远程登录
mysql -P 3306 -h 192.168.3.134 -u root -p
7、配置默认编码为utf8
修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置，如下所示：
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'