Author: admin

max_connections = 100

SHOW STATUS LIKE 'Max_used_connections'

SHOW STATUS LIKE 'Threads_connected';

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

1. etc\mysql\mysql.conf.d\mysqld.cnf -> [mysqld] -> add line:
   skip-grant-tables
2. systemctl restart mysql
3. run: mysql
4. mysql run: FLUSH PRIVILEGES;
5. create user 'root'@'localhost';
6. grant all on *.* to 'root'@'localhost'
7. update user set `plugin` = 'auth_socket' where `user` = 'root';
8. mysqld.cnf -> remove skip-grant-tables
9. systemctl restart mysql
10 run: mysql
11. mysql run: SELECT CURRENT_USER();



https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html#resetting-permissions-unix

1. mysqld.cnf
       bind-address = 0.0.0.0

2. mysql: 
       create user 'admin'@'%' identified by 'my-password';
       GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%';

3. if ufw exists ufw allow mysql (3306/tcp) https://www.youtube.com/watch?v=DjUD7_mJJPE