Install MySQL Without Root

.Install MySQL Without Root.md

Install MySQL Without Root

Resources

• http://articles.slicehost.com/2011/3/10/configuring-mysql-server-on-centos
• http://docdb.fnal.gov/doc/my.cnf.html

example_my.cnf

# Default options are read from the following files in the given order:
# /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

[mysqld]
user=mysql_owner
datadir=/path/to/datadir/mysql
socket=/path/to/datadir/mysql/mysql.sock
skip-innodb
     
[mysql.server]
user=mysql_owner
basedir=/path/to/datadir

[client]
user=mysql_owner
socket=/path/to/datadir/mysql/mysql.sock

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

gistfile1.txt

# Download from http://dev.mysql.com/downloads/mysql/

# create directory structure
mkdir -p ~/.local/opt/

# extract
tar -xvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz -C ~/.local/opt
cd ~/.local/opt/mysql-5.7.11-linux-glibc2.5-x86_64

# initialize
bin/mysqld --initialize

# secure it
bin/mysql_secure_installation

# start it
bin/mysqld_safe

# stop it
bin/mysqladmin shutdown