install gz mysql

us_ateneo

已于 2024-05-08 17:24:36 修改

阅读量94

点赞数 1

文章标签： mysql

于 2024-05-08 16:39:53 首次发布

本文链接：https://blog.csdn.net/us_wangyl/article/details/138576822

版权

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.32-linux-glibc2.17-x86_64-minimal.tar.xz

tar -Jxf mysql-8.0.32-linux-glibc2.17-x86_64-minimal.tar.xz

mv mysql-8.0.32-linux-glibc2.17-x86_64-minimal /usr/local/

cd /usr/local/

ln -s mysql-8.0.32-linux-glibc2.17-x86_64-minimal/ mysql

useradd mysql
mkdir -p /data/db/dblogs/mysql3306/slowlogs/
mkdir -p /data/db/dblogs/mysql3306/binlogs/
mkdir -p /data/db/dblogs/mysql3306/relaylogs/
mkdir -p /data//db/mysql3306/mysqltmp/
mkdir -p /data/db/mysql3306/filedir/
cd /data/
chown -R mysql:mysql db
cd db/
chown -R mysql:mysql dblogs/
cd mysql3306/
chown -R mysql:mysql filedir
cd /data/
chown -R mysql:mysql db

cd /data/dba/mysql3306
vim my.cnf
 [client]
  port  =3306
  socket = /data/db/mysql3306/mysql3306.sock
 [mysql]
  prompt="\u\@\h[\d]> "
  no-auto-rehash
 [mysqld]
  user        = mysql
  port        = 3306
  basedir      = /usr/local/mysql
  datadir      = /data/db/mysql3306/data
  socket       = /data/db/mysql3306/mysql3306.sock
  pid_file     = /data/db/mysql3306/mysql3306.pid
  server_id    = 015001
  character-set-server  = utf8mb4
  collation-server      = utf8mb4_unicode_ci
  character-set-client-handshake      = FALSE
  tmpdir                = /data/db/mysql3306/mysqltmp
  log_timestamps        = SYSTEM
  log_error             = /data/db/mysql3306/error.log
  log_error_verbosity   = 2
  slow_query_log_file   = /data/db/dblogs/mysql3306/slowlogs/mysql_slow.log
  long_query_time       = 1
  general_log_file      = /data/db/dblogs/mysql3306/relaylogs/mysql_gene.log
  secure_file_priv      = /data/db/mysql3306/filedir

/usr/local/mysql/bin/mysqld --defaults-file=/data/db/mysql3306/my.cnf --basedir=/usr/local/mysql --user=mysql --initialize --explicit_defaults_for_timestamp

/usr/local/mysql/bin/mysqld --defaults-file=/data/db/mysql3306/my.cnf --basedir=/usr/local/mysql --datadir=/data/db/mysql3306/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql

/usr/local/mysql/bin/mysql -uroot -p -P3306 -S /data/db/mysql3306/mysql3306.sock

cd /data/db/mysql3306/
cat error.log
--- check mysql login password
/usr/local/mysql/bin/mysql -uroot -p -P3306 -S /data/db/mysql3306/mysql3306.sock
 
alter user 'root'@'localhost' identified by 'ScujK/TN+ddyzkvRgyN55w=='