Ubuntu Gnome 14.10 installation using MySQL

Install MySQL directly using sudo apt-get install MySQL, set the root password, use the Mysql-uname-ppassword login Execute SQL statement command using Mysql-uname-ppassword- Ddatabasename<filepath

Save the execution result of the SQL statement Mysql-uname-ppassword-ddatabasename<filepath>filepath

Change the MySQL code to utf-8, modify the file/etc/mysql/my.cnf

[Mysqld]
Default-character-set=utf8
Default-storage-engine=innodb

[MySQL]
Default-character-set=utf8

Restart MySQL server command sudo/etc/init.d/mysql restart

View Code show variables like ' character% ';

Ubuntu Gnome 14.10 installation using MySQL