快速離線安裝MySql資料庫

一、mysql 壓縮檔案通過ftp 放入\opt-->解壓

cd /opt
tar -xzvf mysql-5.7.29-linux-glibc2.12-×86_64.tar.gz           

二、移動一>建立data 目錄一＞建立使用者組

mv mysql-5.7.29-linux-glibc2.12-×86_64 /usr/local
cd /usr/local
mv mysql-5.7.29-linux-glibc2.12-×86_64 mysql
cd /usr/local/mysql
mkdir data
groupadd mysql
useradd -r -g mysql mysql           

三、編輯my.cnf，拷貝如下配置檔案vi /etc/my.cnf

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port = 3306
socket=/tmp/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld/mysqld.pid
sqL_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY,ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
log-bin=mysql-bin
binlog-format=ROW
server_id=1
max_connections=1000
init_connect='SET collation connection=utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake           

四、mysql.sock、mysqld，初始化、安全啟動

cd /tmp
touch mysql.sock
chown mysql:mysql mysql.sock
chmod 755 mysql.sock
mkdir mysqld
cd /tmp/mysqld
touch mysqld.pid
cd ..
chown -R mysql:mysql mysqld
cd mysqld
chmod 755 mysqld.pid
cd /var/log
touch /var/log/mysqld.log
cd ..
chown -R mysql:mysql /var/log
cd log
chmod 755 mysqld.log
cd /usr/local/mysql/bin/
./mysqld --initialize --user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data
./mysqld_safe --user=mysql &           

五、擷取mm

cat /var/log/mysqld.log |grep password           

六、啟動mysql

cd /usr/local/mysql/bin/ ./mysql -u root -p           

七、更換root初始密碼

set password=password("root mm");
grant all privileges on * * to 'root'@'%' identified by 'root mm'; 
flush privileges;           

八、設定開機啟動＋建立快捷方式

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin
ln -s /usr/local/mysql/bin/mysqladmin /usr/bin           

九、建立mysql資料庫->建立使用者->權限控制

create user 'u1'@'%' identified by 'm1'
grant all privileges on u1.* to 'm1'@'%' identified by 'm1' with grant option;
flush privileges;