SubzeroTech - Computer Technologies Message Board

mike · Joined: 10 Oct 2005 Posts: 1

First of all, you should to add a user and group for mysqld to run as:

On Linux:
# groupadd mysql
# useradd -g mysql mysql

On FreeBsd:
# groupadd mysql
# adduser (mysql)

To build MySql follow the next steps:

# mkdir /usr/local/mysql/data
# mkdir /usr/local/mysql/tmp
# mkdir /usr/local/mysql/var
# cd /usr/src
# tar -vzxf mysql-3.23-51.tar.gz
#cd /usr/src/mysql-3.23.51
# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/usr/local/mysql/tmp/mysql.socket
# make
# make install

Change ownership of the MySQL binaries to root and ownership of the data directory to the user that you will run mysqld as:

# chown -R root /usr/local/mysql
# chown -R mysql /usr/local/mysql/var
# chgrp -R mysql /usr/local/mysql

# chmod 700 /usr/local/mysql/data
# chmod 700 /usr/local/mysql/var
# chmod 755 /usr/local/mysql/tmp

To start MySQL by hand, run:

# /usr/local/mysql/bin/safe_mysqld --user=mysql & (MySQL 3.x)
# /usr/local/mysql/bin/mysqld_safe --user=mysql & (MySQL 4.x)

If this is your first-time installation of MySQL, you'll need to set up the initial mysql database, which contains all database privilege information, and establish a mysqld root password.

# scripts/mysql_install_db
# mysqladmin -u root -p password 'new-password'
# mysqladmin -u root -h -p password 'new-password'