From LQWiki

MySQL is an open source RDBMS server that uses SQL for inserting, selecting and updating data. It's very fast, capable, flexible, and runs on UNIX, Linux, Mac and Windows platforms.

Contents 1 QuickStart 2 Add a user 2.1 GUI's include 2.2 See also 2.3 External links

QuickStart

Install mysql from your distribution. Start mysql on your local computer with

/etc/init.d/mysql start

Build up a connection to mysql:

mysql --user root
mysql> show databases;

Set root's password.

mysql> set password = password("new_password");

Set up a GUI to administer your new mysql database.

Add a user

This adds a user named user1 with a password password1

mysql --user root --password password1
grant all on * to 'user1'@'localhost' identified by 'password1' with grant option;

GUI's include

• PHPMyAdmin
• DataDino
• DBVisualizer
• MySQL Administrator
• MySQL Query Browser

See also

• MySQL Backup Procedure
• Database
• Database Tools

External links

• MySQL Project Homepage (www.mysql.com)
• MySQL Project Documentation page (dev.mysql.com)
• MySQL Forum (www.nabble.com)