Ubuntu26.04在线安装MySQL升级软件列表sudoaptudpate升级内核和软件sudoapt-ydist-upgrade在线安装MySQLsudoapt-yinstallmysql-server修改mysql密码登录MySQLsudomysql-uroot修改MySQL密码-- 查看现有root用户SELECTuser,host,pluginFROMmysql.userWHEREuserroot;-- 修改rootlocalhost的认证方式为密码认证本案例使用ALTERUSERrootlocalhostIDENTIFIEDWITHcaching_sha2_passwordBYlihaozhe;FLUSHPRIVILEGES;-- 或者使用mysql_native_password兼容性更好ALTERUSERrootlocalhostIDENTIFIEDWITHmysql_native_passwordBYlihaozhe;FLUSHPRIVILEGES;设置MySQL远程访问登录MySQL后修改现有用户的hostUPDATEmysql.userSEThost%WHEREuserrootANDhostlocalhost;FLUSHPRIVILEGES;修改MySQL配置文件sudovim/etc/mysql/mysql.conf.d/mysqld.cnf找到并修改bind-address# 将这行bind-address127.0.0.1# 改为bind-address0.0.0.0# 或者注释掉这行#bind-address 127.0.0.1重启MySQL服务sudosystemctl restart mysql远程客户端测试mysql-h192.168.10.101-uroot-p