Install MySQL From A Tarball

export MYSQL_BASE_DIR=/Volumes/sm/servers/mysql
export MYSQL_COMMON_DIR=/Volumes/sm/repos/mysql
export MYSQL_DATA_DIR=/Volumes/sm/repos/mysql/data
export MYSQL_LOGS_DIR=/Volumes/sm/repos/mysql/logs
# 初始化的过程中不要在MySQL的`data`目录中放任何内容

mkdir -p ${MYSQL_LOGS_DIR}
mkdir /Volumes/sm/repos/mysql/tmpdir
mysqld --initialize \
	--user=${USERNAME} \
	--basedir=${MYSQL_BASE_DIR} \
	--datadir=${MYSQL_DATA_DIR} \
	--log-error=${MYSQL_LOGS_DIR}/error.log \
	--pid-file=${MYSQL_COMMON_DIR}/mysql.pid \
	--socket=${MYSQL_COMMON_DIR}/mysql.sock --port=3306

cat ${MYSQL_LOGS_DIR}/error.log

mysqld --user=${USERNAME} \
	--basedir=${MYSQL_BASE_DIR} \
	--datadir=${MYSQL_DATA_DIR} \
	--log-error=${MYSQL_LOGS_DIR}/error.log \
	--pid-file=${MYSQL_COMMON_DIR}/mysql.pid \
	--socket=${MYSQL_COMMON_DIR}/mysql.sock \
	--server-id=80000 \
	--log-bin=mysql-log \
	--log-bin-index=mysql-log \
	--binlog-format=ROW \
	--binlog-row-event-max-size=1024 \
	--port=3306 &

mysql -uroot -p --socket=${MYSQL_COMMON_DIR}/mysql.sock
# 输入之前从日志中获取的初始密码

# 修改root默认密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'qweasd';

# 创建用户
CREATE USER yakir IDENTIFIED WITH caching_sha2_password BY 'qweasd';
# ALTER USER yakir IDENTIFIED WITH mysql_native_password BY 'qweasd';

# 删除用户
# DROP USER 'canal'@'%';

# 赋权
GRANT ALL PRIVILEGES ON *.* TO 'yakir'@'%' ;
FLUSH PRIVILEGES;

# 开启远程访问
use mysql;
update user set host='%' where user='root';
FLUSH PRIVILEGES;

mysqladmin shutdown --socket=${MYSQL_COMMON_DIR}/mysql.sock -uroot -p

# 目录变量定义
MYSQL_BASE_DIR='/data/mysql'
MYSQL_DATA_DIR='/data/store/mysql'
MYSQL_LOGS_DIR='/data/store/logs/mysql'

apt-cache search libaio1
apt-get install libaio1 

# 添加用户组
groupadd mysql 
# 添加mysql用户
useradd -r -g mysql -s /bin/false mysql 

# 修改目录权限
mkdir -p ${MYSQL_DATA_DIR}
chmod 750 ${MYSQL_DATA_DIR}
chown -R mysql .
chgrp -R mysql .
chown -R mysql ${MYSQL_DATA_DIR}
chgrp -R mysql ${MYSQL_DATA_DIR}

/data/mysql/bin/mysqld --initialize \
        --user=mysql \
        --basedir=${MYSQL_BASE_DIR} \
        --datadir=${MYSQL_DATA_DIR} \
        --log-error=${MYSQL_LOGS_DIR}/error.log \
        --pid-file=${MYSQL_COMMON_DIR}/mysql.pid \
        --socket=${MYSQL_COMMON_DIR}/mysql.sock \
        --port=3306

/data/mysql/bin/mysql_ssl_rsa_setup \
        --user=mysql \
        --basedir=${MYSQL_BASE_DIR} \
        --datadir=${MYSQL_DATA_DIR} \
        --log-error=${MYSQL_LOGS_DIR}/error.log \
        --pid-file=${MYSQL_COMMON_DIR}/mysql.pid \
        --socket=${MYSQL_COMMON_DIR}/mysql.sock \
        --port=3306

cat ${MYSQL_LOGS_DIR}/error.log

chown -R root .
chown -R mysql /data/store/mysql

echo '启动mysql实例'
/data/mysql/bin/mysqld \
        --user=mysql \
        --basedir=${MYSQL_BASE_DIR} \
        --datadir=${MYSQL_DATA_DIR} \
        --log-error=${MYSQL_LOGS_DIR}/error.log \
        --pid-file=${MYSQL_COMMON_DIR}/mysql.pid \
        --socket=${MYSQL_COMMON_DIR}/mysql.sock \
        --server-id=90000 \
        --log-bin=mysql-log \
        --log-bin-index=mysql-log \
        --binlog-format=ROW \
        --binlog-row-event-max-size=1024 \
        --port=3306 &

# 启动实例示例
# /usr/local/mysql/bin/mysqld \
        --basedir=/usr/local/mysql \
        --datadir=/opt/mysql/data \
        --plugin-dir=/usr/local/mysql/lib/plugin \
        --user=mysql \
        --log-error=/opt/mysql/data/error.log \
        --pid-file=/opt/mysql/data/localhost.localdomain.pid \
        --socket=/opt/mysql/data/mysql.sock \
        --port=3306

# 停止实例
# /data/mysql/bin/mysqladmin shutdown --socket=/data/store/mysql/mysql.sock -uroot -p