Well, I know how to do it manually, but it is annoying compared to using an interface like phpMyAdmin.
But it begs the question as to why adding people to the mysql tables worked fine one day, and not the next. I've restarted/reloaded mysql, restarted my server, looked at permission, etc. Since I didn't mention this earlier, I should also mention that I am on a linux box (Cobalt RAQ4). Thanks, -Mike > -----Original Message----- > From: Petre Agenbag [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 2:48 PM > To: Mike At Spy > Subject: Re: Weird MySQL thing > > > Yes, I'd also like to see the exact way to manually add users etc, > specially to allow specific users access to specific tables from > specific host. > The best way I found to do this ( and the only one that works for me), > is to use the mysql_setpermission executable. It's a menu driven util > allowing you to do this amongst other things. Only thing is, you need to > have perl DBI, MsSql-MySQL and Data Dumper installed to use it ( all are > on the download page on mysql.com) > > Mike At Spy wrote: > > >I am having some trouble with MySQL. Seems I cannot add users. > Well, I can > >add them (through phpMyAdmin, but they are still not able to get into the > >datasbases. I flushed the tables, too. > > > >Current users are not affected. > > > >This started, rather suddenly, the day after I was able to do this. > > > >Anyone have any ideas? > > > >Thanks, > > > >-Mike > > > > > > > > > >--------------------------------------------------------------------- > >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 > > > > --------------------------------------------------------------------- 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
