Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-15 Thread Nicolas Ross
> > >2. Grants aren't working. > > > > > >Almost for each db we have the grant I did is something like : > > > > > >grant all on db.* to 'user'@'%.domain.com' identified by 'password'; > > > > > >So, I end up with a user with no global privilege in the user table, and > a > > >entry in the db table

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
> >2. Grants aren't working. > > > >Almost for each db we have the grant I did is something like : > > > >grant all on db.* to 'user'@'%.domain.com' identified by 'password'; > > > >So, I end up with a user with no global privilege in the user table, and a > >entry in the db table with all privs. >

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Paul DuBois
At 11:30 -0400 10/14/03, Nicolas Ross wrote: Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower cas

MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are s