1、筆者測試環境為：
2、配置mysql root密碼為123456：
# /usr/bin/mysqladmin -u root password '123456'
# /usr/bin/mysqladmin -u root -h localhost.localdomain password '123456'
3、配置資料庫遠端通路權限：
# mysql -uroot -p123456$i -e "grant all privileges on *.* to [email protected] identified by '123456' with grant option;"
# mysql -uroot -p123456$i -e "grant all privileges on *.* to root@'%' identified by '123456' with grant option;"
# mysql -uroot -p123456$i -e "FLUSH PRIVILEGES;"
4、建立并導入資料庫guarantee.sql，編碼格式為utf8：
# mysql -uroot -p123456$i -e "create database guarantee CHARACTER SET utf8;"
# mysql -uroot -p123456$i -e "ALTER DATABASE guarantee DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
# mysql -uroot -p123456 guarantee -e "source /root/guarantee.sql;"
# mysql -uroot -p123456$i -e "FLUSH PRIVILEGES;"
# service mysqld restart
5、上面設定的utf8筆者試的時候可能顯示到web的資料庫還是亂碼，發現并沒有改成utf8格式，筆者将/etc/my.cnf配置檔案也改了一下，my.cnf配置如下：
#service mysqld restart //重新開機生效