文章列表

• 计科知识库 9天前
  mysql 5.1创建用户并授权

  mysql 5.1创建用户、数据库、并授权 1. 建起数据库 create database csbloggerdb;2.建用户、授权 CREATE USER 'csblogger'@'localhost' IDENTIFIED BY '111111111';CREATE USER 'csblogger'@'%' IDENTIFIED BY '111111111';CREATE USER 'csblogger'@'127.0.0.1' IDENTIFIED BY '111111111';GRANT CREATE, SELECT, INSERT, UPDATE ON csbloggerdb.* TO 'csblogger'@'localhost';GRANT CREATE, SELECT, INSERT, UPDATE ON csbloggerdb.* TO 'csblogger'@'127