-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rick --
...and then Richard Nagle said... % ... % [MacG4a:/usr] rnagle% mysql -u root -p % Enter password: % Welcome to the MySQL monitor. Commands end with ; or \g. ... % % Well it would appear that I finally have a connection Yay! :-) % % q. since I am root, do I still need to GRANT a database to myself? % or just a to a new user. aka: bob@localhost I (and some others) strongly advise not using the root account for your general work but instead creating less-powerful accounts to minimize the probability of torching yourself with a typo. You might, for a database called "music", create a "musicroot" account that has full privileges for that database and a "musicrick" account that has normal privileges for that database; that way you don't need to worry about musicrick running around in your "movies" database and you needn't worry about musicroot accidentally deleting your "recipes" database. If you do everything as root, you not only won't be practiced handling DB privileges to better know what you want to give someone on a database that actually matters but you're also walking around with a loaded and cocked gun with the safety off and your finger on the trigger. Don't stumble :-) % % TKS % Rick HTH & HAND & Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+FHI8Gb7uCXufRwARAkBmAJ4j2z2u42cAzi0Zl25xRciz/zYW1QCfXzmt lmiCMvU+KwbNJkKDiNUPDYE= =mskg -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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