linux安装MYSQL

1. 官网

 https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install

2. 编辑文件

vi /etc/yum.repos.d/mysql-community.repo 

3. 添加

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

注意： 6改7，gpgcheck = 0

4. 查看源
   yum repolist enabled | grep mysql
5. CentOS 7已经将默认集成mariadb，先卸载mariadb
   rpm -e --nodeps mariadb-libs-5.5.44-1.el7_1.x86_64
6. 安装
   yum install mysql-community-server
7. 启动
   service mysqld start systemctl start mysqld.service
8. 查看状态

service mysqld status systemctl status mysqld.service

1. 停止
   service mysqld stop systemctl stop mysqld.service

2. 平滑启动
   service mysqld stop

3. 查看默认密码
   grep 'temporary password' /var/log/mysqld.log

4. 登录
   mysql -uroot -p

5. 自定义密码
   ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

6. 创建用户用来远程连接

      GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyNewPass4!' WITH GRANT OPTION;

14. 立即生效

     flush privileges;

15. 如果是centos6.5安装5.6版本http://www.jb51.net/article/47727.htm

[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql