Differences between revisions 49 and 50
Revision 49 as of 2008-03-27 08:19:52
Size: 2108
Comment:
Revision 50 as of 2008-08-07 14:43:37
Size: 2323
Editor: FranklinPiat
Comment:
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]||
----

[:DebianWiki/EditorGuide#translation:Translation(s)]: [:MySql:English] - [:fr/MySql:Français]

(!) [:MySql/Discussion:Discussion]


MySql is a relational Database Management System.

Install

  1. Use ["Synaptic"] to install program if you don't have the packages installed.
  2. Or use command line:

aptitude install mysql-server mysql-client

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.