StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>From <a href="http://dev.mysql.com/doc/refman/4.1/en/user-names.html" rel="nofollow">the manual</a>:</p> <blockquote> <p>When you install MySQL, the grant tables are populated with an initial set of accounts. The names and access privileges for these accounts are described in Section 2.10.3, “Securing the Initial MySQL Accounts”, which also discusses how to assign passwords to them.</p> </blockquote> <p><a href="http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html" rel="nofollow">And:</a></p> <blockquote> <p>Some accounts have the user name root. These are superuser accounts that have all privileges and can do anything. The initial root account passwords are empty, so anyone can connect to the MySQL server as root without a password and be granted all privileges.</p> <p>On Unix, each root account permits connections from the local host. <strong>Connections can be made by specifying a host name of localhost or the actual host name or IP address.</strong></p> </blockquote> <p>However, I can't find any rationale for this. There's nothing elsewhere in the manual that suggests that this is <em>required</em> for any particular reason, but presumably it's to cover all the bases for <a href="http://dev.mysql.com/doc/refman/4.1/en/request-access.html" rel="nofollow">request verification</a>. There may be some instances where one originating local connection uses one account whilst others require use alternatives; I guess it was decided that ensuring local root access will <em>always</em> work, no matter what the edge case, was a good thing.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload