For security reasons, I don't want to run mysql as root of the OS. However, the only way I can run mysql is if I log into the server as root. So I guess I have to create another superuser with: GRANT ALL ON *.* TO lgaal@localhost IDENTIFIED BY 'whocares' WITH GRANT OPTIONS; Is this correct? and afterwards should I revoke root@localhost? Next item is why when I'm logged in as myself can I access 'mysql' without using a password and why do I have access to all of the databases except for mysql? tx.... --------------------------------------------------------------------- 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
