mariadb all host connect

;;;;;;;;;;           https://youtu.be/mdzbR_hdTIw     ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-2 (2023-07-27) x86_64 GNU/Linux;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;Это Debian 12, кодовое имя bookworm, образ для сетевой установки для архитектуры 64-битный ПК (amd64) debian-12.1.0-amd64-netinst.iso;;;;

Обновляем систему
apt update -y
apt upgrade -y

Устанавливаем sql server mariadb
apt install -y mariadb-server mc

Настройка sql server*a
mysql_secure_installation
на root ставим этот пароль
kamailiorw

Открываем доступ к sql серверу
mcedit /etc/mysql/mariadb.conf.d/50-server.cnf
bind-address            = 0.0.0.0

systemctl restart mariadb

Даем доступ к логину root из любой подсети %
mariadb

CREATE USER 'kamailiorw'@'%' IDENTIFIED BY 'kamailiorw';
GRANT ALL PRIVILEGES ON *.* TO 'kamailiorw'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;


проверяем доступ от компа с kamailio
mysql -h 10.20.1.114 -uroot -p
kamailiorw


SHOW DATABASES;
SHOW TABLE STATUS FROM `kamailio`;


DBENGINE=MYSQL
DBHOST=10.20.7.116
DBPORT=3306
DBNAME=kamailio
DBRWPW="kamailiorw"
DBROUSER="kamailioro"
DBROPW="kamailioro"
DBROOTUSER="root"
CHARSET="latin1"




SELECT User, Host FROM mysql.user;

SHOW GRANTS FOR kamailio@localhost;
SHOW GRANTS FOR 'kamailioro'@'%';


GRANT USAGE ON *.* TO `kamailioro`@`%` IDENTIFIED BY PASSWORD 'kamailioro';

GRANT SELECT ON `kamailio`.* TO `kamailioro`@`%`;






SELECT User FROM mysql.user;
SELECT * FROM mysql.user WHERE User = 'kamailio';
SELECT * FROM mysql.user WHERE User = 'kamailioro';
SELECT * FROM mysql.user WHERE User = 'kamailiorw';



ALTER USER 'kamailio'@'localhost' IDENTIFIED BY 'kamailio' HOST '10.20.7%';

CREATE USER 'kamailio'@'ip_address' IDENTIFIED BY 'new_password';

SHOW DATABASES;
USE kamailio
DESCRIBE carrierroute;
SHOW COLUMNS FROM carrierroute;

SHOW TABLE STATUS FROM `kamailio`;

+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| id             | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| carrier        | int(10) unsigned | NO   |     | 0       |                |
| domain         | int(10) unsigned | NO   |     | 0       |                |
| scan_prefix    | varchar(64)      | NO   |     |         |                |
| flags          | int(11) unsigned | NO   |     | 0       |                |
| mask           | int(11) unsigned | NO   |     | 0       |                |
| prob           | float            | NO   |     | 0       |                |
| strip          | int(11) unsigned | NO   |     | 0       |                |
| rewrite_host   | varchar(255)     | NO   |     |         |                |
| rewrite_prefix | varchar(64)      | NO   |     |         |                |
| rewrite_suffix | varchar(64)      | NO   |     |         |                |
| description    | varchar(255)     | YES  |     | NULL    |                |


INSERT INTO carrierroute (id, carrier, domain, scan_prefix, flags, mask, prob, strip, rewrite_host, rewrite_prefix, rewrite_suffix, description) VALUES
(1, ,,,,,,,,,,,);


use openser;
INSERT INTO carrier_name (carrier) VALUES ("default");
INSERT INTO domain_name (domain) VALUES ("default");
INSERT INTO carrierroute (carrier,domain,scan_prefix,flags,mask,prob,strip,rewrite_host,rewrite_prefix,rewrite_suffix,description) VALUES("1","1","1000","0","0","1","0","PEER-01","","","FRANCE");
exit