Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Ian on July 08, 2002, 05:04:32 PM

Title: Add a new user to mysql
Post by: Ian on July 08, 2002, 05:04:32 PM

I would like to add a new user with thier own password to be a datebase admin of a new database.  How can I create a new database user with admin rights.  Also I did do a search and could not find anything on this.  I have the new sme 5.5

Title: Re: Add a new user to mysql
Post by: chris meredith on July 08, 2002, 07:39:09 PM

These forums here are a great resource, but you might also consider expanding your search.

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management

Basically you want to fire up mysql "CREATE" the database "USE" the database and "GRANT" the privileges you need.

You could also get another tool to make administration easier like Webmin or PHPMysqladmin or something similar.