ubuntu16.04 安装 mysql

转：https://www.linuxidc.com/Linux/2017-06/144805.htm

安装mysql：sudo apt-get install mysql-server

root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# sudo apt-get install mysql-server  
Reading package lists... Done  
Building dependency tree         
Reading state information... Done  
E: Unable to locate package mysql-server  
root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# sudo apt-get update  
root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# sudo apt-get upgrade  
root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# sudo apt-get install mysql-server  

设置mysql允许远程访问，编辑文件/etc/mysql/mysql.conf.d/mysqld.cnf
添加注释，找到bind-address = 127.0.0.1，在行首添加#号
#bind-address = 127.0.0.1
删除注释(mysql连接数，默认100肯定不够用，设置多少看你的，我设2000)
max_connections = 2000
保存文件退出(ctrl+s)
连接mysql：mysql -uroot -p密码
授权：grant all on *.* to root@'%' identified by '密码' with grant option;
刷新：flush privileges;
退出mysql：quit
重启mysql：service mysql restart

root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# mysql -uroot -p密码  
mysql: [Warning] Using a password on the command line interface can be insecure.  
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 8  
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)  
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.  
mysql> grant all on *.* to root@'%' identified by '密码' with grant option;  
Query OK, 0 rows affected, 1 warning (0.00 sec)  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)  
mysql> quit  
Bye  
root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install# service mysql restart  
root@iZuf6bqngpatbwsnfpfpoqZ:/usr/lib/install#  

现在在Windows下可以使用navicat远程连接Ubuntu下的MySQL服务

登录mysql查看mysql连接数：show variables like '%max_connections%';
如果mysql连接数设置失效往下看：
打开文件：/lib/systemd/system/mysql.service
在最后一行添加代码：
LimitNOFILE=65535
LimitNPROC=65535

然后执行命令：
systemctl daemon-reload

service mysql restart
再次查看mysql链接数，修改成功