ERROR 1042 (
使用链接表的额外特性尚未
7月24
记一下，原来和linux下的解决方法不一样。
搞定！
# killall -TERM mysqld //先杀死所有的mysql进程
# /usr/local/bin/mysqld_safe --skip-grant-tables &
会返回# /usr/local/bin/mysqld_safe --skip-grant-tables &
100723 22:19:53 mysqld_safe Logging to '/var/db/mysql/FreeBSD.err'.
100723 22:19:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
100723 22:19:53 mysqld_safe mysqld from pid file /var/db/mysql/FreeBSD.pid ended
[1]Done mysqld_safe -skip-grant-tables
如果出现这信息就成功一半了。100723 22:19:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
100723 22:19:53 mysqld_safe mysqld from pid file /var/db/mysql/FreeBSD.pid ended
[1]Done mysqld_safe -skip-grant-tables
# mysql -uroot
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD('密码') where user='root'
Query OK, 0 rows affected (0.00 sec) Rows matched: 4 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD('密码') where user='root'
Query OK, 0 rows affected (0.00 sec) Rows matched: 4 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
搞定！
