快速离线安装 MySql 数据库

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

mv mysql-5.7.29-linux-glibc2.12-×86_64 /usr/localcd /usr/localmv mysql-5.7.29-linux-glibc2.12-×86_64 mysqlcd /usr/local/mysqlmkdir datagroupadd mysqluseradd -r -g mysql mysql

[mysqld]basedir=/usr/local/mysqldatadir=/usr/local/mysql/dataport = 3306socket=/tmp/mysql.socksymbolic-links=0log-error=/var/log/mysqld.logpid-file=/tmp/mysqld/mysqld.pidsqL_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-binbinlog-format=ROWserver_id=1max_connections=1000init_connect='SET collation connection=utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake

cd /tmptouch mysql.sockchown mysql:mysql mysql.sockchmod 755 mysql.sockmkdir mysqldcd /tmp/mysqldtouch mysqld.pidcd ..chown -R mysql:mysql mysqldcd mysqldchmod 755 mysqld.pidcd /var/logtouch /var/log/mysqld.logcd ..chown -R mysql:mysql /var/logcd logchmod 755 mysqld.logcd /usr/local/mysql/bin/./mysqld --initialize --user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data./mysqld_safe --user=mysql &

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

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

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/mysqlchkconfig --add mysqlln -s /usr/local/mysql/bin/mysql /usr/binln -s /usr/local/mysql/bin/mysqladmin /usr/bin

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