new-user.sql

来自「我的图书馆或资料库」· SQL 代码 · 共 32 行

# new-user.sql - an SQL statment to GRANT access to a database
#
# Change:
#
#  dddd - the name of your database
#  uuuu - the name of the user accessing dddd
#  hhhh - the host uuuu is coming from
#  pppp - the password of uuuu
#
# For example:
#
#  GRANT SELECT, INSERT, UPDATE, DELETE
#  ON mylibrary.*
#  TO mylibrary@localhost
#  IDENTIFIED BY 'suprsecrit';
#
# Usage:
#  
#  mysql -uroot -p mysql < new-user.sql
#
# Eric Lease Morgan <[e-mail]>
# University Libraries of Notre Dame
#
# 08/22/02 - changed signature, that's all
# 12/11/00 - first cut
#
#
GRANT SELECT, INSERT, UPDATE, DELETE
ON dddd.*
TO uuuu@hhhh
IDENTIFIED BY 'pppp';