3 messages in com.mysql.lists.mysqlRe: database permission
FromSent OnAttachments
ketvin10 Nov 2003 00:37 
Thierno Cissé10 Nov 2003 01:06 
David T-G10 Nov 2003 02:27 
Subject:Re: database permission
From:Thierno Cissé (thie@sentoo.sn)
Date:11/10/2003 01:06:22 AM
List:com.mysql.lists.mysql

Hi Ketvin,

after you created your database kelvin_db for example, you can set a account to use this database in this manner : GRANT ALL PRIVILEGES ON user_name.* TO @localhost identified by 'password_for_user'; GRANT ALL PRIVILEGES ON user_name.* TO @"%" identified by 'password_for_user';

Are useful basic information in the MySQL documentation. Read this once at least.

Regards Thierno6C - MySQL 4.0.15

----- Original Message ----- From: "ketvin" <ket@silicon.com.my> To: <mys@lists.mysql.com> Sent: Monday, November 10, 2003 8:37 AM Subject: database permission

Dear lists,

How do I assign user and password to a database that i just created ?

Thanks