Linux下安装MySQL

1、从oracle官网下载mysql安装包

mysql-server_5.7.18-1ubuntu16.04_amd64.deb-bundle.tar

2、解压缩安装包

tar -xf mysql-server_5.7.18-1ubuntu16.04_amd64.deb-bundle.tar

3、安装MySQL

sudo apt-get install libaio1 libmecab2 libjson_perl
sudo dpkg -i mysql-common_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient18_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-client_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-server_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-server_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-bench_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-source_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-test_5.6.34-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-testsuite_5.6.34-1ubuntu14.04_amd64.deb

4、启动和退出MySQL

/etc/init.d/mysql start
/etc/init.d/mysql stop

5、MySQL简单操作

// 检查是否安装成功
sudo netstat -tap | grep mysql
// 登陆mysql数据库
mysql -u root -p
// 查看当前的数据库
show databases;
// 显示当前数据库的表单
show tables;
// 编译代码的时候需要链接mysql的库，可以通过如下方式编译
g++ -Wall mysql_test.cpp -o mysql_test -lmsqlclient