ubuntu - mysql

restart apache： /etc/init.d/apache2 restart
restart mysql： /etc/init.d/mysql restar

grant all privileges on mytest.* to 'username'@'%' identified by 'password'

 

[client]
default-character-set=utf8

[mysqld]
default-character-set=utf8
init_connect='SET NAMES utf8'

show variables like 'character%'