MySQL мережа
забезпечимо мережеве підключення mysql
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
[mysql]
дефолт
bind-address = 0.0.0.0
mysqlx-bind-address = 0.0.0.0
замінити
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
sudo systemctl restart mysql
юзери
SELECT user FROM mysql.user;
SELECT user,host FROM mysql.user;
відмінити права
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'spa'@'192.168.88.151';
дропнути юзера
DROP USER 'spa'@'192.168.88.151';
від рута
CREATE USER 'spa'@'192.168.88.151' IDENTIFIED BY '123';
GRANT ALL ON base2.* TO 'spa'@'192.168.88.151';
SHOW GRANTS FOR 'spa'@'192.168.88.151';
#перечитати привілеї
FLUSH PRIVILEGES;
USE base2;
SELECT * FROM Customers;
mysql -u spa -p -h 192.168.88.143
*** 0
SHOW SCHEMAS;
USE base2;
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (111,'ir2a','H21triv','7688889678');
SELECT * FROM Customers;
*** 1
CREATE DATABASE base3;
USE base3;
CREATE TABLE Customers
(
Id INT PRIMARY KEY AUTO_INCREMENT,
Age INT,
FirstName VARCHAR(20) NOT NULL,
LastName VARCHAR(20) NOT NULL,
Phone VARCHAR(20) NOT NULL UNIQUE
);
CREATE TABLE Orders
(
Id INT PRIMARY KEY AUTO_INCREMENT,
CustomerId INT,
CreatedAt Date,
FOREIGN KEY (CustomerId) REFERENCES Customers (Id)
);
SHOW GRANTS FOR 'spa'@'192.168.88.151';
Watch video MySQL мережа online without registration, duration hours minute second in high quality. This video was added by user spa it 31 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 123 once and liked it 7 people.