Quoting Darrell May <[EMAIL PROTECTED]>:
> Dan I am happy to follow your expertise if you could provide more
Well, "expertise" is a bit of an exaggeration, but I'll do what I
can...
> database user information. It appears this user information is not
> included as part of the dump file.
No, it normally wouldn't be, as it's not part of the table/database
as such. The general syntax would be
GRANT ALL PRIVILEGES ON database.* TO someuser@localhost IDENTIFIED
BY 'somepassword';
This gives that user all privileges on the specified database. It'd
probably be more secure to determine exactly which privileges are needed
and just grant them, e.g.:
GRANT SELECT, INSERT, UPDATE, DELETE ON ...
I don't know most of them, but they're detailed in the MySQL docs.
This line could go at the beginning or end of the dump. I don't know a
way of automatically dumping the information from an existing setup, but
is that necessary? I guess it would depend on what exactly you're trying
to do.
--
Dan Brown, KE6MKS, [EMAIL PROTECTED]
"Since all the world is but a story, it were well for thee to buy the
more enduring story rather than the story that is less enduring."
-- The Judgment of St. Colum Cille
--
Please report bugs to [EMAIL PROTECTED]
Please mail [EMAIL PROTECTED] (only) to discuss security issues
Support for registered customers and partners to [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Archives by mail and http://www.mail-archive.com/devinfo%40lists.e-smith.org
