如果/etc/profile 有mysql 环境变量请删除

1、解压安装
   修改目录名称及权限

2、修改my.cnf,放在安装目录

[client]
port=3306
default-character-set=utf8mb4
socket = /tmp/mysql2.sock

[mysqld]
basedir = /usr/local/mysql2
datadir = /home/mysql2/data
port = 3307
server-id = 102
socket = /tmp/mysql2.sock

3、修改support-files/mysql.server

basedir=/usr/local/mysql2
datadir=/home/mysql2/data
mysqld_pid_file_path=/home/mysql2/data/mysql2.pid
conf=/usr/local/mysql2/my.cnf
lock_file_path="$lockdir/mysql2"

增加 --defaults-file及--user=mysql2

$bindir/mysqld_safe --defaults-file="/usr/local/mysql2/my.cnf" --user=mysql2 --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &

如果不能启动，则写死修改为：

/usr/local/mysql2/bin/mysqld_safe --defaults-file=/usr/local/mysql2/my.cnf --user=mysql2 --datadir=/home/mysql2/data --pid-file=/home/mysql2/data/mysql2.pid >/dev/null &

4、初始化数据库
/usr/local/mysql2/bin/mysqld --defaults-file=/usr/local/mysql2/my.cnf --initialize --user=mysql2 --basedir=/usr/local/mysql2 --datadir=/home/mysql2/data

5、启动启动数据库

cp /usr/local/mysql2/support-files/mysql.server /etc/init.d/mysqld2

chkconfig --add mysqld2

6、登陆数据库
/usr/local/mysql2/bin/mysql -u root -p --socket=/tmp/mysql2.sock

登录后修改管理员密码
set password=PASSWORD('新密码');
flush privileges;
set sql_safe_updates=off;
update mysql.user set authentication_string=PASSWORD('新密码');
flush privileges;