一、下載mysql5.6

二、準備

創建mysql用戶~]#?useradd?mysql

三、安裝

1、上傳到服務器中并解壓~]#?tar?zxvf?mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

~]#?mv?mysql-5.6.40-linux-glibc2.12-x86_64?mysql56-3306

2、授權~]#?chown?-R?mysql.mysql?./

3、初始化~]#?cd?mysql56-3306

mysql56-3306]#?scripts/mysql_install_db?--user=mysql?--datadir=/home/mysql/mysql56-3306/data?--basedir=/home/mysql/mysql56-3306/

注：如初出項下列情況

FATAL?ERROR:?please?install?the?following?Perl?modules?before?executing?scripts/mysql_install_db:

Data::Dumper

安裝autoconf庫即可mysql56-3306]#?yum?-y?install?autoconf

4、編輯my.cnf文件[mysqld]

basedir?=?/home/mysql/mysql56-3306

datadir?=?/home/mysql/mysql56-3306/data

port?=?3306

socket?=?/home/mysql/mysql56-3306/socket/mysql.sock

pid-file?=?/home/mysql/mysql56-3306/pid/mysql.pid

log-error?=?/home/mysql/mysql56-3306/logs/mysql.log

user?=?mysql

character-set-server=utf8

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

5、創建文件mysql56-3306]#?mkdir?socket?pid?logs

mysql56-3306]#?touch?socket/mysql.sock?pid/mysql.pid?logs/mysql.log

mysql56-3306]#?chown?-R?mysql.mysql?./

6、啟動mysql56-3306]#?bin/mysqld_safe?--defaults-file=my.cnf?&

7、停止mysql56-3306]#?ps?-ef?|?grep?mysql

mysql56-3306]#?kill?25152?24977

8、其他mysql56-3306]#?bin/mysql?-h?127.0.0.1?-uroot?-p

mysql>?set?password=password('123456');

mysql>?grant?all?on?*.*?to?root@'%'?identified?by?'123456';

mysql>?flush?privileges;

總結

以上是生活随笔為你收集整理的mysql5.6 centos_centos部署mysql5.6免安装版的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。