当前位置:
  1. 魔豆IT网
  2. 系统教程
  3. 批量
  4. 正文

待执行的SQL文件(createuser.sql)–批量添加mysql账户的语句

grant all privileges on sq_hehe.* to hehe@localhost identified by “heiq”;

grant all privileges on sq_eili.* to eili@localhost identified by “eiglia”;

grant all privileges on sq_bob* to bob@localhost identified by “bo2esql”;

grant all privileges on sq_7car.* to 7car@localhost identified by “77sq”;

flush privileges;

执行createuser.sql文件中的语句:

mysql -u用户名 -p密码 -h主机地址(localhost) < createuser.sql

相关阅读

  • 暂无推荐

《》由网友“”推荐。

转载请注明: