2108
Comment:
|
2323
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
## Auto-converted by kwiki2moinmoin v2005-10-07 | #language en ||<tablestyle="width: 100%;" style="border: 0px hidden">~-[:DebianWiki/EditorGuide#translation:Translation(s)]: [:MySql:English] - [:fr/MySql:Français] -~||<style="text-align: right;border: 0px hidden"> (!) [:MySql/Discussion:Discussion]|| ---- |
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]