在数据库层面的安全性也尤为重要,但是往往很多人忽略了相关的设置,这里以MySQL为例
指定IP与用户访问数据库指令:
create user 'user'@'192.168.1.100' identified by '******';
create database tdb;
grant all privileges on tdb.* to 'user'@'192.168.1.100' with grant option;
或者一条指令搞定
GRANT ALL PRIVILEGES ON tdb.* TO 'user'@'192.168.1.100' IDENTIFIED BY '123456' WITH GRANT OPTION ;