在mac下安装mysql使用对密码的修改,经常忘记和多次修改以后不知道使用的密码是什么,新安装的mysql使用的是空密码,使用的操作可以解决问题
安装mysql:
brew install mysql
Updating Homebrew...
Warning: mysql 8.0.12 is already installed and up-to-date
To reinstall 8.0.12, run `brew reinstall mysql`
mac下对mysql的启动、重启、停止操作命令
➜ ~ brew info mysql :查看数据库的基本信息
We’ve installed your MySQL database without a root password. To secure it run:
修改mysql密码策略
mysql_secure_installation
MySQL is configured to only allow connections from localhost by default
To connect run:
mysql -uroot
To have launchd start mysql now and restart at login:
brew services start mysql
Or, if you don't want/need a background service you can just run:
mysql.server start
查找mysql进程,查看mysql安装路径
ps -ef | grep mysql
使用下面的命令可以查看到mac电脑上安装mysql数据库时使用到的数据库信息,
启动的服务名称:/usr/local/Cellar/mysql/8.0.12/bin