From Wsms

MySQL Database Manager

Contents 1 Installation 1.1 Installation on Windows 2003 server 1.2 Installation on Linux 1.3 Using grant to create a new database user account 2 See Also

Installation

Installation on Windows 2003 server

See: 20070305a

Installation on Linux

See: 20070315a

Using grant to create a new database user account

Normally, you create a new database and give a user access to it using the grant command. The basic form for the grant command is something like:

mysql> grant all on sample.* to 'sampadm'@'localhost' identified by 'password';

See http://dev.mysql.com/doc/refman/5.1/en/account-management-sql.html There is also a CREATE USER statement, but I don't think you need it.

See Also

http://www.mysql.com/
http://dev.mysql.com/doc/refman/5.0/en/index.html
MySQL_by_Paul_DuBois
MySQL_Tutorial
Designing Databases http://www.linuxjournal.com/article/3894
Creating Queries http://www.linuxjournal.com/article/3970
MySQL Deserves a Double Take http://interactive.linuxjournal.com/article/9571