MySQL in Mac安装和使用
MySQL使用
安装环境:mac
MySQL安装
-
下载安装,我已经不太记得了,有点久远的事情
从 官网下载dmg,直接安装就好,有一步需要注意的就是弹出初始密码的时候记得记下来!!!
-
配置环境变量
-
进入
bash_profile
文件xxxdeMacBook-Pro:~ xxx$ vim ~/.bash_profile
-
按 i 进入编辑模式,在文件末尾加上mysql的文件路径:
export PATH=${PATH}:/usr/local/mysql/bin
-
输入
:wq
退出vim编辑,冒号不要忘记了!不然会进入[email protected]
状态。 -
使得该文件生效
xxxdeMacBook-Pro:~ xxx$ vim ~/.bash_profile
-
-
进入mysql
# enter mysql pattern refrence : mysql -u <username> -p xxxdeMacBook-Pro:~ xxx$ mysql -u root -p
随后输入密码
xxxdeMacBook-Pro:~ xxx$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.11 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>
-
忘记密码了咋整,发现了一个很神奇的东西
输入新的密码,再在终端上尝试一下你的新密码,你就会惊喜的发现it works!
MySQL使用
ubuntu
service mysql start
service mysql restart
service mysql stop