摘要： UTF8: mysql> CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;GBK:mysql> create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; 阅读全文

摘要： # /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';mysql> FLUSH PRIVILEGES;mysql> quit# /etc/init.d/mysqld restart# mysql -uroot -pnewpas 阅读全文