MySql is a relational Database Management System.
Install
- Use ["Synaptic"] to install program if you don't have the packages installed.
Or use command line:
aptitude install mysql-server mysql-client
MySql related packages
MySql Server
MySql can start on boot time or only if you type manually (as root):
/etc/init.d/mysql start
After an upgrade of the Debian package you might need to run (as root):
mysql_fix_privilege_tables.
MySql will only install if you have a NON-NUMERIC hostname that is resolvable via the /etc/host file
The Debian package of MySql server creates the user debian-sys-maint that is used in the start-stop and cron ["script"]s. Don't delete him.
MySql Client
To use MySql client just type as any user :
mysql
You can use too MySql Navigator (GUI client program for MySql database server) typing
mysql-navigator
in a terminal (the package name is the same to get it using apt or ["Synaptic"]).
or mysql-query-browser (official GUI tool to query MySql database).
After installation, you can find it in the Debian / Database menu too.
You can use too MySql Control Center, gmyclient and gnome-database .
If you have Apache and PHP installed, you can use phpMyAdmin to administer any MySql databases.
External links
[http://www.osforge.com/viewtutorial55.html A MySQL tutorial]
[http://www.mysql.com MySQL official homepage]
[http://dev.mysql.com/doc/mysql/en/ MySQL Reference Manual]
[http://www.mysql.com/products/administrator/ ?MySqlAdministrator]
[http://dev.mysql.com/downloads/query-browser/ MySQLQueryBrowser]
[http://packages.debian.org/stable/misc/mysql-navigator.html MySQL Navigator debian package]
[http://hem.bredband.net/janpih/Linux/NavigatorHOWTO_en.htm HOWTO Start MySQL Navigator]