基于debian(ubuntu)的MySQL安装实录-vps环境搭建实录(四)

我们在前面已经安装好jdk,tomcat,nginx了，现在就差安装MYSQL了,过程如下

1.安装

root@ubuntu:/usr/mysql# apt-get install mysql-server

2.启动mysql后，以root登录mysql

mars@ubuntu:/etc/mysql$ mysql -u root –p

Enter password:

3.配置

mysql> show variables like 'character%'; #执行编码显示

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | latin1                     |

| character_set_connection | latin1                     |

| character_set_database   | latin1                     |

| character_set_filesystem | binary                     |

| character_set_results    | latin1                     |

| character_set_server     | latin1                     |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

修改 /etc/mysql/my.cnf 文件

mars@ubuntu:~$ sudo gedit /etc/mysql/my.cnf

找到客户端配置[client] 在下面添加

default-character-set=utf8 默认字符集为utf8

在找到[mysqld] 添加

default-character-set=utf8 默认字符集为utf8

init_connect='SET NAMES utf8' （设定连接mysql数据库时使用utf8编码，以让mysql数据库为utf8运行）

修改好后，重新启动mysql

mars@ubuntu:~$ sudo /etc/init.d/mysql stop

mars@ubuntu:~$ sudo /etc/init.d/mysql start

mars@ubuntu:/etc/mysql$ sudo /etc/init.d/mysql restart

再次查询一下字符集

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

4.测试

5.卸载

sudo apt-get autoremove --purge mysql-server-5.1

sudo apt-get remove mysql-server

sudo apt-get autoremove mysql-server

sudo apt-get remove mysql-common //这个很重要

本文链接：基于debian(ubuntu)的MySQL安装实录-vps环境搭建实录(四)，由领悟书生原创，转载请注明出处【http://www.656463.com/article/313】