ubuntu安装MySQL

参考博客：http://blog.youkuaiyun.com/irving512/article/details/53793671

1.     下载

https://dev.mysql.com/downloads/mysql/

下载合适版本的DEB Bundle

 

2.     解压

来到压缩文件放置的目录下，tar –xvf mysql-server_5.7.21-1ubuntu16.04_amd64.deb-bundle.tar

按照顺序执行(这一步真的心累)

dpkg –i mysql-common_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i libmysqlclient20_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i libmysqlclient-dev_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i libmysqld-dev_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i mysql-community-client_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i mysql-client_5.7.21-1ubuntu16.04_amd64.deb

apt-get install libmecab2（我安装好这个后跳出一个界面让我设置输入密码）

dpkg -imysql-community-server_5.7.21-1ubuntu16.04_amd64.deb

dpkg -imysql-server_5.7.21-1ubuntu16.04_amd64.deb

dpkg -imysql-community-source_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i mysql-community-test_5.7.21-1ubuntu16.04_amd64.deb

dpkg -i mysql-testsuite_5.7.21-1ubuntu16.04_amd64.deb

3.     运行

/etc/init.d/mysql start（停止：/etc/init.d/mysql stop）

mysql –uroot –p 然后输入之前设置的密码

 

最后截图为证：

 ps:远程连接MySQL数据库

1.     进入MySQL中

use mysql

再grant all privileges on *.* to 'root'@'%' with grantoption;或grant all privileges on *mydatabase* TO'myuser'@'myip' identified by 'mypassword' with grant option;

flush privileges;

exit;

2.     修改配置文件（版本在5.7及以上）

vi /etc/mysql/mysql.conf.d/mysqld.cnf

按i变成写模式，改成bind-address = 0.0.0.0，再按ESC进入命令行模式，shift + ;变成尾行模式，输入wq保存退出。

3.     重启MySQL

/etc/init.d/mysql restart

 

如果连接时报2003 can not connect to mysql serveron xxx (10060)

详情见：http://blog.youkuaiyun.com/f056917/article/details/78559625

我和他的问题是一样的，竟然被阿里云坑了。