<output id="qn6qe"></output>

    1. <output id="qn6qe"><tt id="qn6qe"></tt></output>
    2. <strike id="qn6qe"></strike>

      亚洲 日本 欧洲 欧美 视频,日韩中文字幕有码av,一本一道av中文字幕无码,国产线播放免费人成视频播放,人妻少妇偷人无码视频,日夜啪啪一区二区三区,国产尤物精品自在拍视频首页,久热这里只有精品12

      MySQL 8.0二進(jìn)制安裝

      1.下載 mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz 安裝包
      創(chuàng)建目錄 mkdir /app 
      tar xf  mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz   -C /app
      mv  mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz  mysql
      切換到/app/mysql目錄
      創(chuàng)建run mysqldata  etc tmp  &&  cd mysqldata
      mkdir logs data
      
      2.編輯my.cnf文件
      cd /app/mysql/etc
      vim my.cnf
      [mysql]
      prompt = [\u@\p][\d]>\_
      default-character-set=utf8mb4
      [client]
      port       = 3306
      socket     = /app/mysql/run/mysql.sock
      #prompt= "\u@\h :\d \R:\m:\s >"
      [mysqld]
      port       = 3306
      server-id  = 1
      socket     = /app/mysql/run/mysql.sock
      basedir    = /app/mysql
      datadir    = /app/mysql/mysqldata/data
      log-bin    = /app/mysql/mysqldata/data/mysql-bin
      innodb_data_home_dir      =/app/mysql/mysqldata/data
      innodb_log_group_home_dir =/app/mysql/mysqldata/data
      log-error =/app/mysql/mysqldata/logs/error.log
      pid-file  =/app/mysql/mysqldata/data/mysql.pid
      character-set-server=utf8mb4
      lower_case_table_names=1
      autocommit =1
      skip-external-locking
      key_buffer_size = 256M
      max_allowed_packet = 1M
      table_open_cache = 1024
      sort_buffer_size = 4M
      net_buffer_length = 8K
      read_buffer_size = 4M
      read_rnd_buffer_size = 512K
      myisam_sort_buffer_size = 64M
      thread_cache_size = 128
      tmp_table_size = 128M
      explicit_defaults_for_timestamp = true
      max_connections = 500
      max_connect_errors = 100
      open_files_limit = 65535
      binlog_format=mixed
      binlog_expire_logs_seconds =864000
      default_storage_engine = InnoDB
      innodb_data_file_path = ibdata1:10M:autoextend
      innodb_buffer_pool_size = 1024M
      innodb_log_file_size = 256M
      innodb_log_buffer_size = 8M
      innodb_flush_log_at_trx_commit = 1
      innodb_lock_wait_timeout = 50
      transaction-isolation=READ-COMMITTED
      [mysqldump]
      quick
      max_allowed_packet = 16M
      [myisamchk]
      key_buffer_size = 256M
      sort_buffer_size = 4M
      read_buffer = 2M
      write_buffer = 2M
      [mysqlhotcopy]
      interactive-timeout
      
      3.新建用戶groupadd mysql  && useradd mysql -g mysql
      echo "123456"|passwd --stdin mysql
      
      修改目錄權(quán)限 chown mysql:mysql /app/mysql -R
      
      4.初始化數(shù)據(jù)目錄
      /app/mysql/bin/mysqld --defaults-file=/app/mysql/conf/my.cnf  --basedir=/app/mysql  --datadir=/app/mysql/mysqldata/data --user=mysql  --lower_case_table_names=1  --initialize 
      
      5.修改啟動文件
      cp  /app/mysql/support-files/mysql.server   /etc/init.d/mysql
      basedir=/app/mysql
      datadir=/app/mysql/mysqldata/data
      修改266行 
      $bindir/mysqld_safe --defaults-file=/app/mysql/conf/my.cnf --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
      加上 --defaults-file=/app/mysql/conf/my.cnf 
      
      6.啟動mysql
      /etc/init.d/mysql start
      創(chuàng)建軟連接  ln -s /app/mysql/etc/my.cnf  /etc/my.cnf
      
      7.修改密碼
      通過/app/mysql/mysqldata/logs
      cat error.log 日志文件中密碼登錄
      set password ='123456';
      
      8.配置環(huán)境變量  
      vi /home/mysql/.bash_profile
      export PATH=$PATH:/app/mysqlbin
      
      source /home/mysql/.bash_profile
      
      posted @ 2025-09-03 14:45  黃多魚  閱讀(5)  評論(0)    收藏  舉報
      主站蜘蛛池模板: 免费看婬乱a欧美大片| 亚洲中文字幕无码一区无广告| 这里只有精品免费视频| 亚洲欧美一区二区成人片| 色综合久久夜色精品国产| 少妇极品熟妇人妻| 亚洲成人av免费一区| 亚洲AV永久中文无码精品综合| 狠狠精品久久久无码中文字幕| 亚洲国产欧美一区二区好看电影| 巨熟乳波霸若妻在线播放| 啊┅┅快┅┅用力啊岳网站| 香蕉亚洲欧洲在线一区| 国精偷拍一区二区三区| 精品久久人人妻人人做精品| 国产亚洲精品日韩av在| 国产免费一区二区不卡| 亚洲va在线∨a天堂va欧美va| 国产精品一区二区三区日韩| 久久精品蜜芽亚洲国产AV| 丰满无码人妻热妇无码区| 内地自拍三级在线观看| 国产精品午夜福利资源| 国产亚洲无线码一区二区| 亚洲第一福利网站在线| 亚洲熟女精品一区二区| 久久理论片午夜琪琪电影网| 国产成人啪精品午夜网站| 国产成人午夜精品福利| 久久精品亚洲精品国产色婷| a片在线免费观看| 国产肥臀视频一区二区三区| 天天综合亚洲色在线精品| 亚洲国产欧美一区二区好看电影| 一区二区亚洲人妻av| 东北妇女精品bbwbbw| 午夜福利国产区在线观看| 在线视频中文字幕二区| 一 级做人爱全视频在线看| 色欲AV无码一区二区人妻| 99久久婷婷国产综合精品|