CentOS 7 安裝MySql Server 5.6

標籤：

1. 安裝MySql Server

在/etc/yum.repos.d/目錄下添加以下檔案mysql-community.repo檔案，內容如下：

1 [mysql56-community]2 name=MySQL 5.6 Community Server3 baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/5/$basearch/4 enabled=15 gpgcheck=0

     執行yum install mysql-community-server即可。

     啟動服務 # service mysqld start

2 .設定密碼

 1 [[email protected] yl]# mysql -u root  2 Welcome to the MySQL monitor.  Commands end with ; or \g. 3 Your MySQL connection id is 3 4 Server version: 5.6.26 MySQL Community Server (GPL) 5  6 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. 7  8 Oracle is a registered trademark of Oracle Corporation and/or its 9 affiliates. Other names may be trademarks of their respective10 owners.11 12 Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.13 14 mysql> set password for ‘root‘@‘localhost‘ =password(‘password‘);

3. 遠端連線設定

把在所有資料庫的所有表的所有許可權賦值給位於所有IP地址的root使用者。

mysql> grant all privileges on *.* to [email protected]‘%‘identified by ‘password‘;

如果是新使用者而不是root，則要先建立使用者

mysql>create user ‘username‘@‘%‘ identified by ‘password‘;  

4  . 將firewall關閉：

[[email protected] ~]# systemctl stop firewalld.service #停止firewall

[[email protected] ~]# systemctl disable firewalld.service #禁止firewall開機啟動

最後reboot電腦 

此時就可以進行遠端連線了。

CentOS 7 安裝MySql Server 5.6