站長(zhǎng)資訊網(wǎng)
        最全最豐富的資訊網(wǎng)站

        步驟分明地教你在MAC上安裝MYSQL

        本篇文章帶大家簡(jiǎn)析下MAC安裝MYSQL的方法,介紹一下MYSQL的一些知識(shí),希望對(duì)大家有所幫助!

        下載地址:https://downloads.mysql.com/archives/community/

        百度網(wǎng)盤下載:鏈接:https://pan.baidu.com/s/1nceFzJKK7_dJh2gUAtVgWw 密碼:qm5z

        步驟分明地教你在MAC上安裝MYSQL

        安裝

        雙擊下載好的dmg文件,會(huì)彈出pkg彈框,再雙擊pkg圖標(biāo),進(jìn)入安裝界面,在安裝界面上一路繼續(xù),就安裝成功了。

        環(huán)境變量

        第一步,在終端切換到根目錄,編輯./.bash_profile文件

        ?  ~ cd ~ ?  ~ vim ./.bash_profile

        第二步,進(jìn)入vim編輯環(huán)境,按下i進(jìn)入insert模式,輸入

        export PATH=$PATH:/usr/local/mysql/bin export PATH=$PATH:/usr/local/mysql/support-files

        第三步,按下 esc 退出 insert 模式,輸入 :wq 保存配置文件

        :wq

        第四步,在終端界面輸入以下命令,讓配置文件的修改生效,并查看環(huán)境變量是否設(shè)置成功

        ?  ~ echo $PATH /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin ?  ~ source ~/.bash_profile  ?  ~ echo $PATH             /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/mysql/bin:/usr/local/mysql/support-files ?  ~

        MYSQL服務(wù)的啟停和狀態(tài)的查看

        查看MYSQL的服務(wù)狀態(tài)

        ?  ~ sudo mysql.server status Password:  ERROR! MySQL is not running

        啟動(dòng)MYSQL服務(wù)

        ?  ~ sudo mysql.server start  Starting MySQL .Logging to '/usr/local/mysql/data/mj.local.err'.  SUCCESS!

        停止MYSQL服務(wù)

        ?  ~ sudo mysql.server stop   Shutting down MySQL . SUCCESS!

        重啟MYSQL服務(wù)

        ?  ~ sudo mysql.server restart  ERROR! MySQL server PID file could not be found! Starting MySQL . SUCCESS!

        啟動(dòng)

        第一步,終端界面下輸入

        ?  ~ sudo mysql.server start  Starting MySQL .Logging to '/usr/local/mysql/data/mj.local.err'.  SUCCESS!

        第二步,啟動(dòng)MYSQL服務(wù),啟動(dòng)成功后繼續(xù)輸入

        ?  ~ mysql -u root -p

        第三步,直接回車,進(jìn)入數(shù)據(jù)庫(kù),看到以下歡迎界面

        Enter password:  Welcome to the MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.6.41 MySQL Community Server (GPL)  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>

        備注:默認(rèn)安裝成功后沒(méi)有初始密碼,所以密碼不用輸入,直接回車即可。

        初始化設(shè)置

        設(shè)置初始密碼,進(jìn)入mysql數(shù)據(jù)庫(kù)之后執(zhí)行下面的語(yǔ)句,設(shè)置當(dāng)前root用戶的密碼為root

        ?  ~ mysql -u root -p Enter password:  Welcome to the MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.6.41 MySQL Community Server (GPL)  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> set password = password('root'); Query OK, 0 rows affected (0.01 sec)  mysql>

        退出MYSQL的界面

        mysql> exit Bye ?  ~

        配置

        進(jìn)入到 /usr/local/mysql/support-files目錄,里面有個(gè)文件my-default.cnf

        ?  ~ cd /usr/local/mysql/support-files ?  support-files ll total 64 -rwxr-xr-x  1 root  wheel   1.1K  6 15  2018 binary-configure -rw-r--r--  1 root  wheel   773B  6 15  2018 magic -rw-r--r--  1 root  wheel   1.1K  6 15  2018 my-default.cnf -rwxr-xr-x  1 root  wheel   894B  6 15  2018 mysql-log-rotate -rwxr-xr-x  1 root  wheel    10K  6 15  2018 mysql.server -rwxr-xr-x  1 root  wheel   1.0K  6 15  2018 mysqld_multi.server ?  support-files

        將目錄下的my-default.cnf文件復(fù)制到桌面上,改名為my.cnf,

        ?  support-files ll total 64 -rwxr-xr-x  1 root  wheel   1.1K  6 15  2018 binary-configure -rw-r--r--  1 root  wheel   773B  6 15  2018 magic -rw-r--r--  1 root  wheel   1.1K  6 15  2018 my-default.cnf -rwxr-xr-x  1 root  wheel   894B  6 15  2018 mysql-log-rotate -rwxr-xr-x  1 root  wheel    10K  6 15  2018 mysql.server -rwxr-xr-x  1 root  wheel   1.0K  6 15  2018 mysqld_multi.server ?  support-files cp my-default.cnf /Users/a1/Desktop/my.cnf

        將內(nèi)容替換為下面的內(nèi)容

        [mysqld] default-storage-engine=INNODB character-set-server=utf8 port = 3306  [client] default-character-set=utf8

        將修改后的my.cnf文件復(fù)制到/etc目錄下,重啟MYSQL

        ?  /etc cp /Users/a1/Desktop/my.cnf ./ cp: ./my.cnf: Permission denied ?  /etc sudo cp /Users/a1/Desktop/my.cnf ./ Password: ?  /etc ll total 1064 ...... -rw-------   1 root  wheel   7.3K  2 29 14:10 master.passwd -rw-r--r--   1 root  wheel   1.2K  5 17 17:24 my.cnf -rw-r--r--   1 root  wheel    11B  2 29 14:43 nanorc -rw-r--r--   1 root  wheel    53B  2 29 14:09 networks ...... ?  /etc

        備注:拷貝文件到etc目錄需要系統(tǒng)權(quán)限,因此需要在命令前加sudo

        檢測(cè)修改結(jié)果

        步驟分明地教你在MAC上安裝MYSQL

        ?  ~ mysql -u root -p Enter password:  Welcome to the MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 4 Server version: 5.6.41 MySQL Community Server (GPL)  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 variables like '%char%'; +--------------------------+-----------------------------------------------------------+ | Variable_name            | Value                                                     | +--------------------------+-----------------------------------------------------------+ | character_set_client     | utf8                                                      | | character_set_connection | utf8                                                      | | character_set_database   | latin1                                                    | | character_set_filesystem | binary                                                    | | character_set_results    | utf8                                                      | | character_set_server     | latin1                                                    | | character_set_system     | utf8                                                      | | character_sets_dir       | /usr/local/mysql-5.6.41-macos10.13-x86_64/share/charsets/ | +--------------------------+-----------------------------------------------------------+ 8 rows in set (0.01 sec)  mysql>

        備注:此時(shí)不輸入密碼就登錄不了數(shù)據(jù)庫(kù)了,必須使用修改后的密碼登錄數(shù)據(jù)庫(kù)了,并且數(shù)據(jù)庫(kù)的字符集編碼信息已經(jīng)修改了。

        至此,就可以愉快的使用數(shù)據(jù)庫(kù)了!!!

        推薦學(xué)習(xí):《mysql視頻教程》

        贊(0)
        分享到: 更多 (0)
        網(wǎng)站地圖   滬ICP備18035694號(hào)-2    滬公網(wǎng)安備31011702889846號(hào)
        主站蜘蛛池模板: 国产色婷婷五月精品综合在线| 亚洲日韩国产精品第一页一区| 在线观看自拍少妇精品| 精品国产成人国产在线观看| 精品视频一区二区三区四区五区 | 国产成人精品高清在线观看93| 99精品一区二区三区无码吞精 | 欧美性videos高清精品| 国产乱人伦偷精品视频免下载 | 一本色道久久88精品综合 | 国内精品久久久久久久coent| 亚洲日本精品一区二区| 国产在线精品国自产拍影院| 国产精品1024香蕉在线观看| 精品日韩亚洲AV无码| 国产一区二区精品久久岳| 国产成人精品免费午夜app| 91精品国产91久久久久久| 精品无人区无码乱码大片国产| 好属妞这里只有精品久久| 欧洲精品一区二区三区在线观看| 亚洲高清国产拍精品26U| 久久精品视频网| 亚洲国产欧美日韩精品一区二区三区 | 国产精品免费久久久久电影网| 亚洲国产精品成人久久蜜臀| 麻豆精品视频在线观看| 精品91自产拍在线观看二区| 国产精品成人免费观看| 国产精品99无码一区二区| 99久久精品九九亚洲精品| 亚洲国模精品一区| 免费看一级毛片在线观看精品视频 | 999久久久免费精品国产| 99国产欧美精品久久久蜜芽| 国产精品美女一区二区视频| 国产成人精品视频一区二区不卡| 国产精品久久久久…| 久久免费精品一区二区| 日韩欧美精品不卡| 大胸国产精品视频|