build:mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
build:mysql [2005/12/19 00:45] 70.237.137.56 |
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.1 on our Debian 3.1 system. | + | These instructions are for MySQL 5.0 on our Debian 4.0 system. |
| ===== Installation ===== | ===== Installation ===== | ||
| Line 7: | Line 7: | ||
| Install MySQL along with its pre-requisites: | Install MySQL along with its pre-requisites: | ||
| <code rootshell> | <code rootshell> | ||
| - | apt-get install mysql-common-4.1 libmysqlclient12 libmysqlclient14 | + | apt-get install mysql-common mysql-client mysql-server |
| - | apt-get install mysql-client-4.1 libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl | + | |
| - | apt-get install mysql-server-4.1 | + | |
| </code> | </code> | ||
| - | This last one will show you some hints. Hit 'Ok'. | + | 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. |
| - | + | ||
| - | TODO: Would like to do this, but the doc package is nowhere to be found in the repositories or Debian's web site. | + | |
| - | It's supposed to be in the non-free section. I haven't looked too hard for it there. | + | |
| - | <code rootshell> | + | |
| - | apt-get install mysql-doc-4.1 | + | |
| - | </code> | + | |
| ===== Password ===== | ===== Password ===== | ||
| Line 24: | 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. (If this doesn't work, rename you .my.cnf file temporarily and try again). | + | Set the password for MySQL root user. (If this doesn't work, rename your ''.my.cnf'' file temporarily and try again). |
| - | # /usr/bin/mysqladmin -u root password '$MYSQL_ROOT' | + | <code rootshell> |
| + | export MYSQL_ROOT=$MYSQL_ROOT | ||
| + | mysqladmin -u root password "$MYSQL_ROOT" | ||
| + | </code> | ||
| - | Create the MySQL configuration file, and make sure nobody else can read it: | + | Create root's MySQL configuration file, and make sure nobody else can read it: |
| - | # touch ~/.my.cnf | + | <code rootshell> |
| - | # chmod 0600 ~/.my.cnf | + | touch /root/.my.cnf |
| + | chmod 0600 /root/.my.cnf | ||
| + | </code> | ||
| - | Edit the file to set the password when using various client programs: | + | Edit the ''/root/.my.cnf'' file to set the password when using various client programs: |
| - | <code configfile> | + | <code> |
| [mysql] | [mysql] | ||
| user = 'root' | user = 'root' | ||
| Line 45: | Line 42: | ||
| ===== 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 51: | 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 ===== | ||
| - | |||
| - | Need to install 4.1 on budlight. | ||
| - | |||
| - | 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 69: | 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.1134974731.txt.gz · Last modified: 2007/06/08 23:12 (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
