RE: [cobalt-users] MySQL Password

["Andy Jacobs" <andy@xxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Robert
> Fitzpatrick
> Sent: 18 July 2003 13:52
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: RE: [cobalt-users] MySQL Password
>
>
> > Thanks for that.  I'm a bit confused now. I set up a quick
> > connection to test this and I put cobalt-mysql for the
> > password and it all works.  The BIG problem at the moment is
> > that I have 2 sites running where I have had to use the root
> > user and defaul password to get their sites going again.
> >
> Did you assign the users of these sites databases privileges to access
> their databases?

This is what I did using phpMyAdmin:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on
bluewidgets.* TO clientusername@localhost IDENTIFIED by
"clientusernamepassword";

I have always done this with no problems.  However, installing the latest
version of phpMyAdmin means that I have to wrap clientusername@localhost
with "".  Anyway, I run that and it works with no errors.  If I then try to
connect to the bluewidgets database using the info above I just get a
connect error.

I think what I really need to do is run these commands from the mysqladmin
prompt instead of from phpMyAdmin and see what happens then.  The trouble
is, I can't seem to get into mysqladmin either :o(

>
> > If it had no password and I entered one anyway, would it just
> > ignore it?
> >
> Don't set anything up without a password, especially if you have
> different user databases. Someone could find out a user name and that's
> all they need.
>
> You need to create the user with passwords and with no privileges and
> then add the user and database with the appropriate privileges in the
> 'db' table of the 'mysql' database.

Hmm... That's interesting.  Didn't know abot that but it might have
highlighted a setup problem with phpMyAdmin.  When I look at these entries
it just shows % in the host column.

Maybe a bit more digging required on my part!

Andy
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003