You did use
flush privileges;
after inserting the new users? elsewise mysql won't recognize them until a
restart.
----- Original Message -----
From: "Michael Fischer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001-02-18 7:55 AM
Subject: Unable to designate host
>
> Ok, I looked through the archive, unsuccessfully.
>
> Here's the "problem":
>
> I rebuilt a machine running a MySQL db, and stupidly
> only backed up the user-oriented databases, and not
> the mysql administrative ones. Nonetheless, I went
> back in and used the guiclient to do the appropriate
> grants. After frustration, I removed those rows,
> and repeated on the command line the exact statement
> I had used to get the original up and running:
>
> GRANT select, insert, update, delete
> ON dbname.*
> TO nonrootuser@'%'
> IDENTIFIED BY 'password';
>
> Now I discover that no matter how I set the hostnames
> in the mysql db tables, ( hostname, hostname.domain.tld,
> or "%" ) only root@localhost works. Hrmf!
>
> This becomes a real pain when the client app is on a
> different machine, of course....
>
> Running SuSE 7.0
>
> Can I trust that the value returned by the 'hostname'
> command is what I want for the value of the host columns
> in the mysql db? If so, what might I have done wrong?
>
> Suggestions?
>
> TIA.
>
> Michael Fischer
> --
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> 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
