MySQL increase connections and InnoDB memory

show variables like 'max_connections';
(default 151)

show variables like 'innodb_buffer_pool_size';
(default 134217728 bytes (128MB))

for permanent :

sudo vi /etc/systemd/system/multi-user.target.wants/mysql.service
LimitNOFILE=infinity
LimitMEMLOCK=infinity

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
max_connections=1000
innodb_buffer_pool_size=2G

sudo systemctl daemon-reload
sudo service mysql restart