Tim at 19:04, 29 September 2007

Tim — Sat, 29 Sep 2007 19:04:28 GMT

←Older revision		Revision as of 19:04, 29 September 2007
Line 13:		Line 13:

	Like MySQL, PostgreSQL has its own user database, but passwords are not necessary for its ident authentication. <code>/usr/local/sbin/adduser.local</code> creates a new Postgres user for each new system user.		Like MySQL, PostgreSQL has its own user database, but passwords are not necessary for its ident authentication. <code>/usr/local/sbin/adduser.local</code> creates a new Postgres user for each new system user.
		+
		+	[[Category:Admin]]

Grant at 17:47, 15 March 2005

Grant — Tue, 15 Mar 2005 17:47:21 GMT

New page

== MySQL ==

To create a database called "foo" for the user "bar":
<ol>
<li><code>mysqladmin create foo</code></li>
<li>in mysql(1): <code>grant all on foo.* to bar@localhost identified by 'password'</code></li>
</ol>
You can get a password from pwgen(1). If the user already exists in the MySQL user database, you can omit the 'identified by' bit.

== PostgreSQL ==

The user can run <code>createdb foo</code> themselves. To create the database for them, use <code>sudo -u bar createdb foo</code>.

Like MySQL, PostgreSQL has its own user database, but passwords are not necessary for its ident authentication. <code>/usr/local/sbin/adduser.local</code> creates a new Postgres user for each new system user.

Database Creation - Revision history

Tim at 19:04, 29 September 2007

Grant at 17:47, 15 March 2005