下面講講關(guān)于mysql8.0.11安裝、啟動(dòng)與基本設(shè)置操作方法，文字的奧妙在于貼近主題相關(guān)。所以，閑話就不談了，我們直接看下文吧，相信看完mysql8.0.11安裝、啟動(dòng)與基本設(shè)置操作方法這篇文章你一定會(huì)有所受益。

成都創(chuàng)新互聯(lián)公司致力于互聯(lián)網(wǎng)網(wǎng)站建設(shè)與網(wǎng)站營(yíng)銷(xiāo)，提供成都網(wǎng)站制作、做網(wǎng)站、網(wǎng)站開(kāi)發(fā)、seo優(yōu)化、網(wǎng)站排名、互聯(lián)網(wǎng)營(yíng)銷(xiāo)、微信平臺(tái)小程序開(kāi)發(fā)、公眾號(hào)商城、等建站開(kāi)發(fā)，成都創(chuàng)新互聯(lián)公司網(wǎng)站建設(shè)策劃專(zhuān)家，為不同類(lèi)型的客戶提供良好的互聯(lián)網(wǎng)應(yīng)用定制解決方案，幫助客戶在新的全球化互聯(lián)網(wǎng)環(huán)境中保持優(yōu)勢(shì)。

   此次演示的是mysql 8.0.11的安裝、啟動(dòng)與基本設(shè)置。
   下載mysql-8.0.11-el7-x86_64.tar.gz

1、解壓并重命名
[root@localhost ~]# cd /data
[root@localhost data]# ls
mysql-8.0.11-el7-x86_64.tar.gz
[root@localhost data]# tar -zxf mysql-8.0.11-el7-x86_64.tar.gz
[root@localhost data]# mv mysql-8.0.11-el7-x86_64 mysql

2、創(chuàng)建mysql用戶
[root@localhost data]# useradd -M -s /sbin/nologin mysql

3、初始化數(shù)據(jù)庫(kù)
[root@localhost data]# cd mysql/
[root@localhost mysql]# ./bin/mysqld --initialize --user=mysql --datadir=/data/mysql/data
2018-04-26T03:06:01.637456Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-04-26T03:06:01.637709Z 0 [System] [MY-013169] [Server] /data/mysql/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 53030

   2018-04-26T03:06:17.384428Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: *wbnbphswv8>K*此為數(shù)據(jù)庫(kù)初始密碼
   2018-04-26T03:06:26.959938Z 0 [System] [MY-013170] [Server] /data/mysql/bin/mysqld (mysqld 8.0.11) initializing of server has completed

4、編輯配置文件
[root@localhost mysql]# vim /etc/my.cnf
[client]
port    = 3306
socket   = /tmp/mysql.sock

   [mysqld]
   datadir=/data/mysql/data
   socket=/tmp/mysql.sock
   port=3306
   user=mysql
   basedir=/data/mysql
   symbolic-links=0

   [mysqld_safe]
   log-error=/data/mysql/data/error.log
   pid-file=/data/mysql/data/mysql.pid

5、啟動(dòng)
[root@localhost mysql]# ./bin/mysqld --defaults-file=/etc/my.cnf &
[1] 53216
[root@localhost mysql]# 2018-04-26T03:18:05.050872Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-04-26T03:18:05.051064Z 0 [System] [MY-010116] [Server] /data/mysql/bin/mysqld (mysqld 8.0.11) starting as process 53216
2018-04-26T03:18:06.208674Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-04-26T03:18:06.240611Z 0 [System] [MY-010931] [Server] /data/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server - GPL.

6、查看進(jìn)程
[root@localhost mysql]# ps aux| grep mysql
qiang   10783  0.0  0.2 165020  4452 pts/0   S+  14:38  0:00 /data/mysql/bin/mysql -uroot -p
qiang   12866  0.0  0.0 112664  972 pts/1   R+  15:19  0:00 grep --color=auto mysql
root   14040  0.0  0.0 113252  1528 ?     S   8月07  0:00 /bin/sh /data/mysql/bin/mysqld_safe --datadir=/data/mysql/data --pid-file=/data/mysql/data/baobao.pid
mysql   14231  0.3 20.3 1365424 382536 ?    Sl  8月07  14:47 /data/mysql/bin/mysqld --basedir=/data/mysq --datadir=/data/mysql/data --plugin-dir=/data/mysql/lib/plugin --user=mysql --log-error=/data/mysql/data/mysql_error.log --pid-file=/data/mysql/data/baobao.pid --socket=/tmp/mysql.sock --port=13306

7、設(shè)置啟動(dòng)腳本
[root@localhost mysql]# cp ./support-files/mysql.server /etc/init.d/mysqld
修改啟動(dòng)參數(shù)
[root@localhost mysql]# vi /etc/init.d/mysqld
basedir=/data/mysql
datadir=/data/mysql/data

8、關(guān)閉與啟動(dòng)
停止
[root@localhost data]# /etc/init.d/mysqld stop
Shutting down MySQL... SUCCESS!
啟動(dòng)
[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL.... SUCCESS!

9、數(shù)據(jù)庫(kù)簡(jiǎn)單設(shè)置
[root@localhost mysql]# ./bin/mysql -uroot -p
Enter password: wbnbphswv8>K
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.11

   Copyright (c) 2000, 2018, 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> show databases;
   ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
   mysql> alter user root@localhost identified by '123123';
   Query OK, 0 rows affected (0.14 sec)

   mysql> show databases;
   +--------------------+
   | Database      |
   +--------------------+
   | information_schema |
   | mysql        |
   | performance_schema |
   | sys         |
   +--------------------+
   4 rows in set (0.10 sec)
  mysql> 
對(duì)于以上mysql8.0.11安裝、啟動(dòng)與基本設(shè)置操作方法相關(guān)內(nèi)容，大家還有什么不明白的地方嗎？或者想要了解更多相關(guān)，可以繼續(xù)關(guān)注我們的行業(yè)資訊板塊。

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

本文名稱(chēng)：mysql8.0.11安裝、啟動(dòng)與基本設(shè)置操作方法-創(chuàng)新互聯(lián)
文章地址：http://jinyejixie.com/article48/djseep.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站營(yíng)銷(xiāo)、網(wǎng)站設(shè)計(jì)公司、品牌網(wǎng)站設(shè)計(jì)、小程序開(kāi)發(fā)、企業(yè)建站、網(wǎng)站內(nèi)鏈

廣告

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