转:https://www.linuxidc.com/Linux/2017-06/144805.htm
安装mysql:sudo apt-get install mysql-serverroot@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链接数,修改成功