Ubuntu 14.04 下安装mysql 5.7.10

来源：互联网发布：淘宝促销手段有哪些编辑：程序博客网时间：2024/06/05 19:39

1、获取mysql-server_5.7.10-1ubuntu14.04_amd64.deb-bundle.tar

http://dev.mysql.com/downloads/mysql/

2、获取 libmecab2_0.996-1.1_amd64.deb

http://packages.ubuntu.com/zh-cn/trusty/amd64/libmecab2/download

3、安装 libmecab2_0.996-1.1_amd64.deb

dpkg -i libmecab2_0.996-1.1_amd64.deb

4、解压 mysql-server_5.7.10-1ubuntu14.04_amd64.deb-bundle.tar

tar -xvf mysql-server_5.7.10-1ubuntu14.04_amd64.deb-bundle.tar

5、安装mysql

dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb

-----------------------------------------------------------------------------------------------------------

以上操作在root用户下进行，安装完成后MYSQL是默认启动的

6、停止mysql

service mysql stop

7、启动mysql

service mysql start

-----------------------------------------------------------------------------------------------------------

QA：远程工具报10061错误

默认情况下MySQL不允许这些工具远程连接的，你可以找到/etc/mysql/my.cnf这个文件，将bind-address=127.0.0.1改为 bind-address=0.0.0.0 或将其注释掉

执行GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1qaz2wsx' WITH GRANT OPTION;

重启mysql即可。

-----------------------------------------------------------------------------------------------------------

设置数据库默认字符集：
vi /etc/mysql/my.cnf
增加：
[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8

0 0