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
