搜索到
128
篇与
的结果
-
Ubuntu 开启密钥远程登陆 可用于 vscode remote 免密登录 1. 生成本地 SSH 密钥对在本地机器上生成 SSH 密钥对。打开终端或命令提示符，运行以下命令：ssh-keygen -t rsa -b 4096如下图询问保存路径，手动选择 如下图询问密码，如果要 vscode 免密登录则不能设置密码2. 将公钥添加到远程服务器将生成的公钥 (id_rsa.pub) 添加到远程服务器的 ~/.ssh/authorized_keys 文件中。可以使用以下命令：ssh-copy-id -i ~/.ssh/id_rsa.pub username@remote_host如果 ssh-copy-id 命令不可用，可以手动将公钥内容复制到远程服务器的 ~/.ssh/authorized_keys 文件中。将文件复制到 ~/.ssh 中, 然后使用如下命令追加cat ./.ssh/id_rsa.pub >> ./.ssh/authorized_keyschmod 600 ~/.ssh/authorized_keyscat /path/to/id_rsa.pub >> ~/.ssh/authorized_keys：将公钥内容追加到 authorized_keys 文件。chmod 600 ~/.ssh/authorized_keys：确保文件权限为 600，只有当前用户可以读写。确保 ~/.ssh 和 ~/.ssh/authorized_keys 的权限正确：chmod 700 ~/.ssh chmod 600 ~/.ssh/authorized_keys配置 ssh 允许密钥认证编辑 SSH 配置文件vim /etc/ssh/sshd_config确保远程服务器的 SSH 配置文件 /etc/ssh/sshd_config 中启用了密钥认证：PubkeyAuthentication yes AuthorizedKeysFile .ssh/authorized_keys重启 SSHsudo systemctl restart ssh -
-
-
MySQL | 设置允许 root 远程 访问 连接上 MySQLsudo mysql -u root -p修改配置先使用 mysql 数据库USE mysql;修改 root 用户的主机名，允许从任何 IP 连接ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; CREATE USER 'root'@'%' IDENTIFIED BY 'root'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;刷新权限FLUSH PRIVILEGES;退出 MySQLEXIT;重启 MySQL 服务重启 MySQL 服务以使配置生效：sudo systemctl restart mysql配置防火墙（如果启用）如果你的服务器启用了防火墙，需要允许 MySQL 的默认端口（3306）通过防火墙：sudo ufw allow 3306/tcp sudo ufw reloadAll done, enjoy it!
-
Ubuntu | Ubuntu22.04 安装 MySQL5.7 环境如下添加 MySQL 源sudo vim /etc/apt/sources.list.d/mysql.list添加如下内容，deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-apt-config deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7 deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-tools deb-src http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7更新，sudo apt update执行过程中可能会出现如下错误，y@y:~$ sudo apt update Hit:1 http://archive.ubuntu.com/ubuntu focal InRelease Hit:2 http://archive.ubuntu.com/ubuntu focal-updates InRelease Hit:3 http://archive.ubuntu.com/ubuntu focal-backports InRelease Get:4 http://repo.mysql.com/apt/ubuntu bionic InRelease [20.0 kB] Hit:5 http://archive.ubuntu.com/ubuntu focal-security InRelease Err:4 http://repo.mysql.com/apt/ubuntu bionic InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY B7B3B788A8D3785C Reading package lists... Done W: GPG error: http://repo.mysql.com/apt/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY B7B3B788A8D3785C E: The repository 'http://repo.mysql.com/apt/ubuntu bionic InRelease' is not signed. N: Updating from such a repository can't be done securely, and is therefore disabled by default. N: See apt-secure(8) manpage for repository creation and user configuration details.执行如下命令即可，B7B3B788A8D3785C根据实际情况替换。sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C接着再重新执行更新，sudo apt update安装 MySQL查看支持的 MySQL 版本sudo apt-cache policy mysql-servery@y:~$ sudo apt-cache policy mysql-server mysql-server: Installed: (none) Candidate: 8.0.40-0ubuntu0.20.04.1 Version table: 8.0.40-0ubuntu0.20.04.1 500 500 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages 500 http://archive.ubuntu.com/ubuntu focal-security/main amd64 Packages 8.0.19-0ubuntu5 500 500 http://archive.ubuntu.com/ubuntu focal/main amd64 Packages 5.7.42-1ubuntu18.04 500 500 http://repo.mysql.com/apt/ubuntu bionic/mysql-5.7 amd64 Packages可以看到有 5.7.40-1ubuntu18.04，接近成功了安装 MySQL 5.7 版本客户端和服务端，版本信息根据上面的输出自行修改。安装客户端如无需安装 mysql-client 服务，执行安装 mysql-server 服务，可能会报如下错误。只需要手动安装 mysql-community-server 即可。sudo apt install mysql-community-server=5.7.42-1ubuntu18.04sudo apt install mysql-client=5.7.42-1ubuntu18.04安装服务端（安装服务端的过程中 会让 输入 MySQL 的密码）sudo apt install mysql-server=5.7.42-1ubuntu18.04配置 MySQL 监听地址及其端口sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf查看文件内容，并修改如下bind-address 我装好默认是127.0.0.1，需要修改port 我装好没有，需要自行添加bind-address = 0.0.0.0 port = 3306All done, enjoy it!
