从MySQL官网下载Mysql,在本地安装好之后,用数据库连接工具Sequl Pro去连接数据库,发现报错了,报错信息有两种:
Error1:
Unable to connect to host 127.0.0.1 because access was denied.
Double-check your username and password and ensure that access from your current location is permitted.
MySQL said: Access denied for user 'root'@'localhost' (using password: YES)
Error 2:
Unable to connect to host 127.0.0.1, or the request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Your password has expired. To log in you must change it using a client that supports expired passwords.
1、报错分析:
这种报错的原因是,安装好了mysql后,要配置mysql的环境变量,并且重置密码。在安装mysql的最后一步的时候,会弹出一个提示框,告诉你mysql的初始密码,这个需要自己记录下来,在重置密码的时候需要。
2、启动MySQL: 进入Mac的系统偏好设置
3、启好MySQL之后,我选择了Sequel pro这个软件来操作数据库
这时候,就会出现之前的两个错误。
4、配置mysql的环境变量
此时我们在命令行输入mysql -uroot -p命令会提示没有commod not found,我们还需要将mysql加入系统环境变量。
(1)进入/usr/local/mysql/bin,查看此目录下是否有mysql
(2)执行vim ~/.bash_profile 在该文件中添加mysql/bin的目录
PATH=$PATH:/usr/local/mysql/bin
现在你就可以通过mysql -uroot -p登录mysql了,会让你输入密码,就是之前说到的mysql安装最后一步会弹出提示框里面的那个初始密码。
5、重置mysql的密码
登录成功后,你可以通过下面的命令修改密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
当看到
就表示重置密码成功,然后我们打开Sequel pro输入root账号和新密码时,就可以使用了。
6、卸载mysql
执行下列命令
- sudo rm /usr/local/mysql
- sudo rm -rf /usr/local/mysql*
- sudo rm -rf /Library/StartupItems/MySQLCOM
- sudo rm -rf /Library/PreferencePanes/My*
- rm -rf ~/Library/PreferencePanes/My*
- sudo rm -rf /Library/Receipts/mysql*
- sudo rm -rf /Library/Receipts/MySQL*
- sudo rm -rf /var/db/receipts/com.mysql.*