mac本机安装过mysql后，终端提示zsh: command not found: mysql 如何解决

1： vi ~/.bash_profile

# mysql
export PATH=$PATH:/usr/local/mysql/bin

2：保存

3：source ~/.bash_profile

4：msyql --version

　　

mysql -hyour_ip -P3306 -uroot -p 报错：ERROR 1130 (HY000): Host 'your_ip' is not allowed to connect to this MySQL server

解决：

mysql -u root -p

mysql> USE mysql;
mysql> select user,host from user;


mysql> CREATE USER 'root'@'yourip' IDENTIFIED BY 'your_password';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'yourip' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql -hip -P3306 -uroot -p

即可进入

 然后重启MySQL服务

 

 

完结...