大树的博客

在 Ubuntu 14.04 下使用 MySQL 5.7.9

2015年10月22日

安装

 wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-common_5.7.9-1ubuntu14.04_amd64.deb
 wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client_5.7.9-1ubuntu14.04_amd64.deb
 wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server_5.7.9-1ubuntu14.04_amd64.deb
 wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-client_5.7.9-1ubuntu14.04_amd64.deb

 sudo apt-get install libaio-dev libmecab2
 sudo dpkg -i mysql-common_5.7.9-1ubuntu14.04_amd64.deb mysql-community-client_5.7.9-1ubuntu14.04_amd64.deb mysql-client_5.7.9-1ubuntu14.04_amd64.deb mysql-community-server_5.7.9-1ubuntu14.04_amd64.deb

配置

修改 /etc/mysql/my.cnf

[mysqld]
character_set_server=utf8 # 添加这行，设置数据库缺省字符集为 utf8

启动停止

sudo /etc/init.d/mysql start
sudo /etc/init.d/mysql stop
mysqladmin shutdown -uroot -ppwd