【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了createauthdb.sql相关资料,希望对各位网友有所帮助!
create database auth;
use auth;
create table authorised_users ( name varchar(20),
password varchar(40),
primary key (name)
);
insert into authorised_users values ( 'username',
'pass
word' );
insert into authorised_users values ( 'testuser',
sha1('password') );
grant select on auth.*
to 'webauth'
identified by '
webauth';
flush privileges;