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’
Tags:build, configuration, configure, directory, install, linux, mysql, passwords, privileges, roots, scripts, useradd
you can also grab the RSS feed or Subscribe to Techgurulive by Email
