1.下載安裝包
wget http://cdn.MySQL.com/archives/mysql-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz2.解壓安裝包
tar zxvf http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz3.進入文件夾
mv mysql-5.6.26-linux-glibc2.5-x86_64 mysqlcd mysql4.創建用戶組和用戶
groupadd mysqluseradd -r -g mysql mysql5.修改權限
chown -R mysql:mysql ./6.安裝數據庫
scripts/mysql_install_db --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data --user=mysql如果出現以下異常:FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db: Data::Dumper 請安裝依賴:yum install -y perl-Module-Install.noarch7.添加MySQL為系統服務
cp support-files/mysql.server /etc/init.d/mysql8.修改MySQL服務路徑配置
vi /etc/init.d/mysql 修改 basedir=mysql安裝包路徑、datadir=mysql數據存放目錄(默認為mysql安裝包路徑/data)9.修改MySQL配置文件
vim my.cnf配置如下:basedir = mysql安裝路徑datadir = mysql安裝路徑/dataport = 3306server_id = 1socket = /tmp/mysql.socklog_error = mysql安裝路徑/mysql-error.log9.添加MySQL系統變量
vi /etc/PRofile 修改PATH=$PATH:MYSQL安裝包路徑/bin source /etc/profile // 查看是否配置成功echo $PATH10.啟動MySQL
service mysql start11.命令行連接MySQL
mysql -u root -p12.用戶授權
// 創建一個遠程用戶使他有某個數據庫的所有權限GRANT ALL PRIVILEGES ON 數據庫名.* TO 用戶名@"%" IDENTIFIED BY '密碼' WITH GRANT OPTION;新聞熱點
疑難解答
