这篇文章主要讲解了“MAC上安装MYSQL的步骤是什么”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“MAC上安装MYSQL的步骤是什么”吧!

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

百度网盘下载:链接:https://pan.baidu.com/s/1nceFzJKK7_dJh3gUAtVgWw 密码:qm5z

安装

双击下载好的dmg文件,会弹出pkg弹框,再双击pkg图标,进入安装界面,在安装界面上一路继续,就安装成功了。

环境变量

第一步,在终端切换到根目录,编辑./.bash_profile文件

➜~cd~➜~vim./.bash_profile

第二步,进入vim编辑环境,按下i进入insert模式,输入

exportPATH=$PATH:/usr/local/mysql/binexportPATH=$PATH:/usr/local/mysql/support-files

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

:wq

第四步,在终端界面输入以下命令,让配置文件的修改生效,并查看环境变量是否设置成功

➜~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服务的启停和状态的查看

查看MYSQL的服务状态

➜~sudomysql.serverstatusPassword:ERROR!MySQLisnotrunning

启动MYSQL服务

➜~sudomysql.serverstartStartingMySQL.Loggingto'/usr/local/mysql/data/mj.local.err'.SUCCESS!

停止MYSQL服务

➜~sudomysql.serverstopShuttingdownMySQL.SUCCESS!

重启MYSQL服务

➜~sudomysql.serverrestartERROR!MySQLserverPIDfilecouldnotbefound!StartingMySQL.SUCCESS!启动

第一步,终端界面下输入

➜~sudomysql.serverstartStartingMySQL.Loggingto'/usr/local/mysql/data/mj.local.err'.SUCCESS!

第二步,启动MYSQL服务,启动成功后继续输入

➜~mysql-uroot-p

第三步,直接回车,进入数据库,看到以下欢迎界面

Enterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis1Serverversion:5.6.41MySQLCommunityServer(GPL)Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>

备注:默认安装成功后没有初始密码,所以密码不用输入,直接回车即可。

初始化设置

设置初始密码,进入mysql数据库之后执行下面的语句,设置当前root用户的密码为root

➜~mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis2Serverversion:5.6.41MySQLCommunityServer(GPL)Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>setpassword=password('root');QueryOK,0rowsaffected(0.01sec)mysql>

退出MYSQL的界面

mysql>exitBye➜~配置

进入到 /usr/local/mysql/support-files目录,里面有个文件my-default.cnf

➜~cd/usr/local/mysql/support-files➜support-fileslltotal64-rwxr-xr-x1rootwheel1.1K6152018binary-configure-rw-r--r--1rootwheel773B6152018magic-rw-r--r--1rootwheel1.1K6152018my-default.cnf-rwxr-xr-x1rootwheel894B6152018mysql-log-rotate-rwxr-xr-x1rootwheel10K6152018mysql.server-rwxr-xr-x1rootwheel1.0K6152018mysqld_multi.server➜support-files

将目录下的my-default.cnf文件复制到桌面上,改名为my.cnf,

➜support-fileslltotal64-rwxr-xr-x1rootwheel1.1K6152018binary-configure-rw-r--r--1rootwheel773B6152018magic-rw-r--r--1rootwheel1.1K6152018my-default.cnf-rwxr-xr-x1rootwheel894B6152018mysql-log-rotate-rwxr-xr-x1rootwheel10K6152018mysql.server-rwxr-xr-x1rootwheel1.0K6152018mysqld_multi.server➜support-filescpmy-default.cnf/Users/a1/Desktop/my.cnf

将内容替换为下面的内容

[mysqld]default-storage-engine=INNODBcharacter-set-server=utf8port=3306[client]default-character-set=utf8

将修改后的my.cnf文件复制到/etc目录下,重启MYSQL

➜/etccp/Users/a1/Desktop/my.cnf./cp:./my.cnf:Permissiondenied➜/etcsudocp/Users/a1/Desktop/my.cnf./Password:➜/etclltotal1064......-rw-------1rootwheel7.3K22914:10master.passwd-rw-r--r--1rootwheel1.2K51717:24my.cnf-rw-r--r--1rootwheel11B22914:43nanorc-rw-r--r--1rootwheel53B22914:09networks......➜/etc

备注:拷贝文件到etc目录需要系统权限,因此需要在命令前加sudo

检测修改结果

➜~mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis4Serverversion:5.6.41MySQLCommunityServer(GPL)Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>showvariableslike'%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/|+--------------------------+-----------------------------------------------------------+8rowsinset(0.01sec)mysql>

备注:此时不输入密码就登录不了数据库了,必须使用修改后的密码登录数据库了,并且数据库的字符集编码信息已经修改了。

感谢各位的阅读,以上就是“MAC上安装MYSQL的步骤是什么”的内容了,经过本文的学习后,相信大家对MAC上安装MYSQL的步骤是什么这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!