12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间:2024-11-26 22:17:26
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
方法一:用dmg镜像安装1、安装官网下载好 MySQL Mac 版安装包,常规步骤安装,安装过程中会出现如下提示:2019-03-24T18:27:31.043133Z1[Note]Atemporarypasswordisgeneratedforroo
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
1、安装
官网下载好 MySQL Mac 版安装包,常规步骤安装,安装过程中会出现如下提示:
2019-03-24T18:27:31.043133Z1[Note]Atemporarypasswordisgeneratedforroot@localhost:TdfRm19!o0Xi
其中TdfRm19!o0Xi
是初始密码,最好先记住!
2、登陆
在终端命令行 登陆mysql:
$mysql-uroot-p#输入上述密码即可
如果这一步提示: bash: mysql: command not found
, 执行下面2个命令做个软连接即可:
cd/usr/local/binln-fs/usr/local/mysql-8.0.11-macos10.13-x86_64/bin/mysqlmysql
3、修改密码
在 MySQL8.0.4 以前,执行 SET PASSWORD=PASSWORD('新密码')
即可。但新版本不能这样改了,因为密码认证变了。具体步骤可以参考 https://blog.csdn.net/yi247630676/article/details/80352655。
总所周知,Mac 可以利用 homebrew 进行安装管理,十分方便,如果没有安装 homebrew, 可以点击 https://brew.sh/ 安装。
下面是 mysql 的安装方式
$brewinstallmysql#安装指定版本:brewinstallmysql@1.1.1
接下来只要等待就可以了,出现下面文字后我们已经很清楚我们需要做什么了:
==>mysqlWe'veinstalledyourMySQLdatabasewithoutarootpassword.Tosecureitrun:mysql_secure_installationMySQLisconfiguredtoonlyallowconnectionsfromlocalhostbydefaultToconnectrun:mysql-urootTohavelaunchdstartmysqlnowandrestartatlogin:brewservicesstartmysqlOr,ifyoudon'twant/needabackgroundserviceyoucanjustrun:mysql.serverstart
按说明继续执行,进行初始化操作:
$myysql_secure_installation
初始化过程中会有很多问题,以下是具体问题部分,以注释为解释:
WouldyouliketosetupVALIDATEPASSWORDcomponent?Pressy|YforYes,anyotherkeyforNo:Y##回复y需要密码8位以上,回复n则不做限制Thepasswordvalidationcomponentisnotavailable.Proceedingwiththefurtherstepswithoutthecomponent.Pleasesetthepasswordforroothere.Newpassword:##设置你的密码Re-enternewpassword:##再次输入你的密码Bydefault,aMySQLinstallationhasananonymoususer,allowinganyonetologintoMySQLwithouthavingtohaveauseraccountcreatedforthem.Thisisintendedonlyfortesting,andtomaketheinstallationgoabitsmoother.Youshouldremovethembeforemovingintoaproductionenvironment.Removeanonymoususers?(Pressy|YforYes,anyotherkeyforNo):Y##是否移除匿名用户。考虑安全我选了ySuccess.Normally,rootshouldonlybeallowedtoconnectfrom'localhost'.Thisensuresthatsomeonecannotguessattherootpasswordfromthenetwork.Disallowrootloginremotely?(Pressy|YforYes,anyotherkeyforNo):Y##是否允许远程连mysql的root。我用做本地调试,不是远程服务器,所以y了Success.Bydefault,MySQLcomeswithadatabasenamed'test'thatanyonecanaccess.Thisisalsointendedonlyfortesting,andshouldberemovedbeforemovingintoaproductionenvironment.Removetestdatabaseandaccesstoit?(Pressy|YforYes,anyotherkeyforNo):Y##是否y了删除test数据库,我选了y-Droppingtestdatabase...Success.-Removingprivilegesontestdatabase...Success.Reloadingtheprivilegetableswillensurethatallchangesmadesofarwilltakeeffectimmediately.Reloadprivilegetablesnow?(Pressy|YforYes,anyotherkeyforNo):y##选y,重新加载权限列表Success.Alldone!
到此配置就结束了,下面我们启动 mysql 即可,记住以下命令:
$mysql-uroot-p##登陆mysql$brewservicesstartmysql@5.7##启动mysql$brewservicesstopmysql@5.7##停止mysql$mysql.serverstart##启动mysql(无后台服务)
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19