Kiterminal's Blog

$ mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset database_name > database_latin1.sql

$ sed -e 's/latin1/utf8/g' database_latin1.sql > database_utf8.sql

$ mysql --user=username --password=password --execute="DROP DATABASE database_name;"
$ mysql --user=username --password=password --execute="CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;"

sudo apt-get install apache2

gksu gedit /etc/apache2/conf.d/fqdn

$ mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 146 to server version: 5.0.26-standard
 
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> SET PASSWORD FOR root@localhost=PASSWORD(’newpassword’);
Query OK, 0 rows affected (0.06 sec)
mysql>