Same for version 3.23.58. On Monday 01 of March 2004 13:47, Bostjan Skufca (at) domenca.com wrote: > 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
-- Z lepimi pozdravi, Bostjan Skufca sistemski administrator Domenca d.o.o. Tel: +386 4 5835444 Fax: +386 4 5831999 http://www.domenca.si -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
