CentOS MySQL 調整

1、複製my-large.cnf文件到/etc/my.cnf cp /usr/share/doc/mysql-server-5.1.61/my-large.cnf /etc/my.cnf 2、打開my.cnf修改編碼 vi /etc/my.cnf

[client]

character-set-server = utf8

[mysql]

character-set-server = utf8

[mysqld]

init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

3、重啟MySQL服務 service mysqld restart 4、登錄mysql看看修改成功否 show variables like 'character%'; 5.更新密碼

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;