MySQL

MySQL – Setting

php locate : /private/etc/php.ini
my.cnf : /etc/my.cnf
mysql socket : /tmp/mysql.sock
helper link
mysql helper link
mac lion webserver :
uninstall mysql on mac

This was a life saver!
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*

setting root password

#mysql -uroot -p
mysql> use mysql
Database changed
mysql>update user set password=password('new_password') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0
mysql>flush privileges;
Query OK, 0 rows affected (0.00 sec)

댓글 남기기

이메일은 공개되지 않습니다. 필수 입력창은 * 로 표시되어 있습니다

Back To Top