Article | Rui Log

Convert a MySQL DB from latin1 to UTF8

2009-11-19

MySQL

I had a latin1 collated MySQL 4.1 db that contained both English and Japanese text. I dumped the data and then tried to migrate it into my new MySQL 5.0.26 installation. Of course being a bit lazy I did not take the time to check things out properly and was not surprised to find that all Japanese te ...

Leave a Reply

2004-10-06

MySQL

MySQL Change Password

在MySQL中修改一个用户（比如叫"hunte"）的密码，可以用如下3个办法：

>>>
#在控制台上输入
bash$ mysql -u root mysql
#用mysql客户程序
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user=\'hunte\';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
>
#在控制台上输入
bash$ mysql -u root mysql
mysql> ...

Categories

Convert a MySQL DB from latin1 to UTF8

修改MySQL中一个用户的密码