First off, Google and download the file mysql-3.23.32.tar.gz [5.25M] to the /usr/local/src directory.
Next create a system user called mysql. This is not an actual user who would log into the system, but merely a username to run the MySQL service itself, from within the Unix environment.
Neither is this user an actual MySQL user itself. The actual MySQL users will be created later.
Create a user named mysql with the adduser command. Make them a part of the mysql group.
Use an empty password and a null shell (nologin):
Full name: mysql
Uid (Leave empty for default):
Login group [mysql]:
Login group is mysql. Invite mysql into other groups? :
Login class [default]:
Shell (sh csh tcsh bash nologin) [sh]: nologin
Home directory [/home/mysql]:
Use password-based authentication? [yes]:
Use an empty password? (yes/no) [no]:yes
Lock out account after creation? [no]:
OK? (yes/no): yes
Move into the /usr/local/src diectory and unpack the mysql tarball:
tar -zxvf mysql-3.23.32.tar.gz
Move into the newly created mysql directory:
Next you need to build a configure script. This must be done as root:
Inside the script type:
#Mysql Configure Script
./configure --prefix=/usr/local/mysql \
Once you have saved and exited the script, run it:
After this script runs do the following:
Next you need to run the following command to initialise the mysql database:
Make the following links. (Be very careful here!!!):
ln -s /usr/local/mysql/bin/mysql /usr/local/sbin/mysql
ln -s /usr/local/mysql/bin/mysqladmin /usr/local/sbin/mysqladmin
ln -s /usr/local/mysql/bin/safe_mysqld /usr/local/sbin/safe_mysqld
To start the mysql server (in the background '&') run:
(hit enter twice to get back to the prompt)
To test the server run: