create_script

来自「用于squid mysql 验证的软件 这样squid的帐户就可以放到mysq」· 代码 · 共 18 行

DROP DATABASE IF EXISTS mysql_auth;

USE mysql;
DELETE FROM user WHERE User LIKE 'squid';
DELETE FROM db WHERE User LIKE 'squid';
DELETE FROM tables_priv WHERE User LIKE 'squid';

CREATE DATABASE mysql_auth;

USE mysql_auth;

CREATE TABLE data 
	(user VARCHAR(16) NOT NULL PRIMARY KEY,
	 password VARCHAR(64) BINARY NOT NULL);

GRANT SELECT,INSERT,UPDATE,DELETE ON mysql_auth.data TO squid@localhost IDENTIFIED BY 'squid';