Hey guys, We're having a weird authentication problem. We have a .jsp (on box1) that tries to connect to a MySQL database (on box2). The privileges have been set to give insert, update, delete to the user.
GRANT select, insert, update on d_name.* to d_user IDENTIFIED by "d_user"; It works fine one day and then the next morning it doesn't work. To hack around, we changed the .jsp to use the root user login (only in our development environment to find the error) and it worked, only to have it broken again the next morning! The only thing that runs overnight is a mysqldump script, which calls this command: mysqldump -u$USERNAME -p$PASSWORD --all-databases It seems like the privileges get messed up by mysqldump? We've also been doing a "flush privileges" after any change to the grant tables (db, user, host). to isolate the problem, we've removed all related d_user entries. The way it looks now is that the db table is empty, the host table has an entry so that box1 has access to the databases on box2, and user has an entry for root coming from localhost, box1, box2, and to be safe, '%'. does mysql get confused when there's an '%', and then also other entries in the host column of the user table for the same user? Any help would be great...it's been really frustrating. thanks, Don --------------------------------------------------------------------- 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
