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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]