Hi all! I've got quite a strange problem. Got to work today, was about to continue my work on a database, and tried to log in with user "varlehti", which is a user that's got SELECT, INSERT, UPDATE, and DELETE -privileges. I got an Access denied -error, and I'm sure I typed the password right. No, caps lock isn't on : ) I logged in with root, typed in my root-password and that worked fine. Used SELECT * FROM user; and lo and behold! The varlehti-users' privileges were gone!
host was %, user was varlehti, and everything else was "N". Tried to use GRANT SELECT,INSERT,UPDATE,DELETE ON database.* TO varlehti@'%' IDENTIFIED BY 'password' and FLUSH PRIVILEGES. Nothing happened. Tried to manually insert Y into the privilege columns. Got them there, still Access denied. So, I deleted the varlehti-user and tried to GRANT the privileges again. FLUSH PRIVILEGES. The user appeared in the user-table, but all privileges were N. Tried again with INSERT INTO. Got everything added, flushed privileges and tables and just about everything else. Access denied. Anyone got any idea what's causing this annoying little problem? And what's even more important, how come the privileges just disappeared? No one has got access to the database but me, and no one has got access to my computer, either. Ideas, anyone? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
