linux安装mysql数据库

1.下载资源
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.解压下载的资源：
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3.安装mysql-serve
yum -y install mysql-server
4.linux管理mysql的命令
启动mysql：
systemctl start mysqld.service
停止MySQL服务：
systemctl stop mysqld.service
重启mysql服务
systemctl restart mysqld.service
查看mysql服务当前状态
systemctl status mysqld.service
设置mysql服务开机自启动
systemctl enable mysqld.service
停止mysql服务开机自启动
systemctl disable mysqld.service
5.mysql5.6版本安装完后默认密码是空的，登录立即修改密码。
$ mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(“admin123”) where User=‘root’;
mysql> flush privileges;
6.设置远程主机登录：
GRANT ALL PRIVILEGES ON . TO ‘your username’@’%’ IDENTIFIED BY ‘your password’;
GRANT ALL PRIVILEGES ON . TO root@"%" IDENTIFIED BY “admin123”;