OSX mysql 操作

来源:互联网 发布:趣丸网络科技 知乎 编辑:程序博客网 时间:2024/05/18 02:28
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop


sudo mysqld_safe --skip-grant-tables &




# mysql
mysql> use mysql;
mysql> UPDATE user SET password=password("test123") WHERE user='root';   
mysql> flush privileges;
mysql> exit;     


sudo /Library/StartupItems/MySQLCOM/MySQLCOM retart




如果出现ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
则可以
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo mysqld_safe --skip-grant-tables
0 0
原创粉丝点击