build:mysql
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
build:mysql [2005/03/02 22:46] 64.85.220.137 Initial documentation by Craig Buchek - 2005-03-01 |
build:mysql [2008/07/09 07:31] (current) 24.217.108.17 CMF - the <file configfile>...</file> was not working. Changed to <code> |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== MySQL ====== | ====== MySQL ====== | ||
| - | These instructions are for MySQL 4.0 on our Debian 3.1 (RC) system. | + | These instructions are for MySQL 5.0 on our Debian 4.0 system. |
| ===== Installation ===== | ===== Installation ===== | ||
| - | Install the MySQL packages: | + | Install MySQL along with its pre-requisites: |
| - | + | <code rootshell> | |
| - | # apt-get install mysql-common mysql-client mysql-server | + | apt-get install mysql-common mysql-client mysql-server |
| - | + | </code> | |
| - | Answer YES when prompted to start MySQL at boot. | + | |
| + | NOTE: The MySQL documentation is non-free, and not included with Debian. Use the [[http://dev.mysql.com/doc/ | online documentation]] provided at MySQL's site. | ||
| ===== Password ===== | ===== Password ===== | ||
| Line 17: | Line 16: | ||
| NOTE: In the following instructions, replace $MYSQL_ROOT with the actual password. | NOTE: In the following instructions, replace $MYSQL_ROOT with the actual password. | ||
| - | Set the password for MySQL root user: | + | Set the password for MySQL root user. (If this doesn't work, rename your ''.my.cnf'' file temporarily and try again). |
| + | <code rootshell> | ||
| + | export MYSQL_ROOT=$MYSQL_ROOT | ||
| + | mysqladmin -u root password "$MYSQL_ROOT" | ||
| + | </code> | ||
| - | # /usr/bin/mysqladmin -u root password '$MYSQL_ROOT' | + | Create root's MySQL configuration file, and make sure nobody else can read it: |
| + | <code rootshell> | ||
| + | touch /root/.my.cnf | ||
| + | chmod 0600 /root/.my.cnf | ||
| + | </code> | ||
| - | Create the MySQL configuration file, and make sure nobody else can read it: | + | Edit the ''/root/.my.cnf'' file to set the password when using various client programs: |
| + | <code> | ||
| + | [mysql] | ||
| + | user = 'root' | ||
| + | password = '$MYSQL_ROOT' # THIS IS NOT THE REAL PASSWORD; DO NOT CUT AND PASTE THIS! | ||
| - | # touch ~/.my.cnf | + | [mysqladmin] |
| - | # chmod 0600 ~/.my.cnf | + | user = 'root' |
| - | + | password = '$MYSQL_ROOT' # THIS IS NOT THE REAL PASSWORD; DO NOT CUT AND PASTE THIS! | |
| - | Edit the file to set the password when using various client programs: | + | </code> |
| - | + | ||
| - | [mysql] | + | |
| - | user = 'root' | + | |
| - | password = '$MYSQL_ROOT' | + | |
| - | + | ||
| - | [mysqladmin] | + | |
| - | user = 'root' | + | |
| - | password = '$MYSQL_ROOT' | + | |
| ===== Notes ===== | ===== Notes ===== | ||
| - | I wanted to install mysql-doc package too, but it doesn't seem to exist in Sarge. | + | I wanted to install mysql-doc package too, but it doesn't seem to exist even in the non-free section. This appears to be due to the MySQL corporation's licensing. |
| The Debian installation creates a MySQL user named "debian-sys-maint". | The Debian installation creates a MySQL user named "debian-sys-maint". | ||
| Line 45: | Line 48: | ||
| Don't delete it. | Don't delete it. | ||
| - | See /usr/share/doc/mysql-server/README.Debian for more information. | + | See ''/usr/share/doc/mysql-server-5.0/README.Debian.gz'' for more information. |
| ===== TODO ===== | ===== TODO ===== | ||
| - | |||
| - | Not sure if we need to set a password on the "debian-sys-maint" account, | ||
| - | or anything else like that. | ||
| - | The Debian docs don't say anything about it, so I suppose we're OK. | ||
| Could probably use some tuning and routine maintenance. | Could probably use some tuning and routine maintenance. | ||
| Line 62: | Line 60: | ||
| Initially installed, configured, and documented by Craig Buchek, 2005-02-23. | Initially installed, configured, and documented by Craig Buchek, 2005-02-23. | ||
| + | |||
| + | Installed version 5.0 on 2007-06-08, Craig Buchek. | ||
build/mysql.1109825200.txt.gz · Last modified: 2005/09/10 14:48 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
