欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

MySQL5.7.15安裝(二進制版本)-創(chuàng)新互聯(lián)

0.創(chuàng)建mysql用戶和組信息[root@gxoradb1 ~]# groupadd mysql [root@gxoradb1 ~]# useradd -r -g mysql -s /bin/false mysql
1.指定安裝目錄[root@gxoradb1 ~]# cd /usr/local [root@gxoradb1 local]# ls mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz
2.解壓mysql[root@gxoradb1 local]# tar -zxvf mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz [root@gxoradb1 local]# mv mysql-advanced-5.7.15-linux-glibc2.5-x86_64/ mysql-5.7.15 [root@gxoradb1 local]# ln -s mysql-5.7.15 mysql [root@gxoradb1 local]# ls -la lrwxrwxrwx  1 root root   12 Oct  4 14:58 mysql -> mysql-5.7.15 drwxr-xr-x  9 root root  4096 Oct  4 14:56 mysql-5.7.15
3.調整目錄權限[root@gxoradb1 local]# cd mysql [root@gxoradb1 mysql]# mkdir mysql-files[root@gxoradb1 mysql]# chmod 750 mysql-files [root@gxoradb1 mysql]# chown -R mysql:mysql .
The mysql-files directory provides a convenient location to use as the value of the secure_file_priv system variable that limits import/export operations to a specific directory.
4.初始化mysql[root@gxoradb1 mysql]# bin/mysqld --initialize --user=mysql2016-10-04T07:07:05.044029Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-10-04T07:07:05.351321Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-10-04T07:07:05.396915Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-10-04T07:07:05.454329Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2825c52a-8a01-11e6-abb2-080027b5eb23. 2016-10-04T07:07:05.456104Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-10-04T07:07:06.265334Z 0 [Warning] CA certificate ca.pem is self signed. 2016-10-04T07:07:06.503976Z 1 [Note] A temporary password is generated for root@localhost: <5Tk+Gs7frb7 //臨時口令[root@gxoradb1 mysql]# bin/mysql_ssl_rsa_setup
5.調整目錄權限[root@gxoradb1 mysql]# chown -R root . [root@gxoradb1 mysql]# chown -R mysql data mysql-files
6.啟動mysql[root@gxoradb1 mysql]# bin/mysqld_safe --user=mysql & [1] 11211 [root@gxoradb1 mysql]# 2016-10-04T07:10:20.032700Z mysqld_safe Logging to '/usr/local/mysql/data/gxoradb1.err'. 2016-10-04T07:10:20.058270Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
7.創(chuàng)建自啟動腳本[root@gxoradb1 mysql]# cp support-files/mysql.server /etc/init.d/mysql.server [root@gxoradb1 mysql]# chkconfig --add mysql.server [root@gxoradb1 mysql]# chkconfig --list mysql.server   mysql.server   0:off  1:off  2:on   3:on   4:on   5:on   6:off
8.登錄mysql數(shù)據(jù)庫[root@gxoradb1 ~]# mysql -u root -h localhost -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.15-enterprise-commercial-advanced Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
9.修改root用戶口令mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'oracle';mysql> set password for 'root'@'localhost'=password('oracle');


10余年的攸縣網(wǎng)站建設經驗,針對設計、前端、開發(fā)、售后、文案、推廣等六對一服務,響應快,48小時及時工作處理。營銷型網(wǎng)站建設的優(yōu)勢是能夠根據(jù)用戶設備顯示端的尺寸不同,自動調整攸縣建站的顯示方式,使網(wǎng)站能夠適用不同顯示終端,在瀏覽器中調整網(wǎng)站的寬度,無論在任何一種瀏覽器上瀏覽網(wǎng)站,都能展現(xiàn)優(yōu)雅布局與設計,從而大程度地提升瀏覽體驗。創(chuàng)新互聯(lián)公司從事“攸縣網(wǎng)站設計”,“攸縣網(wǎng)站推廣”以來,每個客戶項目都認真落實執(zhí)行。官方文檔中對二進制安裝的說明shell> yum install libaio //安裝libaio包shell> groupadd mysqlshell> useradd -r -g mysql -s /bin/false mysqlshell> cd /usr/localshell> tar zxvf /path/to/mysql-VERSION-OS.tar.gzshell> ln -s full-path-to-mysql-VERSION-OS mysqlshell> cd mysqlshell> mkdir mysql-filesshell> chmod 750 mysql-filesshell> chown -R mysql .shell> chgrp -R mysql .shell> bin/mysql_install_db --user=mysql    # Before MySQL 5.7.6 shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and up shell> bin/mysql_ssl_rsa_setup              # MySQL 5.7.6 and up shell> chown -R root .shell> chown -R mysql data mysql-filesshell> bin/mysqld_safe --user=mysql &# Next command is optional shell> cp support-files/mysql.server /etc/init.d/mysql.server
DirectoryContents of Directory
bin,scriptsmysqld server, client and utility programs
dataLog files, databases
docsMySQL manual in Info format
manUnix manual pages
includeInclude (header) files
libLibraries
shareMiscellaneous support files, including error messages, sample configuration files, SQL for database installation

另外有需要云服務器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn,海內外云服務器15元起步,三天無理由+7*72小時售后在線,公司持有idc許可證,提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案,具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢,專為企業(yè)上云打造定制,能夠滿足用戶豐富、多元化的應用場景需求。

名稱欄目:MySQL5.7.15安裝(二進制版本)-創(chuàng)新互聯(lián)
當前網(wǎng)址:http://www.chinadenli.net/article28/dsggjp.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián),為您提供電子商務網(wǎng)站內鏈網(wǎng)站營銷網(wǎng)站收錄小程序開發(fā)外貿網(wǎng)站建設

廣告

聲明:本網(wǎng)站發(fā)布的內容(圖片、視頻和文字)以用戶投稿、用戶轉載內容為主,如果涉及侵權請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內容未經允許不得轉載,或轉載時需注明來源: 創(chuàng)新互聯(lián)

h5響應式網(wǎng)站建設