ubuntu安装mysql

sudo apt-get install mysql-server

这一条命令就够了，然后：　mysql -u root -p

• 以下是旧版。

一下载：

wget http://mirrors.kernel.org/ubuntu/pool/universe/m/mecab/libmecab2_0.996-1.3_amd64.deb

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-server_5.7.18-1ubuntu16.10_amd64.deb-bundle.tar

二安装

2.1 安装libmecab2

dpkg -i libmecab2_0.996-1.3_amd64.deb

2.2 安装mysql（依次安装，版本视情况而定，方式为 dpkg -i xxx）

1. MySQL-common_5.7.10-1ubuntu14.04_amd64.deb
2. libmysqlclient20_5.7.10-1ubuntu14.04_amd64.deb
3. libmysqlclient-dev_5.7.10-1ubuntu14.04_amd64.deb
4. libmysqld-dev_5.7.10-1ubuntu14.04_amd64.deb
5. mysql-community-client_5.7.10-1ubuntu14.04_amd64.deb
6. mysql-client_5.7.10-1ubuntu14.04_amd64.deb
7. mysql-community-server_5.7.10-1ubuntu14.04_amd64.deb

三进入mysql

• service mysql start
• service mysql stop
• service mysql restart
• mysql -u root -p

四配置：

3.1 外网权限(方法一)

• select user,host from mysql.user;
• update user set host=’%’ where user=’root’;
• flush privileges;

3.2 外网权限(方法二)

• GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘pwd’ WITH GRANT OPTION;
• flush privileges;

3.3 注释掉绑定的本地

• vim /etc/mysql/mysql.conf.d/mysqld.cnf
• 注释掉 bind-address =127.0.0.1

五(额外的)

5.1 datetime可以设置为默认0000-00-00 00:00:00

• select @@sql_mode ## 查看
• SET GLOBAL sql_mode=’STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’ ## 修改