Unbuntu MySQL installation and simple configuration

Ubuntu build MySQL Reference http://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html
1. sudo apt-get install Mysql-server\
You need to make the root password password.
2. vi/etc/mysql/my.cnf
Comment out binding-address=127.0.0.1
3. If you need to configure MySQL on the server side, install Mysql-client
Mysql-u Root P
4. If you need to connect to the database server remotely, you need to turn on permissions (default is not remote connection: Navicat 1130 error)
Mysql> Grant all privileges on * * to [email protected] '% ' identified by ' password ' with GRANT option; (Any host can)
Grant all privileges on * * to [email protected] ' 192.168.1.3 ' identified by ' password ' with GRANT option; Flush privileges (designated host)

Note that the user table in the MySQL library records the connection information
5. Modify character Set (note garbled problem http://www.2cto.com/database/201108/101151.html)
View current encoding: Show variables like ' character% ';
Modify MY.CNF, add Default-character-set=utf8 under [client]
Create database ' sb ' character et ' UTF8 '

Unbuntu MySQL installation and simple configuration