Colin Shreffler wrote:
After installing MySQL on OS X, there don't appear to be any user accounts
created by default.
Does anyone know what user account to use or if there is a convention that I
should use when creating an Admin account?
Cheers
-c
After installation, you need to run mysql_install_db to set up the mysql
(administrative) db. If you used the pkg installer, this was done for you, but
otherwise you need to do it by hand. See the manual for details
<http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html>.
The default installation creates four intitial accounts. Two are for
admistrative access, [EMAIL PROTECTED] and [EMAIL PROTECTED] (your machine).
Initially, these have no password, so setting the password is the first order of
business. The other two accounts are the anonymous user accounts that allow
access to the test db by anyone, anywhere. Most people (everyone who cares
about security) delete the anonymous accounts as step two. Assigning a password
to the root users and deleting the anonymous users is described in the manual
<http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html>.
Once you've secured mysql, you can log in as the administrative user,
[EMAIL PROTECTED], to create any user accounts you need and assign them appropriate
privileges. See the manual for the details:
<http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html>
<http://dev.mysql.com/doc/refman/4.1/en/account-management-sql.html>
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
