一、创建用户 mysql -u root -p create user 'test'@'localhost' identified by '123'; create user 'test'@'192.168.7.22' identified by '123'; create user 'test'@'%' identified by '123'; 注意:此处的”local
MySQL数据库在导入大sql文件过大时,会出现”MySQL server has gone away”问题,是因为mysql默认的”max_allowed_packet”变量值过小。 查看目前配置 show VARIABLES like '%max_allowed_packet%'; 显示的结果为: +----------------