{"id":170,"date":"2026-01-31T15:22:11","date_gmt":"2026-01-31T07:22:11","guid":{"rendered":"http:\/\/47.100.165.17\/wordpress\/?p=170"},"modified":"2026-01-31T15:45:58","modified_gmt":"2026-01-31T07:45:58","slug":"linux-%e7%8e%af%e5%a2%83%e4%b8%8b-mysql8-0-%e7%9a%84%e4%b8%89%e7%a7%8d%e5%ae%89%e8%a3%85%e4%b8%8e%e9%83%a8%e7%bd%b2%e5%85%a8%e9%9d%a2%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/yunyanglib.cn\/?p=170","title":{"rendered":"\u3010MySQL\u3011Linux \u73af\u5883\u4e0b MySQL8.0 \u7684\u4e09\u79cd\u5b89\u88c5\u4e0e\u90e8\u7f72\u5168\u9762\u6307\u5357"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">1 Linux\u5feb\u901f\u5b89\u88c5MySQL8.0<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><br>1.1 \u5378\u8f7d\u539f\u6709\u7684MySQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\u901a\u8fc7\u4ee5\u4e0b\u6b65\u9aa4\uff0c\u627e\u51fa Linux \u7cfb\u7edf\u4e0a\u5df2\u5b89\u88c5\u7684\u6240\u6709 MySQL \u7248\u672c\u5e76\u5b8c\u5168\u5378\u8f7d\uff0c\u786e\u4fdd\u4e0d\u6b8b\u7559\u4efb\u4f55 MySQL \u76f8\u5173\u6587\u4ef6\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># 1. \u521b\u5efa\u811a\u672c\u4fdd\u5b58\u76ee\u5f55\u5e76\u8fdb\u5165\nmkdir \/data\/script\ncd \/data\/script\n# 2. \u521b\u5efa\u5e76\u7f16\u8f91MySQL\u5b8c\u5168\u5378\u8f7d\u811a\u672c\uff0c\u5e76\u4fdd\u5b58\u7f16\u8f91\nvim mysql_uninstall.sh\n# 3. \u6388\u4e88\u811a\u672c\u53ef\u6267\u884c\u6743\u9650\nchmod +x mysql-uninstall.sh\n# 4. \u6267\u884c\u811a\u672c\nsh mysql-uninstall.sh <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><code>mysql-uninstall.sh <\/code>\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n\n# \u989c\u8272\u5b9a\u4e49\nRED='\\033&#91;0;31m'\nGREEN='\\033&#91;0;32m'\nYELLOW='\\033&#91;0;33m'\nNC='\\033&#91;0m' # No Color\n\n# \u9519\u8bef\u5904\u7406\u51fd\u6570\nhandle_error() {\n    echo -e \"${RED}\u9519\u8bef:${NC} $1\" >&amp;2\n    exit 1\n}\n\n# \u68c0\u67e5\u662f\u5426\u4e3aroot\u7528\u6237\nif &#91; \"$(id -u)\" -ne 0 ]; then\n    handle_error \"\u6b64\u811a\u672c\u9700\u8981root\u6743\u9650\u8fd0\u884c\uff0c\u8bf7\u4f7f\u7528sudo\u6267\u884c\u6b64\u811a\u672c\"\nfi\n\necho -e \"${YELLOW}===== \u5f00\u59cb\u68c0\u67e5\u5df2\u5b89\u88c5\u7684MySQL\u7248\u672c ====${NC}\"\n\n# \u67e5\u627e\u6240\u6709\u5df2\u5b89\u88c5\u7684MySQL\u76f8\u5173\u5305\necho -e \"${GREEN}\u6b63\u5728\u67e5\u627e\u5df2\u5b89\u88c5\u7684MySQL\u5305...${NC}\"\nmysql_packages=$(dpkg -l | grep -i mysql | awk '{print $2}' | tr '\\n' ' ')\n\nif &#91; -z \"$mysql_packages\" ]; then\n    echo -e \"${GREEN}\u672a\u53d1\u73b0\u5df2\u5b89\u88c5\u7684MySQL\u5305${NC}\"\nelse\n    echo -e \"${GREEN}\u53d1\u73b0\u4ee5\u4e0bMySQL\u5305:${NC}\"\n    echo \"$mysql_packages\"\n    \n    echo -e \"${YELLOW}===== \u5f00\u59cb\u5378\u8f7dMySQL\u5305 ====${NC}\"\n    echo -e \"${GREEN}\u6b63\u5728\u5378\u8f7dMySQL\u5305...${NC}\"\n    if ! apt-get purge -y $mysql_packages; then\n        handle_error \"\u5378\u8f7dMySQL\u5305\u65f6\u51fa\u9519\"\n    fi\n    echo -e \"${GREEN}MySQL\u5305\u5378\u8f7d\u5b8c\u6210${NC}\"\nfi\n\n# \u68c0\u67e5\u5e76\u79fb\u9664\u6b8b\u7559\u914d\u7f6e\u6587\u4ef6\necho -e \"${YELLOW}===== \u5f00\u59cb\u6e05\u7406\u6b8b\u7559\u914d\u7f6e\u6587\u4ef6 ====${NC}\"\necho -e \"${GREEN}\u6b63\u5728\u6e05\u7406MySQL\u914d\u7f6e\u6587\u4ef6...${NC}\"\nmysql_config_dirs=\"\/etc\/mysql \/var\/lib\/mysql \/var\/log\/mysql\"\nfor dir in $mysql_config_dirs; do\n    if &#91; -d \"$dir\" ]; then\n        echo -e \"${GREEN}\u79fb\u9664\u76ee\u5f55:${NC} $dir\"\n        if ! rm -rf \"$dir\"; then\n            handle_error \"\u79fb\u9664\u76ee\u5f55 $dir \u65f6\u51fa\u9519\"\n        fi\n    fi\ndone\necho -e \"${GREEN}\u914d\u7f6e\u6587\u4ef6\u6e05\u7406\u5b8c\u6210${NC}\"\n\n# \u6e05\u7406apt\u7f13\u5b58\necho -e \"${YELLOW}===== \u5f00\u59cb\u6e05\u7406APT\u7f13\u5b58 ====${NC}\"\necho -e \"${GREEN}\u6b63\u5728\u6e05\u7406APT\u7f13\u5b58...${NC}\"\nif ! apt-get autoremove -y; then\n    handle_error \"\u6e05\u7406APT\u7f13\u5b58\u65f6\u51fa\u9519\"\nfi\nif ! apt-get autoclean -y; then\n    handle_error \"\u6e05\u7406APT\u7f13\u5b58\u65f6\u51fa\u9519\"\nfi\necho -e \"${GREEN}APT\u7f13\u5b58\u6e05\u7406\u5b8c\u6210${NC}\"\n\n# \u68c0\u67e5\u662f\u5426\u8fd8\u6709MySQL\u76f8\u5173\u6587\u4ef6\necho -e \"${YELLOW}===== \u68c0\u67e5\u662f\u5426\u8fd8\u6709MySQL\u76f8\u5173\u6587\u4ef6 ====${NC}\"\necho -e \"${GREEN}\u6b63\u5728\u641c\u7d22\u6b8b\u7559\u7684MySQL\u6587\u4ef6...${NC}\"\nremaining_files=$(find \/ -name \"*mysql*\" 2>\/dev\/null | grep -Ev \"^\/proc|^\/sys|^\/dev|^\/run\" || true)\n\nif &#91; -n \"$remaining_files\" ]; then\n    echo -e \"${YELLOW}\u53d1\u73b0\u4ee5\u4e0b\u53ef\u80fd\u7684\u6b8b\u7559\u6587\u4ef6:${NC}\"\n    echo \"$remaining_files\"\n    \n    echo -e \"${YELLOW}\u662f\u5426\u5220\u9664\u8fd9\u4e9b\u6587\u4ef6? (y\/n)${NC}\"\n    read -r answer\n    if &#91; \"$answer\" = \"y\" ] || &#91; \"$answer\" = \"Y\" ]; then\n        echo -e \"${GREEN}\u6b63\u5728\u5220\u9664\u6b8b\u7559\u6587\u4ef6...${NC}\"\n        while IFS= read -r file; do\n            if &#91; -e \"$file\" ]; then\n                echo -e \"${GREEN}\u5220\u9664\u6587\u4ef6:${NC} $file\"\n                if ! rm -rf \"$file\"; then\n                    echo -e \"${RED}\u65e0\u6cd5\u5220\u9664\u6587\u4ef6:${NC} $file\"\n                fi\n            fi\n        done &lt;&lt;&lt; \"$remaining_files\"\n        echo -e \"${GREEN}\u6b8b\u7559\u6587\u4ef6\u5220\u9664\u5b8c\u6210${NC}\"\n    else\n        echo -e \"${YELLOW}\u8df3\u8fc7\u5220\u9664\u6b8b\u7559\u6587\u4ef6${NC}\"\n    fi\nelse\n    echo -e \"${GREEN}\u672a\u53d1\u73b0\u6b8b\u7559\u7684MySQL\u6587\u4ef6${NC}\"\nfi\n\necho -e \"${GREEN}===== MySQL\u5378\u8f7d\u5b8c\u6210 ====${NC}\"\necho -e \"${GREEN}\u7cfb\u7edf\u4e2d\u5df2\u4e0d\u5305\u542bMySQL\u7684\u4efb\u4f55\u7ec4\u4ef6${NC}\"    <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><br>1.2 \u4e0b\u8f7dMySQL\u5b89\u88c5\u5305\u5e76\u89e3\u538b<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4e0b\u8f7dMySQL\u5b89\u88c5\u5305<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/src\nwget https:\/\/downloads.mysql.com\/archives\/get\/p\/23\/file\/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u89e3\u538bMySQL\u538b\u7f29\u5305<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>xz -d mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz\ntar -xvf mysql-8.0.25-linux-glibc2.12-x86_64.tar\nmv mysql-8.0.25-linux-glibc2.12-x86_64 \/usr\/local\/mysql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">1.3 \u7528\u6237\u548c\u76ee\u5f55\u521b\u5efa<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u521b\u5efaMySQL\u7528\u6237<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>groupadd mysql\nuseradd -r -g mysql -s \/bin\/false mysql\n# -r\u5efa\u7acb\u7cfb\u7edf\u8d26\u53f7<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u521b\u5efaMySQL\u76f8\u5173\u76ee\u5f55<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir \/data\/mysql\/ -p\nmkdir \/data\/mysql\/{binlog,data,log,tmpdir,conf} -p<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4fee\u6539\u5c5e\u4e3b<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R mysql:mysql \/data\/mysql\/\nchown -R mysql:mysql \/usr\/local\/mysql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">1.4 \u589e\u52a0\u914d\u7f6e\u6587\u4ef6<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>vim \/data\/mysql\/conf\/my.cnf<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><code>my.cnf<\/code>\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\nport        = 3306\nsocket      = \/tmp\/mysql.sock\n\n&#91;mysqld]\nport    = 3306\nsocket  = \/tmp\/mysql.sock\n\n##  dir set\ndatadir           = \/data\/mysql\/data\ninnodb_data_home_dir   = \/data\/mysql\/data\ninnodb_log_group_home_dir = \/data\/mysql\/data\nlog-bin           = \/data\/mysql\/binlog\/mysql-bin\nlog_bin_index             = \/data\/mysql\/binlog\/mysql-bin.index  \nrelay-log         = \/data\/mysql\/binlog\/mysql-relay-bin\ntmpdir            = \/data\/mysql\/tmpdir\nslow_query_log_file   = \/data\/mysql\/log\/mysql-slow.log\ngeneral_log_file   = \/data\/mysql\/log\/mysql-general.log\nlog-error         = \/data\/mysql\/log\/mysql.err\n\n## slave and binlog\nserver-id = 6666            #   \nskip-slave-start = 0        #\nread_only = 0           #\nbinlog_format = row             \nlog-slave-updates = 1\nmaster_info_repository = table\nrelay_log_info_repository = table\nrelay_log_purge = 1\nrelay_log_recovery = 1\nsync_binlog = 100                   # !!!\n\nbinlog_cache_size = 1M\nexpire_logs_days = 30\nlog_bin_trust_function_creators = 1         \nslave_net_timeout=60                \n#binlog_error_action=\"IGNORE_ERROR\"     \n\ninnodb_autoinc_lock_mode=1          \n\n## \nback_log = 200\nbulk_insert_buffer_size = 8M            \n#character-set-server = utf8\nlower_case_table_names = 1              #  1\uff1a\u4e0d\u533a\u5206\n\n## \u57fa\u7ebf\nlocal-infile = off\nskip-networking = off\nskip-name-resolve = on \n\n## connect\nmax_allowed_packet = 32M\nmax_connect_errors = 1000\nmax_connections = 3000\nwait_timeout = 3600             # \u5173\u95ed \u975e\u4ea4\u4e92 \u8fde\u63a5\u4e4b\u524d\u7b49\u5f85\u6d3b\u52a8\u7684\u79d2\u6570 default:8h\ninteractive_timeout = 3600          # \u5173\u95ed \u4ea4\u4e92\u5f0f \u8fde\u63a5\u4e4b\u524d\u7b49\u5f85\u6d3b\u52a8\u7684\u79d2\u6570 default:8h\n\ntable_open_cache = 4096\nthread_cache_size =  64\nthread_stack = 192K\ntransaction-isolation = REPEATABLE-READ     # \npid-file = mysql.pid\n\n## slow\nslow_query_log = 1              \nlong_query_time = 1\nlog-slow-admin-statements\nlog_queries_not_using_indexes = 0\nslow_launch_time = 1\nread_buffer_size = 4M               \nread_rnd_buffer_size = 8M           \nsort_buffer_size = 8M\njoin_buffer_size = 32M\ntmp_table_size = 128M\nmax_heap_table_size = 128M\n\ndefault-storage-engine = innodb\nexplicit_defaults_for_timestamp = on           \n\n## innodb\ninnodb_buffer_pool_size = 1G                    \ninnodb_max_dirty_pages_pct = 80         \ninnodb_thread_concurrency = 8           \ninnodb_buffer_pool_instances = 1        \ninnodb_flush_log_at_trx_commit = 2      \ninnodb_read_io_threads = 8          \ninnodb_write_io_threads = 4         \ninnodb_io_capacity = 1000\ninnodb_io_capacity_max = 2000\ninnodb_lru_scan_depth = 1024\ninnodb_use_native_aio = 1\ninnodb_flush_neighbors = 1\ninnodb_buffer_pool_load_at_startup = 1\ninnodb_buffer_pool_dump_at_shutdown = 1\n\ninnodb_data_file_path=ibdata:1G:autoextend\ninnodb_log_files_in_group = 3\ninnodb_log_file_size = 2G\ninnodb_file_per_table = 1 \n\ninnodb_flush_method = O_DIRECT\ninnodb_strict_mode = 1\ninnodb_lock_wait_timeout = 30\ninnodb_log_buffer_size = 16M\ninnodb_adaptive_flushing = 1\ninnodb_change_buffering = all\ninnodb_purge_threads = 4            \ninnodb_purge_batch_size = 300           \n\ninnodb_old_blocks_time = 1\ninnodb_fast_shutdown = 0\nperformance_schema = 1\ninnodb_print_all_deadlocks = 1\ninnodb_sort_buffer_size = 4M \n\ninnodb_page_size = 16k\ngtid_mode=on\nenforce_gtid_consistency=on     \n\ntable_open_cache_instances=16\nbinlog_rows_query_log_events=1      \n\nslave_parallel_workers = 0          # \u591a\u7ebf\u7a0b\u590d\u5236\u7ebf\u7a0b\u6570\n#slave_parallel_type=LOGICAL_CLOCK      \n#binlog_group_commit_sync_delay = 500000  \n#binlog_group_commit_sync_no_delay_count =12  \n\n## pasword\ndefault_password_lifetime=0                     # 0\u5bc6\u7801\u6c38\u4e0d\u8fc7\u671f\uff0cN n\u5929\u8fc7\u671f\n\n&#91;mysqldump]\nquick\nmax_allowed_packet = 32M\n\n&#91;mysql]\nno-auto-rehash\nprompt=p@d>_\n\n&#91;mysqld_safe]\nopen-files-limit = 28192\n\n&#91;mysqlhotcopy]\ninteractive-timeout\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><br>1.5 \u521d\u59cb\u5316\u5e76\u83b7\u53d6\u4e34\u65f6\u5bc6\u7801<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u521d\u59cb\u5316<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/local\/mysql\/bin\/mysqld --defaults-file=\/data\/mysql\/conf\/my.cnf --user=mysql --initialize<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u83b7\u53d6\u4e34\u65f6\u5bc6\u7801<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>grep \"password\" \/data\/mysql\/log\/mysql.err <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/01\/image-9-1024x39.png\" alt=\"\" class=\"wp-image-171\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><br>1.6 \u542f\u52a8MySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u914d\u7f6e\u542f\u52a8\u811a\u672c<\/li>\n<\/ul>\n\n\n\n<pre id=\"CE5ig\" class=\"wp-block-code\"><code>cp \/usr\/local\/mysql\/support-files\/mysql.server \/etc\/init.d\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7f16\u8f91<code>\/etc\/init.d\/mysql.server<\/code>\uff0c\u4fee\u6539\u8fd9\u4e24\u884c\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"UiiN9\" class=\"wp-block-code\"><code>datadir=\/data\/mysql\/data\nconfdir=\/data\/mysql\/conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u627e\u5230<\/li>\n<\/ul>\n\n\n\n<pre id=\"mlyKH\" class=\"wp-block-code\"><code>$bindir\/mysqld_safe --datadir=\"$datadir\" --pid-file=\"$mysqld_pid_file_path\" $other_args &gt;\/dev\/null &amp;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u7fd1ec9d\">\u4fee\u6539\u6210<\/p>\n\n\n\n<pre id=\"IU0VS\" class=\"wp-block-code\"><code>$bindir\/mysqld_safe --defaults-file=$confdir\/my.cnf --datadir=\"$datadir\" --pid-file=\"$mysqld_pid_file_path\" $other_args &gt;\/dev\/null &amp;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u627e\u5230<\/li>\n<\/ul>\n\n\n\n<pre id=\"xtDyp\" class=\"wp-block-code\"><code>      --datadir=*)  datadir=`echo \"$arg\" | sed -e 's\/^&#91;^=]*=\/\/'`<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u2e07e46c\">\u4fee\u6539\u6210<\/p>\n\n\n\n<pre id=\"zY6MK\" class=\"wp-block-code\"><code>      --datadir=*)  datadir=\"\/data\/mysql\/data\/\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u91cd\u65b0\u52a0\u8f7d\u670d\u52a1\u914d\u7f6e<\/li>\n<\/ul>\n\n\n\n<pre id=\"chpCo\" class=\"wp-block-code\"><code>systemctl daemon-reload<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u542f\u52a8MySQL<\/li>\n<\/ul>\n\n\n\n<pre id=\"CwH66\" class=\"wp-block-code\"><code>\/etc\/init.d\/mysql.server start<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Mhl7K\">1.7 \u589e\u52a0\u73af\u5883\u53d8\u91cf<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7f16\u8f91<code>\/etc\/profile<\/code>\u6587\u4ef6\uff0c\u52a0\u5165\u5982\u4e0b\u5185\u5bb9\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"CGsNg\" class=\"wp-block-code\"><code>MYSQL_HOME=\/usr\/local\/mysql\nPATH=$PATH:$MYSQL_HOME\/bin\nexport PATH MYSQL_HOME<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u91cd\u65b0\u52a0\u8f7d\u914d\u7f6e<\/li>\n<\/ul>\n\n\n\n<pre id=\"uv5L8\" class=\"wp-block-code\"><code>source \/etc\/profile<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"iZLzb\">1.8 \u767b\u5f55MySQL\u5e76\u4fee\u6539\u5bc6\u7801<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u901a\u8fc7\u4e34\u65f6\u5bc6\u7801\u8fdb\u5165MySQL<\/li>\n<\/ul>\n\n\n\n<pre id=\"pNhCX\" class=\"wp-block-code\"><code>mysql -uroot -p'8Vi9KP\/-Zi8o'<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4fee\u6539\u5bc6\u7801<\/li>\n<\/ul>\n\n\n\n<pre id=\"noi1F\" class=\"wp-block-code\"><code>alter user user() identified by \"Passw0rd123\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u7581d124\">\u6ce8\u610f\uff1a\u5982\u679c\u9047\u5230\u5982\u4e0b\u62a5\u9519\uff1a<code>mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory<\/code><br>\u89e3\u51b3\u65b9\u6848\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>sudo apt-get update<\/code><\/li>\n\n\n\n<li><code>sudo apt-get install libtinfo5<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"yh15o\">1.9 \u7528\u65b0\u5bc6\u7801\u767b\u5f55MySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f7f\u7528\u4fee\u6539\u540e\u7684\u5bc6\u7801\u767b\u5f55MySQL\uff0c\u5219\u53ef\u4ee5\u6b63\u5e38\u4f7f\u7528MySQL\u4e86<\/li>\n<\/ul>\n\n\n\n<pre id=\"gGNtq\" class=\"wp-block-code\"><code>mysql -uroot -p'Passw0rd123'<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MBwTl\">1.10 \u5173\u95edMySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5982\u679c\u9700\u8981\u5173\u95edMySQL\uff0c\u53ef\u6267\u884c<\/li>\n<\/ul>\n\n\n\n<pre id=\"MXNxp\" class=\"wp-block-code\"><code>\/etc\/init.d\/mysql.server stop<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">2 \u4f7f\u7528Shell\u7f16\u5199\u81ea\u52a8\u90e8\u7f72MySQL\u811a\u672c<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Z8afC\">2.1 \u51c6\u5907<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5efa\u811a\u672c\u90e8\u7f72\u76ee\u5f55<\/li>\n<\/ul>\n\n\n\n<pre id=\"ruOni\" class=\"wp-block-code\"><code>mkdir -p \/data\/script\/install_mysql8<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u518d\u628a\u4e00\u4e9b\u6587\u4ef6\u590d\u5236\u8fc7\u6765<\/li>\n<\/ul>\n\n\n\n<pre id=\"ygrkE\" class=\"wp-block-code\"><code>cp \/data\/mysql\/conf\/my.cnf \/data\/script\/install_mysql8\ncp \/usr\/src\/mysql-8.0.25-linux-glibc2.12-x86_64.tar \/data\/script\/install_mysql8\ncp \/etc\/init.d\/mysql.server \/data\/script\/install_mysql8<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7136\u540e\u628a\u4e4b\u524d\u5b89\u88c5\u7684MySQL\u7ed9\u6e05\u7a7a\u6389<\/li>\n<\/ul>\n\n\n\n<pre id=\"CzWjX\" class=\"wp-block-code\"><code>\/etc\/init.d\/mysql.server stop\nrm \/usr\/local\/mysql\/ -rf\nrm \/data\/mysql -rf\nrm \/etc\/init.d\/mysql.server -rf\nuserdel -r mysql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5728<code>\/etc\/profile<\/code>\u4e2d\u53bb\u6389\u589e\u52a0\u7684\u73af\u5883\u53d8\u91cf<\/li>\n<\/ul>\n\n\n\n<pre id=\"W5eju\" class=\"wp-block-code\"><code>MYSQL_HOME=\/usr\/local\/mysql\nPATH=$PATH:$MYSQL_HOME\/bin\nexport PATH MYSQL_HOME<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u91cd\u65b0\u52a0\u8f7d\u914d\u7f6e<\/li>\n<\/ul>\n\n\n\n<pre id=\"Hli6L\" class=\"wp-block-code\"><code>source \/etc\/profile<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"xIDFK\">2.2 \u7f16\u8f91\u811a\u672c<\/h2>\n\n\n\n<pre id=\"UBTzr\" class=\"wp-block-code\"><code># \u8fdb\u5165\u811a\u672c\u6587\u4ef6\u5939\ncd \/data\/script\/install_mysql8\n# \u521b\u5efa\u5e76\u7f16\u8f91MySQL8\u5b89\u88c5\u811a\u672c\nvim install_mysql.sh<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ue944bc78\"><code>install_mysql.sh<\/code>\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre id=\"hwBlN\" class=\"wp-block-code\"><code>#!\/bin\/bash\n\n# \u89e3\u538b\nif &#91;  -d \"\/usr\/local\/mysql\" ];then\n  echo \"\/usr\/local\/mysql\u6587\u4ef6\u5939\u5df2\u7ecf\u5b58\u5728,\u8bf7\u786e\u5b9a\u662f\u5426\u5b89\u88c5\u4e86MySQL\"\n  exit\nfi\necho \"\u6b63\u5728\u89e3\u538b\u538b\u7f29\u5305\"\ntar xf mysql-8.0.25-linux-glibc2.12-x86_64.tar\nmv mysql-8.0.25-linux-glibc2.12-x86_64 \/usr\/local\/mysql\necho \"\u538b\u7f29\u5305\u89e3\u538b\u5b8c\u6bd5\"\n\n# \u521b\u5efaMySQL\u76f8\u5173\u76ee\u5f55\nif &#91; -d \"\/data\/mysql\/\" ];then\n  echo \"\/data\/mysql\/\u6587\u4ef6\u5939\u5df2\u7ecf\u5b58\u5728,\u8bf7\u786e\u5b9a\u662f\u5426\u5b89\u88c5\u4e86MySQL\"\n  exit\nfi\nmkdir \/data\/mysql\/{binlog,data,log,tmpdir,conf} -p\n\n\n\n\n# \u5224\u65ad\u662f\u5426\u6709MySQL\u8fdb\u7a0b\nmysql_pid=`ps -ef |grep mysqld |wc -l`\n\n\nif &#91; $mysql_pid -eq 1 ];then\n     echo \"\u6ca1\u6709MySQL\u8fdb\u7a0b\u5728\u8fd0\u884c\"\nelse\n    echo \"\u6709MySQL\u8fdb\u7a0b\u5728\u8fd0\u884c\uff0c\u8bf7\u68c0\u67e5\"\n    exit\nfi\n\n# \u521b\u5efaMySQL\u7528\u6237\nmysql_user=`cat \/etc\/passwd |grep -w mysql|wc -l`\n\nif &#91; $mysql_user -eq 1 ];then\n\n    echo \"MySQL\u7528\u6237\u5df2\u7ecf\u5b58\u5728\"\n\nelse\n\n    echo -e \"MySQL\u7528\u6237\u4e0d\u5b58\u5728\uff0c\u5f00\u59cb\u6dfb\u52a0MySQL\u7528\u6237\"\n    groupadd mysql\n    useradd -g mysql mysql\n    echo -e \"\u6dfb\u52a0MySQL\u7528\u6237\u6210\u529f\"\n\nfi\n\n# \u4fee\u6539\u6743\u9650\nchown -R mysql:mysql \/data\/mysql\/\nchown -R mysql:mysql \/usr\/local\/mysql\n\n# \u589e\u52a0\u914d\u7f6e\u6587\u4ef6\ncp .\/my.cnf \/data\/mysql\/conf\/\n\n# \u521d\u59cb\u5316\necho -e \"\u5f00\u59cb\u521d\u59cb\u5316\"\n\/usr\/local\/mysql\/bin\/mysqld --defaults-file=\/data\/mysql\/conf\/my.cnf --user=mysql --initialize\n\n#\u5224\u65ad\u521d\u59cb\u5316\u662f\u5426\u6210\u529f\nmysql_init=`cat \/data\/mysql\/log\/mysql.err |grep -i \"root@localhost:\"|wc -l`\nif &#91; $mysql_init -eq 1 ];then\n  echo \"mysql \u521d\u59cb\u5316\u6210\u529f\"\nelse\n  echo \"mysql \u521d\u59cb\u5316\u5931\u8d25\"\n  exit\nfi\n\n# \u83b7\u53d6\u4e34\u65f6\u5bc6\u7801\ntemp_pwd=$(grep 'temporary password' \/data\/mysql\/log\/mysql.err)\npwd=${temp_pwd##* }\necho \"\u4e34\u65f6\u5bc6\u7801\u662f\uff1a${pwd}\"\n\n# \u914d\u7f6e\u542f\u52a8\u811a\u672c\nif &#91; ! -f \"\/etc\/init.d\/mysql.server\" ];then\n  cp mysql.server \/etc\/init.d\/ -rf\n  chmod 700 \/etc\/init.d\/mysql.server\nfi\necho \"\u914d\u7f6e\u542f\u52a8\u811a\u672c\u5b8c\u6210\"\n\n# \u542f\u52a8MySQL\n\/etc\/init.d\/mysql.server start\necho \"\u542f\u52a8MySQL\u5b8c\u6210\"\n\n#\u589e\u52a0\u73af\u5883\u53d8\u91cf\nmysql_path=`grep 'export PATH=$PATH:\/usr\/local\/mysql\/bin' \/etc\/profile|wc -l`\nif &#91; $mysql_path -eq 0 ];then\n    echo 'export PATH=$PATH:\/usr\/local\/mysql\/bin' &gt;&gt; \/etc\/profile\n    source \/etc\/profile\nfi\necho \"\u589e\u52a0\u73af\u5883\u53d8\u91cf\u5b8c\u6210\"\n\n#\u901a\u8fc7\u4e34\u65f6\u5bc6\u7801\u767b\u5f55MySQL\uff0c\u5e76\u4fee\u6539\u5bc6\u7801\nmysql -uroot -p${pwd} --connect-expired-password -e \"alter user user() identified by 'martin';\"\necho \"\u4fee\u6539\u5bc6\u7801\u5b8c\u6210\"\n\necho \"MySQL 8.0.25 \u5b89\u88c5\u5b8c\u6210\"\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"dBKlw\">2.3 \u8fd0\u884c\u811a\u672c<\/h2>\n\n\n\n<pre id=\"yJU8Z\" class=\"wp-block-code\"><code># \u8d4b\u4e88\u6267\u884c\u6743\u9650\nchmod +x install_mysql.sh\n# \u6267\u884c\u811a\u672c\n.\/install_mysql.sh<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"t79MJ\">3 \u5c06MySQL\u90e8\u7f72\u5230Docker\u4e0a<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"JvVTX\">3.1 Docker\u90e8\u7f72<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b89\u88c5Docker<\/li>\n<\/ul>\n\n\n\n<pre id=\"nZMc7\" class=\"wp-block-code\"><code># \u4e0b\u8f7dcurl\u5de5\u5177\nsudo apt install curl\n\n# \u5b89\u88c5\u65b9\u5f0f1\n# \u5b89\u88c5docker\ncurl -fsSL https:\/\/get.docker.com | bash -s docker --mirror Aliyun\n\n# \u5b89\u88c5\u65b9\u5f0f2\n# \u4e0b\u8f7d\u5b89\u88c5\u811a\u672c\ncurl -fsSL https:\/\/get.docker.com -o get-docker.sh\n# \u6267\u884c\u5b89\u88c5\u811a\u672c\nsudo sh .\/get-docker.sh<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770bdocker\u7248\u672c<\/li>\n<\/ul>\n\n\n\n<pre id=\"KOrZb\" class=\"wp-block-code\"><code>docker version<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u78f2a5e1\"><img decoding=\"async\" src=\"https:\/\/i-blog.csdnimg.cn\/direct\/2c00d620070240a89d860ae2e1021870.png\" width=\"574\"><br>\u51fa\u73b0\u4e0a\u56fe\uff0c\u8868\u793adocker\u5b89\u88c5\u6210\u529f\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8fd0\u884cDocker<\/li>\n<\/ul>\n\n\n\n<pre id=\"yOdqr\" class=\"wp-block-code\"><code>systemctl start docker<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"q6xCj\">3.2 \u62c9\u53d6MySQL\u955c\u50cf<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770b\u53ef\u7528\u7684MySQL\u7248\u672c<\/li>\n<\/ul>\n\n\n\n<pre id=\"GmjqP\" class=\"wp-block-code\"><code>docker search mysql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u62c9\u53d6\u6700\u65b0\u7248\u672c\u7684MySQL\u955c\u50cf<\/li>\n<\/ul>\n\n\n\n<pre id=\"I1ZwU\" class=\"wp-block-code\"><code>docker pull mysql:latest<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u62c9\u53d6\u6307\u5b9a\u7248\u672c8.0.25 MySQL\u7684\u955c\u50cf<\/li>\n<\/ul>\n\n\n\n<pre id=\"iTiUr\" class=\"wp-block-code\"><code>docker pull mysql:8.0.25<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770b\u672c\u5730\u955c\u50cf<\/li>\n<\/ul>\n\n\n\n<pre id=\"fjYzQ\" class=\"wp-block-code\"><code>docker images<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u955c\u50cf<\/li>\n<\/ul>\n\n\n\n<pre id=\"mjcfP\" class=\"wp-block-code\"><code>docker image rm cdf3aa69f5f0<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mEyAr\">3.3 \u8fd0\u884c\u5bb9\u5668<\/h2>\n\n\n\n<pre id=\"u6JRw\" class=\"wp-block-code\"><code>docker run  --name mysql-test -p 3316:3306 -e MYSQL_ROOT_PASSWORD=Passw0rd123 mysql:8.0.25<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770bMySQL\u662f\u5426\u8fd0\u884c<\/li>\n<\/ul>\n\n\n\n<pre id=\"Jo3U9\" class=\"wp-block-code\"><code>docker ps<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"GPNDC\">3.4 \u767b\u5f55MySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u767b\u5f55Docker\u8fd0\u884c\u7684MySQL<\/li>\n<\/ul>\n\n\n\n<pre id=\"djnCN\" class=\"wp-block-code\"><code>mysql -h 127.0.0.1 -P 3316 -uroot -p<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"j4hDS\">3.5 \u5176\u4ed6\u64cd\u4f5c<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>kill\u6389MySQL<\/li>\n<\/ul>\n\n\n\n<pre id=\"NzWea\" class=\"wp-block-code\"><code>docker kill 26e553587b34<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5220\u9664\u8fdb\u7a0b<\/li>\n<\/ul>\n\n\n\n<pre id=\"Hd3KE\" class=\"wp-block-code\"><code>docker rm 26e553587b34<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u505c\u6b62\u5bb9\u5668<\/li>\n<\/ul>\n\n\n\n<pre id=\"p9bRo\" class=\"wp-block-code\"><code>docker stop \u5bb9\u5668ID|\u5bb9\u5668\u540d<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u542f\u52a8\u5bb9\u5668<\/li>\n<\/ul>\n\n\n\n<pre id=\"QJQKk\" class=\"wp-block-code\"><code>docker start \u5bb9\u5668ID|\u5bb9\u5668\u540d<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u91cd\u542f\u5bb9\u5668<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>docker restart \u5bb9\u5668ID|\u5bb9\u5668\u540d<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1 Linux\u5feb\u901f\u5b89\u88c5MySQL8.0 1.1 \u5378\u8f7d\u539f\u6709\u7684MySQL \u901a\u8fc7\u4ee5\u4e0b\u6b65\u9aa4\uff0c\u627e\u51fa Linux \u7cfb\u7edf\u4e0a\u5df2<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"https:\/\/yunyanglib.cn\/?p=170\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":173,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=170"}],"version-history":[{"count":3,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/170\/revisions"}],"predecessor-version":[{"id":178,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/170\/revisions\/178"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/media\/173"}],"wp:attachment":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}