1.在官网下载安装包 : http://www.mysql.com/downloads/ 进入, 点击下方的DOWNLOADS : MySQL Community Server
2.安装完成后添加环境变量:
vim ~/.bash_profile
加入
PATH=$PATH:/usr/local/mysql/bin
并保存(vim 中先按 Esc键,在输入 :wq )
在命令行输入
source ~/.bash_profile
路径就配置好了。
其中执行vim ~/.bash_profile时报错,通过rm -f ~/.bash_profile.swp解决
3.登陆mysql:
mysql -u root -p
遇报错:Access denied for user ‘root‘@‘localhost‘ (using password: YES)
解决方案:mac 环境下 登陆失败问题Access denied for user ‘root‘@‘localhost‘ (using password: YES)_早安试言的博客-CSDN博客
4.MYSQL常用操作
sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart
sudo /usr/local/mysql/support-files/mysql.server status
遇到的其他问题:
1.停止mysql服务:sudo /usr/local/mysql/support-files/mysql.server stop
报错:ERROR! MySQL server PID file could not be found!
解决:ps -ef|grep mysqld 使用kill -9杀掉对应的mysql进程
2.此时报错:kill: kill 27114 failed: operation not permitted
解决:切换root用户:
输入命令:sudo su
输入密码
输入命令 su - root即可
切换用户之后,再重新kill解决
3.使用navicat连接本地数据库时报错:1045 - Access denied for user 'root'@'localhost' (using password: YES)
解决:勾选使用socket