Hello I am using MySQL 4.0.18 and i have come accross weird behaviour.
I created the databas and user like this: CREATE DATABASE dev_project; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES ON dev_project.* TO [EMAIL PROTECTED] IDENTIFIED BY "somepass"; FLUSH PRIVILEGES; So, user has all privileges set in mysql.db table (except Grant_priv) an absolutely none set in mysql.user table. So far so good. BUT: when i log into mysql as that fresh user I cat do CREATE DATABASE `dev?project`; CREATE DATABASE `dev-project`; CREATE DATABASE `devaproject`; CREATE DATABASE `devbproject`; CREATE DATABASE `devcproject`; etc... AND! USE devaproject; AND!! CREATE TABLE test (id int not null); INSERT INTO test SET id=1; SELECT * FROM test; +----+ | id | +----+ | 1 | +----+ 1 row in set (0.00 sec) Now am I missing something - is this by design? or it is a bug in MySQL grant system? Best regards, Bostjan Skufca system administrator Domenca d.o.o. Phone: +386 4 5835444 Fax: +386 4 5831999 http://www.domenca.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
