Windows 使用VSCode远程连接到Linux开发调试MySQL

来源：这里教程网时间：2026-03-01 16:14:31 作者：

Windows 使用VSCode远程连接到Linux开发调试MySQL1.Linux系统上安装相关开发工具[root@gbase yum.repos.d]# yum install gdb-gdbserver[root@gbase yum.repos.d]# yum install gdb[root@gbase yum.repos.d]# yum install gcc[root@gbase yum.repos.d]# yum install cmake2.配置VSCode可以免密登录Linux2.1在Windows上生成密钥C:\Users\Administrator>ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (C:\Users\Administrator\.ssh\id_rsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in id_rsa.Your public key has been saved in id_ras.pub.The key fingerprint is:SHA256:2ya72QX0JQBxKTLM+3S1H3FFYnHHrve1t0cSbqXJiqI mysql@gbaseThe key's randomart image is:+---[RSA 2048]----+| o ooo. ++*|| = .......o+|| + ......+ || . .....oo o|| oS.. .+ B || .o . X +|| o o..o ++|| .*... .+|| E.+o. .+|+----[SHA256]-----+2.2 在Linux服务器上生成密钥[root@gbase ~]# su - mysqlLast login: Sun Sep 26 09:24:11 CST 2021 on pts/5[mysql@gbase ~]$ pwd/home/mysql[mysql@gbase ~]$ ls -lrttotal 0drwxrwxr-x. 2 mysql mysql 6 Sep 24 16:19 perl5[mysql@gbase ~]$ cd ~/.ssh-bash: cd: /home/mysql/.ssh: No such file or directory[mysql@gbase ~]$ mkdir ~/.ssh[mysql@gbase ~]$ cd ~/.ssh[mysql@gbase .ssh]$ pwd/home/mysql/.ssh[mysql@gbase .ssh]$ ls -lrttotal 0增加root权限：visudo 进入文本后找到root ALL=(ALL) ALL，另起一行，加入admin ALL=(ALL) NOPASSWD:ALL su admin 切换到新用户再使用sudo su -切换回root，说明权限正常，进行下一步[root@gbase ~]# visudo## Allow root to run any commands anywhereroot ALL=(ALL) ALLmysql ALL=(ALL) NOPASSWD:ALL[mysql@gbase ~]$ sudo su -Last login: Sun Sep 26 11:41:38 CST 2021 on pts/1[root@gbase ~]# su - mysqlLast login: Sun Sep 26 14:20:50 CST 2021 from 192.168.1.12 on pts/3[mysql@gbase ~]$2.3将windows中生成的公钥上传到/home/mysql/.ssh/目录C:\Users\Administrator>scp C:\Users\Administrator\.ssh\id_rsa.pud mysql@192.168.1.249:/home/mysql/.ssh/authorized_keys[mysql@gbase ~]$ chmod 700 /home/mysql/.ssh[mysql@gbase ~]$ chmod 600 /home/mysql/.ssh/authorized_keys2.4切换到root，关闭root登录 sudo su - vim /etc/ssh/sshd_config 找到#PermitRootLogin yes去掉#把yes改为no systemctl restart sshd 重启服务并生效[root@gbase .ssh]# vim /etc/ssh/sshd_config# $OpenBSD: sshd_config,v 1.100 2016/08/15 12:32:04 naddy Exp $# This is the sshd server system-wide configuration file. See# sshd_config(5) for more information.# This sshd was compiled with PATH=/usr/local/bin:/usr/bin# The strategy used for options in the default sshd_config shipped with# OpenSSH is to specify options with their default value where# possible, but leave them commented. Uncommented options override the# default value.# If you want to change the port on a SELinux system, you have to tell# SELinux about this change.# semanage port -a -t ssh_port_t -p tcp #PORTNUMBER#Port 22#AddressFamily any#ListenAddress 0.0.0.0#ListenAddress ::HostKey /etc/ssh/ssh_host_rsa_key#HostKey /etc/ssh/ssh_host_dsa_keyHostKey /etc/ssh/ssh_host_ecdsa_keyHostKey /etc/ssh/ssh_host_ed25519_key# Ciphers and keying#RekeyLimit default none# Logging#SyslogFacility AUTHSyslogFacility AUTHPRIV#LogLevel INFO# Authentication:#LoginGraceTime 2mPermitRootLogin no #改成no#StrictModes yes#MaxAuthTries 6#MaxSessions 10RSAAuthentication yes #要开启PubkeyAuthentication yes #要开启# The default is to check both .ssh/authorized_keys and .ssh/authorized_keys2# but this is overridden so installations will only check .ssh/authorized_keysAuthorizedKeysFile .ssh/authorized_keys[root@gbase ~]# service sshd restartRedirecting to /bin/systemctl restart sshd.service在windows中测试ssh登录C:\Users\Administrator>ssh mysql@192.168.1.249Last login: Sun Sep 26 14:22:54 2021]ysql@gbase:~[mysql@gbase ~]$ pwd/home/mysql2.5 配置vscode通过remote ssh连接Linux的配置文件C:\Users\Administrator\.ssh\configHost 192.168.1.249HostName 192.168.1.249User rootIdentityFile "D:\ssh\vscode"2.6 通过vscode远程连接Linux服务器出现以下错误> Waiting for client to transfer server archive...> Waiting for /home/mysql/.vscode-server/bin/7f6ab5485bbc008386c4386d08766667e1552> 44e/vscode-scp-done.flag and vscode-server.tar.gz to exist>[12:31:20.267] Got request to download on client for {"platform":"linux","arch":"x64","destFolder":"/home/mysql/.vscode-server/bin/7f6ab5485bbc008386c4386d08766667e155244e"}[12:31:20.268] Downloading VS Code server locally...[12:31:20.420] Resolver error: Error: Running the contributed command: '_workbench.downloadResource' failed.[mysql@gbase /]$ cd /home/mysql[mysql@gbase ~]$ ls -lrt .vscode-servertotal 0drwxrwxr-x. 3 mysql mysql 54 Sep 26 09:46 bin[mysql@gbase ~]$ cd .vscode-server[mysql@gbase .vscode-server]$ lsbin[mysql@gbase .vscode-server]$ cd bin[mysql@gbase bin]$ ls7f6ab5485bbc008386c4386d08766667e155244e[mysql@gbase bin]$ cd 7f6ab5485bbc008386c4386d08766667e155244e/[mysql@gbase 7f6ab5485bbc008386c4386d08766667e155244e]$ lsvscode-remote-lock.mysql.7f6ab5485bbc008386c4386d08766667e155244e vscode-server.tar.gz[mysql@gbase 7f6ab5485bbc008386c4386d08766667e155244e]$ ls -lrttotal 0-rw-rw-r--. 1 mysql mysql 0 Sep 26 11:37 vscode-remote-lock.mysql.7f6ab5485bbc008386c4386d08766667e155244e-rw-rw-r--. 1 mysql mysql 0 Sep 26 11:37 vscode-server.tar.gz上面的7f开头的文件夹称为Commit Id，现在利用Commit ID下载远程连接需要的文件。对于Stabe Version（在VS Code报错的的窗口中Ctrl+F搜索stable，有则为Stable Version）的Remote SSH插件，如下图，在“输出”窗口中Ctrl+F搜索“stable”。[12:31:14.904] Using commit id "7f6ab5485bbc008386c4386d08766667e155244e" and quality "stable" for server然后使用这个链接：https://update.code.visualstudio.com/commit:$COMMIT_ID/server-linux-x64/stable下载所需文件，注意链接中的$COMMIT_ID这几个字符（注意$不要忘记）需要换成自己的，比如我的是 7f6ab5485bbc008386c4386d08766667e155244e，那么此时我通过https://update.code.visualstudio.com/commit:7f6ab5485bbc008386c4386d08766667e155244e/server-linux-x64/stable就可以下载到我需要的文件。对于Insider版本，通过https://update.code.visualstudio.com/commit:7f6ab5485bbc008386c4386d08766667e155244e/server-linux-x64/insider这个链接下载相应文件。下载完毕后，将下载的文件upload到Remote Server的~/.vscode-server/bin/xxx文件夹下（也可以在Remote Server上直接执行wget https://vscode.cdn.azure.cn/stable/7f6ab5485bbc008386c4386d08766667e155244e/vscode-server-linux-x64.tar.gz即可下载，这样就不用进行上传操作了），同时删除其他文件，最后再使用tar -xvf vscode-server-linux-x64.tar.gz --strip-components 1解压文件，sftp> put D:\ssh\vscode-server-linux-x64.tar.gzUploading vscode-server-linux-x64.tar.gz to /home/mysql/vscode-server-linux-x64.tar.gz100% 45296KB 45296KB/s 00:00:00D:/ssh/vscode-server-linux-x64.tar.gz: 46383314 bytes transferred in 0 seconds (45296 KB/s)[mysql@gbase 7f6ab5485bbc008386c4386d08766667e155244e]$ tar -xvf vscode-server-linux-x64.tar.gz --strip-components 1然后使用chmod +x node server.sh为node和server.sh添加可执行权限。[mysql@gbase 7f6ab5485bbc008386c4386d08766667e155244e]$ chmod +x node server.sh[mysql@gbase 7f6ab5485bbc008386c4386d08766667e155244e]$ ls -lrttotal 117512-rwxr-xr-x. 1 mysql mysql 222 Sep 22 20:00 server.sh-rw-r--r--. 1 mysql mysql 34147 Sep 22 20:00 product.json-rw-r--r--. 1 mysql mysql 1255 Sep 22 20:00 package.json-rw-r--r--. 1 mysql mysql 13380 Sep 22 20:00 LICENSE-rwxr-xr-x. 1 mysql mysql 73873984 Sep 22 20:02 nodedrwxr-xr-x. 3 mysql mysql 135 Sep 22 20:02 outdrwxr-xr-x. 3 mysql mysql 33 Sep 22 20:02 bindrwxr-xr-x. 32 mysql mysql 4096 Sep 22 20:02 extensionsdrwxr-xr-x. 78 mysql mysql 4096 Sep 22 20:02 node_modules-rw-rw-r--. 1 mysql mysql 0 Sep 26 11:37 vscode-remote-lock.mysql.7f6ab5485bbc008386c4386d08766667e155244e-rw-rw-r--. 1 mysql mysql 0 Sep 26 11:37 vscode-server.tar.gz-rw-rw-r--. 1 mysql mysql 46383314 Sep 26 11:57 vscode-server-linux-x64.tar.gz再次使用VS Code尝试链接，这一步会链接成功。3.vscode在远程远程服务器上依次安装 C/C++、CMake、CMake Tools插件在使用vscode 远程调试程序时出现以下信息:Updating C/C++ dependencies...Downloading package 'C/C++ language components (Linux / x86_64)' Failed. Retrying... Failed. Retrying... Failed. Retrying...Waiting 8 seconds... Failed. Retrying...Waiting 15 seconds... Failed. Retrying...Waiting 15 seconds... Failed. Retrying...Waiting 15 seconds... Failed. Retrying...Waiting 15 seconds... Failed. Retrying...Waiting 15 seconds... Failed. Retrying...Waiting 15 seconds... Failed to download https://go.microsoft.com/fwlink/?linkid=2170969Failed at stage: downloadPackagesError: getaddrinfo ENOTFOUND go.microsoft.comat GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)If you work in an offline environment or repeatedly see this error, try downloading a version of the extension with all the dependencies pre-included from https://github.com/microsoft/vscode-cpptools/releases, then use the "Install from VSIX" command in VS Code to install it. 安装 C/C++ language components插件失败我们只能手动安装打开网址https://go.microsoft.com/fwlink/?linkid=2170969下载bin_linupwdx.zip文件将bin_linux.zip文件解压cpptoolscpptools-srvLICENSE.txt将这三个文件拷贝到远程Linux服务器的/home/mysql/.vscode-server/extensions/ms-vscode.cpptools-1.6.0/bin目录中如果原先存在这个文件的话先将其备份。sftp> put F:\bin_linux\bin\*Uploading cpptools to /home/mysql/.vscode-server/extensions/ms-vscode.cpptools-1.6.0/bin/cpptools100% 19544KB 19544KB/s 00:00:00F:/bin_linux/bin/cpptools: 20014008 bytes transferred in 0 seconds (19544 KB/s)Uploading cpptools-srv to /home/mysql/.vscode-server/extensions/ms-vscode.cpptools-1.6.0/bin/cpptools-srv100% 11508KB 11508KB/s 00:00:00F:/bin_linux/bin/cpptools-srv: 11784664 bytes transferred in 0 seconds (11508 KB/s)Uploading LICENSE.txt to /home/mysql/.vscode-server/extensions/ms-vscode.cpptools-1.6.0/bin/LICENSE.txt100% 11KB 11KB/s 00:00:00F:/bin_linux/bin/LICENSE.txt: 11972 bytes transferred in 0 seconds (11 KB/s)但是没有用，仍然报错如是通过vsix来进行安装github上release好多个版本，我远程看代码的主机是redhat Linux系统，所有下载cpptools-linux.vsix。先删除我们上传到/home/mysql/.vscode-server/extensions/ms-vscode.cpptools-1.6.0/bin的三个文件[mysql@gbase bin]$ ls -lrttotal 31188-rw-rw-r--. 1 mysql mysql 11784664 Aug 23 22:29 cpptools-srv-rw-rw-r--. 1 mysql mysql 20014008 Aug 23 22:29 cpptools-rw-rw-r--. 1 mysql mysql 11972 Aug 23 22:34 LICENSE.txt-rw-rw-r--. 1 mysql mysql 582 Sep 26 12:05 common.json-rw-rw-r--. 1 mysql mysql 301 Sep 26 12:05 linux.clang.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 12:05 linux.clang.arm64.json-rw-rw-r--. 1 mysql mysql 300 Sep 26 12:05 linux.clang.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 12:05 linux.clang.x86.json-rw-rw-r--. 1 mysql mysql 301 Sep 26 12:05 linux.gcc.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 12:05 linux.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 302 Sep 26 12:05 linux.gcc.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 12:05 linux.gcc.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 12:05 macos.clang.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 12:05 macos.clang.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 12:05 macos.clang.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 12:05 macos.clang.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 12:05 macos.gcc.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 12:05 macos.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 12:05 macos.gcc.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 12:05 macos.gcc.x86.jsondrwxrwxr-x. 15 mysql mysql 145 Sep 26 12:05 messages-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.arm.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.x86.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.arm.json-rw-rw-r--. 1 mysql mysql 89 Sep 26 12:05 windows.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.x86.json-rw-rw-r--. 1 mysql mysql 299 Sep 26 12:05 windows.msvc.arm.json-rw-rw-r--. 1 mysql mysql 324 Sep 26 12:05 windows.msvc.arm64.json-rw-rw-r--. 1 mysql mysql 383 Sep 26 12:05 windows.msvc.x64.json-rw-rw-r--. 1 mysql mysql 359 Sep 26 12:05 windows.msvc.x86.json[mysql@gbase bin]$ rm -rf cpptools*[mysql@gbase bin]$ rm -rf LICENSE.txt[mysql@gbase bin]$ ls -lrttotal 116-rw-rw-r--. 1 mysql mysql 582 Sep 26 12:05 common.json-rw-rw-r--. 1 mysql mysql 301 Sep 26 12:05 linux.clang.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 12:05 linux.clang.arm64.json-rw-rw-r--. 1 mysql mysql 300 Sep 26 12:05 linux.clang.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 12:05 linux.clang.x86.json-rw-rw-r--. 1 mysql mysql 301 Sep 26 12:05 linux.gcc.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 12:05 linux.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 302 Sep 26 12:05 linux.gcc.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 12:05 linux.gcc.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 12:05 macos.clang.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 12:05 macos.clang.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 12:05 macos.clang.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 12:05 macos.clang.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 12:05 macos.gcc.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 12:05 macos.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 12:05 macos.gcc.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 12:05 macos.gcc.x86.jsondrwxrwxr-x. 15 mysql mysql 145 Sep 26 12:05 messages-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.arm.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.clang.x86.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.arm.json-rw-rw-r--. 1 mysql mysql 89 Sep 26 12:05 windows.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 12:05 windows.gcc.x86.json-rw-rw-r--. 1 mysql mysql 299 Sep 26 12:05 windows.msvc.arm.json-rw-rw-r--. 1 mysql mysql 324 Sep 26 12:05 windows.msvc.arm64.json-rw-rw-r--. 1 mysql mysql 383 Sep 26 12:05 windows.msvc.x64.json-rw-rw-r--. 1 mysql mysql 359 Sep 26 12:05 windows.msvc.x86.json通过vscode 从vsix来进行安装，选择本地目录D:\ssh\cpptools-linux.vsix文件 [mysql@gbase bin]$ ls -lrttotal 31188-rw-rw-r--. 1 mysql mysql 582 Sep 26 15:01 common.json-rw-rw-r--. 1 mysql mysql 20014008 Sep 26 15:01 cpptools-rw-rw-r--. 1 mysql mysql 11784664 Sep 26 15:01 cpptools-srv-rw-rw-r--. 1 mysql mysql 11972 Sep 26 15:01 LICENSE.txt-rw-rw-r--. 1 mysql mysql 301 Sep 26 15:01 linux.clang.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 15:01 linux.clang.arm64.json-rw-rw-r--. 1 mysql mysql 300 Sep 26 15:01 linux.clang.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 15:01 linux.clang.x86.json-rw-rw-r--. 1 mysql mysql 301 Sep 26 15:01 linux.gcc.arm.json-rw-rw-r--. 1 mysql mysql 310 Sep 26 15:01 linux.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 302 Sep 26 15:01 linux.gcc.x64.json-rw-rw-r--. 1 mysql mysql 291 Sep 26 15:01 linux.gcc.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 15:01 macos.clang.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 15:01 macos.clang.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 15:01 macos.clang.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 15:01 macos.clang.x86.json-rw-rw-r--. 1 mysql mysql 284 Sep 26 15:01 macos.gcc.arm.json-rw-rw-r--. 1 mysql mysql 293 Sep 26 15:01 macos.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 283 Sep 26 15:01 macos.gcc.x64.json-rw-rw-r--. 1 mysql mysql 274 Sep 26 15:01 macos.gcc.x86.jsondrwxrwxr-x. 15 mysql mysql 145 Sep 26 15:01 messages-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.clang.arm.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.clang.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.clang.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.clang.x86.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.gcc.arm.json-rw-rw-r--. 1 mysql mysql 89 Sep 26 15:01 windows.gcc.arm64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.gcc.x64.json-rw-rw-r--. 1 mysql mysql 87 Sep 26 15:01 windows.gcc.x86.json-rw-rw-r--. 1 mysql mysql 299 Sep 26 15:01 windows.msvc.arm.json-rw-rw-r--. 1 mysql mysql 324 Sep 26 15:01 windows.msvc.arm64.json-rw-rw-r--. 1 mysql mysql 383 Sep 26 15:01 windows.msvc.x64.json-rw-rw-r--. 1 mysql mysql 359 Sep 26 15:01 windows.msvc.x86.json重启vscdoe4.使用vscode远程编译Linux服务器的MySQL源码，mysql源码在/soft/mysql-5.7.26/目录这里需要配置Cmake 生成setting.json配置文件点击CMake Tool的设置按钮，再点击Extention Settings 这里选择Remote [SSH:192.168.1.249]，我这对于Build Directory选择使用默认配置，因为${workspaceFolder}就是/soft/mysql-5.7.26目录，所以$${workspaceFolder}/build也就是/soft/mysql-5.7.26/build目录所以Source Directory目录选择使用默认的$workspaceFolder}目录给Configure Args配置以下三个参数-DWITH_BOOST=/soft/mysql-5.7.26/boost/boost_1_59_0-DDOWNLOAD_BOOST=1-DWITH_DEBUG=1 选择编译器给CMake选择Debug模式然后进行编译编译完成后，在Linux服务器上初始化mysql数据库创建data,etc目录用来分别存放数据文件与配置文件my.cnf[mysql@gbase build]$ mkdir {data,etc}[mysql@gbase build]$ cd etc[mysql@gbase etc]$ vi my.cnf[mysqld]basedir=/soft/mysql-5.7.26/builddatadir=/soft/mysql-5.7.26/build/databind-address=0.0.0.0user=mysqlport=3306log-error=/soft/mysql-5.7.26/build/data/mysql.errpid-file=/soft/mysql-5.7.26/build/data/mysqld.pidsocket = /soft/mysql-5.7.26/build/data/mysql.sockcharacter-set-server=utf8mb4default-storage-engine=INNODBexplicit_defaults_for_timestamp = true[mysql@gbase build]$ sql/mysqld --defaults-file=etc/my.cnf --initialize-insecure[mysql@gbase build]$ cd data[mysql@gbase data]$ lsauto.cnf ib_buffer_pool ibdata1 ib_logfile0 ib_logfile1 mysql mysql.err performance_schema sys[mysql@gbase data]$ ls -lrttotal 110632-rw-r-----. 1 mysql mysql 50331648 Sep 26 15:43 ib_logfile1-rw-r-----. 1 mysql mysql 56 Sep 26 15:43 auto.cnf-rw-r-----. 1 mysql mysql 1046 Sep 26 15:43 mysql.errdrwxr-x---. 2 mysql mysql 8192 Sep 26 15:43 performance_schemadrwxr-x---. 2 mysql mysql 4096 Sep 26 15:43 mysqldrwxr-x---. 2 mysql mysql 8192 Sep 26 15:43 sys-rw-r-----. 1 mysql mysql 419 Sep 26 15:43 ib_buffer_pool-rw-r-----. 1 mysql mysql 50331648 Sep 26 15:43 ib_logfile0-rw-r-----. 1 mysql mysql 12582912 Sep 26 15:43 ibdata1[mysql@gbase data]$ more mysql.err2021-09-26T07:43:43.288066Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)2021-09-26T07:43:43.288312Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)2021-09-26T07:43:43.289227Z 0 [ERROR] Can't find error-message file '/soft/mysql-5.7.26/build/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.2021-09-26T07:43:46.058883Z 0 [Warning] InnoDB: New log files created, LSN=457902021-09-26T07:43:46.360628Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2021-09-26T07:43:46.558161Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7b190ba6-1e9d-11ec-93d5-005056a31fca.2021-09-26T07:43:46.567453Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2021-09-26T07:43:46.569018Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. [mysql@gbase mysql-5.7.26]$ gcc -v -E -x c++ -Using built-in specs.COLLECT_GCC=gccTarget: x86_64-redhat-linuxConfigured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-linker-build-id --with-linker-hash-style=gnu --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-initfini-array --disable-libgcj --with-isl=/builddir/build/BUILD/gcc-4.8.5-20150702/obj-x86_64-redhat-linux/isl-install --with-cloog=/builddir/build/BUILD/gcc-4.8.5-20150702/obj-x86_64-redhat-linux/cloog-install --enable-gnu-indirect-function --with-tune=generic --with-arch_32=x86-64 --build=x86_64-redhat-linuxThread model: posixgcc version 4.8.5 20150623 (Red Hat 4.8.5-39) (GCC)COLLECT_GCC_OPTIONS='-v' '-E' '-mtune=generic' '-march=x86-64'/usr/libexec/gcc/x86_64-redhat-linux/4.8.5/cc1plus -E -quiet -v -D_GNU_SOURCE - -mtune=generic -march=x86-64ignoring nonexistent directory "/usr/lib/gcc/x86_64-redhat-linux/4.8.5/include-fixed"ignoring nonexistent directory "/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../x86_64-redhat-linux/include"#include "..." search starts here:#include < ...> search starts here:/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/x86_64-redhat-linux/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/backward/usr/lib/gcc/x86_64-redhat-linux/4.8.5/include/usr/local/include/usr/include将下面的内容加入到c_cpp_properties.json中的includePath中/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/x86_64-redhat-linux/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../include/c++/4.8.5/backward/usr/lib/gcc/x86_64-redhat-linux/4.8.5/include/usr/local/include/usr/include 加入后错误信息消失