建站
咨詢
售后
建站咨詢
新聞中心
這篇文章主要為大家展示了“MySQL5.7.18 for Linux7.2如何實現(xiàn)二進制安裝”，內(nèi)容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領大家一起研究并學習一下“MySQL5.7.18 for Linux7.2如何實現(xiàn)二進制安裝”這篇文章吧。
為雙灤等地區(qū)用戶提供了全套網(wǎng)頁設計制作服務，及雙灤網(wǎng)站建設行業(yè)解決方案。主營業(yè)務為成都網(wǎng)站設計、成都網(wǎng)站制作、雙灤網(wǎng)站設計，以傳統(tǒng)方式定制建設網(wǎng)站，并提供域名空間備案等一條龍服務，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務。我們深信只要達到每一位用戶的要求，就會得到認可，從而選擇與我們長期合作。這樣，我們也可以走得更遠！
具體的做法如下：
1、下載二進制軟件包：
mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
2、添加MySQL用戶和組：
[root@localhost ~]# userdel mysql （因為是新系統(tǒng)，所以就把現(xiàn)有的MySQL用戶給刪除了）
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -g mysql mysql
[root@localhost ~]# passwd mysql （MySQL密碼要設置的復雜一點，或者在創(chuàng)建用戶的時候設置不讓登陸系統(tǒng)）
3、創(chuàng)建安裝MySQL目標，并解壓軟件到指定目錄
[root@localhost ~]# mkdir -p /mysql/data
[root@localhost ~]# chown -R mysql.mysql /mysql
[root@localhost ~]# tar zxvf mysql-5.7.18-linux-glibc2.5-x86_64 -C /mysql
[root@localhost ~]# cd /mysql
[root@localhost ~]# mv mysql-5.7.18-linux-glibc2.5-x86_64/ mysql5718
[root@localhost ~]# chown -R mysql.mysql /mysql
4、切換MySQL用戶，并初始化數(shù)據(jù)庫
[root@localhost ~]# su - mysql
[mysql@localhost ~]$ /mysql/mysql5718/bin/mysqld --initialize --user=mysql --basedir=/mysql/mysql5718/ --datadir=/mysql/data/
-----注意，初始化數(shù)據(jù)庫會生成登錄MySQL數(shù)據(jù)庫的root密碼，一定要記住，一會登錄數(shù)據(jù)庫要用
5、編輯my.cnf配置文件，啟動數(shù)據(jù)庫
[mysql@localhost ~]$ vim my.cnf （該配置文件僅供參考）
[client]
socket = /mysql/data/mysql.sock
default_character_set = utf8
[mysql]
socket=/mysql/data/mysql.sock
[mysqld]
server_id = 1607
port = 3306
basedir = /mysql/mysql5718/
datadir = /mysql/data/
socket = /mysql/data/mysql.sock
pid_file = /mysql/data/mysql.pid
log_error = /mysql/data/mysql_error.log
log_bin = /mysql/data/mysql_bin
relay_log = /mysql/data/relay_bin
character_set_server = utf8
collation_server = utf8_general_ci
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 1G
innodb_log_files_in_group = 3
innodb_log_buffer_size = 24M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_io_capacity = 200
innodb_io_capacity_max = 600
innodb_thread_concurrency = 0
innodb_autoinc_lock_mode = 2
innodb_lock_wait_timeout = 60
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_max_dirty_pages_pct = 80
innodb_autoextend_increment = 512
innodb_checksum_algorithm = NONE
innodb_doublewrite = 0
innodb_use_native_aio = 1
innodb_open_files = 8192
sync_binlog = 1
sync_relay_log = 1
relay_log_info_repository = TABLE
master_info_repository = TABLE
expire_logs_days = 10
binlog_format = ROW
transaction-isolation = READ-COMMITTED
concurrent_insert = 2
skip_slave_start = TRUE
back_log = 2000
thread_stack = 256k
thread_cache_size = 256
key_buffer_size = 256M
tmp_table_size = 64M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 2M
join_buffer_size = 2M
query_cache_size = 0
query_cache_type = 0
max_heap_table_size = 64M
binlog_cache_size = 2M
table_open_cache = 8192
max_allowed_packet = 64M
bulk_insert_buffer_size = 64M
max_connect_errors = 100000
max_connections = 500
connect_timeout = 300
wait_timeout = 86400
interactive_timeout = 86400
lower_case_table_names = 1
open_files_limit = 20480
skip_name_resolve
skip_external_locking
explicit_defaults_for_timestamp = TRUE
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql@localhost ~]$ /mysql/mysql5718/bin/mysqld_safe --defaults-file=/mysql/data/my.cnf --user=mysql &
6、進入數(shù)據(jù)庫檢查：
[mysql@localhost ~]$ /mysql/mysql5718/bin/mysql -u root -p --socket=/mysql/data/mysql.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.18-log MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password='123456'; （因為剛才使用的密碼是個默認的登錄密碼，所以我們要修改）
mysql> flush privileges;
然后再重新登錄MySQL即可，進行檢查
mysql> s\
--------------
/mysql/mysql5718/bin/mysql Ver 14.14 Distrib 5.7.18, for linux-glibc2.5 (x86_64) using EditLine wrapper
Connection id: 7
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.18-log MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /mysql/data/mysql.sock
Uptime: 25 min 16 sec
Threads: 1 Questions: 19 Slow queries: 0 Opens: 110 Flush tables: 1 Open tables: 103 Queries per second avg: 0.012
--------------
mysql>
這樣，二進制的MySQL就順利安裝完成了；
以上是“MySQL5.7.18 for Linux7.2如何實現(xiàn)二進制安裝”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學習更多知識，歡迎關注創(chuàng)新互聯(lián)行業(yè)資訊頻道！
當前名稱：MySQL5.7.18forLinux7.2如何實現(xiàn)二進制安裝
分享地址：http://fisionsoft.com.cn/article/ihocge.html
