Topic: Add a new user to mysql

[Ian]

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

[chris meredith]

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.