午夜伦4480yy私人影院,亚洲日本三级,亚洲在线中文字幕

最新在學(xué)習(xí)MySQL，純新手，對(duì)Linux了解的也不多，因?yàn)槭窍螺d的最新版的MySQL（MySQL5.7.18）二進(jìn)制包，CentOS7.2下測(cè)試安裝，方便以后折騰。

大概步驟如下，安裝刪除反復(fù)折騰了幾遍，按照以下步驟，應(yīng)該沒(méi)啥問(wèn)題了。

也沒(méi)有想象中的復(fù)雜，大部分步驟都是參考網(wǎng)上的，照做就是了，出錯(cuò)的話(huà)，多嘗試，多查資料。

操作系統(tǒng)版本

創(chuàng)建mysql組和用戶(hù)

下載最新版的MySQL 5.7.18二進(jìn)制包，上傳至服務(wù)器的usr/local目錄下

解壓MySQL二進(jìn)制包

如下是解壓之后的，并且重命名文件夾之后的文件信息

更改所屬的組和用戶(hù)

解壓之后的MySQL文件包含的內(nèi)容

查看support-files文件夾的內(nèi)容，發(fā)現(xiàn)并沒(méi)有my_default.cnf默認(rèn)的配置文件，如果沒(méi)有默認(rèn)的配置文件，需要手動(dòng)創(chuàng)建一個(gè)my_default.cnf配置文件

Linux下MySQL5.7.18二進(jìn)制包安裝教程（無(wú)默認(rèn)配置文件my_default.cnf）

從網(wǎng)上找了一個(gè)配置文件，如下，上傳到supp-files文件夾中，當(dāng)然這個(gè)配置文件可以根據(jù)需要自行修改

									# For advice on how to change settings please see

									# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

									# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

									# *** default location during install, and will be replaced if you

									# *** upgrade to a newer version of MySQL.

									[mysqld]

									sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

									# 一般配置選項(xiàng)

									basedir = /usr/local/mysql

									datadir = /usr/local/mysql/data

									port = 3306

									socket = /var/run/mysqld/mysqld.sock

									character-set-server=utf8

									back_log = 300

									max_connections = 3000

									max_connect_errors = 50

									table_open_cache = 4096

									max_allowed_packet = 32M

									#binlog_cache_size = 4M

									max_heap_table_size = 128M

									read_rnd_buffer_size = 16M

									sort_buffer_size = 16M

									join_buffer_size = 16M

									thread_cache_size = 16

									query_cache_size = 128M

									query_cache_limit = 4M

									ft_min_word_len = 8

									thread_stack = 512K

									transaction_isolation = REPEATABLE-READ

									tmp_table_size = 128M

									#log-bin=mysql-bin

									long_query_time = 6

									server_id=1

									innodb_buffer_pool_size = 1G

									innodb_thread_concurrency = 16

									innodb_log_buffer_size = 16M

									innodb_log_file_size = 512M

									innodb_log_files_in_group = 3

									innodb_max_dirty_pages_pct = 90

									innodb_lock_wait_timeout = 120

									innodb_file_per_table = on

									[mysqldump]

									quick

									max_allowed_packet = 32M

									[mysql]

									no-auto-rehash

									default-character-set=utf8

									safe-updates

									[myisamchk]

									key_buffer = 16M

									sort_buffer_size = 16M

									read_buffer = 8M

									write_buffer = 8M

									[mysqlhotcopy]

									interactive-timeout

									[mysqld_safe]

									open-files-limit = 8192

									[client]

									/bin/bash: Q: command not found