mac mysql

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
After I’ve been searching alot I finally mananged it to delete MySQL from my Macbook pro.

The steps:

First you need to edit the file in: /etc/hostconfig and remove the line


Since this is a system file I advise you to open it with nano in terminal:

引用

Open Terminal
sudo nano /etc/hostconfig
Enter your password if you’re not authed yet.
Delete the following line: “MYSQLCOM=-YES-”
CTRL+X (This is the command for closing NANO, Enter the “Y” key to save the file and exit nano).
Second step:

Make sure MySQL is not running.

Open Terminal and copy and paste and run the following commands:
引用

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm /etc/my.cnf

MySQL is now removed from your MAC.

 

1)查看mysql 历史操作纪录 ~/.mysql_history

 

 

2)#login mysql

mysql -uroot

#show all database

show databases;

#login system user database

use mysql
1.添加用户
GRANT ALL PRIVILEGES ON *.* TO 'build'@'localhost' IDENTIFIED BY 'build' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'build'@'%' IDENTIFIED BY 'build' WITH GRANT OPTION;

2.删除用户 ：
   mysql>delete from mysql.user where user ='website' ;
   mysql>flush privileges; (刷新系统权限表)
3.修改密码

set password for build@localhost = password('build');

 

3)OS X 系统安装的mysql默认是不用my.cnf配置文件的，仅是使用默认的数据库配置值。

如要进行数据库定制，可到'/usr/local/mysql/support-files/'文件夹底下，把里面的任一个.cnf配置文件复制到/etc/目录底下并修改文件名称为my.cnf。

 

不过MAC OS X 系统的mysql确实不需要my.cnf来进行配置就已经足够可以使你满意运行了。

 

参考：http://forums.mysql.com/read.php?11,366143,376017#msg-376017