標籤:Mysql Linux Centos 系統 營運
mysql安裝
軟體版本 MySQL-5.6.32 (文中涉及到的軟體包加最下方免費擷取)
上傳mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz到APP伺服器目錄:/usr/local/src (軟體包見附件)
#cd /usr/local/src
#tar -zxvf mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz
#mv mysql-5.6.32-linux-glibc2.5-x86_64 /usr/local/mysql
#groupadd mysql
#useradd -g mysql mysql
#cd /usr/local/mysql
#mkdir /usr/local/mysql/data/tmp
#chown -R mysql:mysql /usr/local/mysql/data
#./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
#vim /etc/my.cnf //複製以下內容
[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
character_set_server=gbk
user=mysql
default-storage-engine=INNODB
tmpdir=/usr/local/mysql/data/tmp
symbolic-links=0
innodb_buffer_pool_size = 1G
skip-name-resolve
event_scheduler = 1
port = 3306
server_id = 1
wait_timeout=2880000
interactive_timeout = 2880000
max_allowed_packet = 512M
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
lower_case_table_names = 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqldump]
quick
max_allowed_packet = 512M
[client]
default-character-set=gbk
socket=/usr/local/mysql/data/mysql.sock
#cp support-files/mysql.server /etc/init.d/mysqld
#chmod 755 /etc/init.d/mysqld
#vim /etc/init.d/mysqld //檔案開頭添加如下內容
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
#chkconfig --add mysqld //添加mysql為系統服務
#chkconfig mysqld on //設定mysql開機自啟動
#service mysqld start //啟動mysql
如果對此有興趣,請掃下面二維碼免費擷取更多詳情
Linux/Centos 源碼編譯安裝Mysql5.6