centos7安装MYSQL

yum install mysql

yum install mysql-devel

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

安装后重启MYSQL

service mysqld restart

远程访问CENTOS的MYSQL数据库设置

mysql -u root

grant all privileges on *.* to root@'%'identified by 'root';  后面的root是root用户的密码

grant all privileges on *.* to root@'localhost'identified by 'root';  mysql -u root -p 

CENTOS设置MYSQL字符集

show variables like 'character_set%';

vim etc/my.cnf

修改成如下：

[client] 

port=3306 

socket=/var/lib/mysql/mysql.sock 

default-character-set=utf8 

[mysqld] 

datadir=/var/lib/mysql 

socket=/var/lib/mysql/mysql.sock 

user=mysql 

# Disabling symbolic-links is recommended to prevent assorted security risks 

symbolic-links=0 

character-set-server=utf8 

[mysql] 

no-auto-rehash 

default-character-set=utf8 

[mysqld_safe] 

log-error=/var/log/mysqld.log 

pid-file=/var/run/mysqld/mysqld.pid

重启mysql服务：service mysqld restart

权限

SHOW GRANTS;

grant create routine on mysql.* to root;

flush privileges;

grant execute on mysql.* to root;

flush privileges;

grant alter routine on mysql.* to root;

flush privileges;

delimiter $

CREATE PROCEDURE sp_test()

BEGIN

SELECT * FROM t1;

END;