thanks tim, i'll give it a try. i have to say, i'm a little disheartened with mysql. i just want it to "work" and be secure.
from reading the docs, it _appears_ (although it doesn't say explicitly) that not only does each username have a password, each user has a password for each hostname. so 'root'@'localhost' may have a different password than 'root'@'someotherhost'. that's just too bizarre for my mind. it also looks like a database name of "mysql" may refer to the collection of all databases, but i haven't verified that yet. plus having anonymous users... really, anonymous. as in, so anonymous that they don't even have a username, is a really strange concept. even anonymous ftp users have a username of "anonymous". i wanted to set up a slashcode system, but i may just put that off till i have more time to sit down and read mysql docs. the more i learn about mysql, the more i'm starting to realize there's no possible quickstart... :( i'll give it a few more hours before i put it off as a "major undertaking" to be attempted when i have less on my plate than i do now. i'll try your suggestions. thanks! pete On Mon 15 Mar 04, 9:01 AM, Tim Riley <[EMAIL PROTECTED]> said: > On Mon, 2004-03-15 at 04:58, Peter Jay Salzman wrote: > > i see how to create new mysql users and new mysql databases, but how > > does one print all mysql users on a given host? > Did you try "select * from user"? It's just a guess because the book > says the table exists, but it doesn't appear in my instance. (Maybe > because I've never issued the "grant" command.) > > > is there something like > > an /etc/shadoow for mysql? > > > > how does one print the name of all mysql databases on a given host? > "show databases" > > > > > pete > > _______________________________________________ > > vox-tech mailing list > > [EMAIL PROTECTED] > > http://lists.lugod.org/mailman/listinfo/vox-tech > > _______________________________________________ > vox-tech mailing list > [EMAIL PROTECTED] > http://lists.lugod.org/mailman/listinfo/vox-tech -- Make everything as simple as possible, but no simpler. -- Albert Einstein GPG Instructions: http://www.dirac.org/linux/gpg GPG Fingerprint: B9F1 6CF3 47C4 7CD8 D33E 70A9 A3B9 1945 67EA 951D _______________________________________________ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
