Mysql

开启 mysql 远程访问 确认端口是否对外开放，默认是不开放的 netstat -an | grep 3306 输出如下 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 修改配置文件（不同版本可能位置不同） /etc/mysql/mysql.conf.d/mysqld.cnf 注释掉 # bind-address = 127.0.0.1 为新增主键赋值 SET @mycnt = 0; UPDATE xxxxx SET RowNum=(@mycnt := @mycnt + 1) 使用 native_password 连接 ALTER USER 'user'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; flush privileges; 修改用户密码 ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password'; 使用默认密码修改数据库密码 查看默认用户密码 cd /etc/mysql sudo cat debian.cnf # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint password = G0Gis29yv0dtUhng socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = debian-sys-maint password = G0Gis29yv0dtUhng socket = /var/run/mysqld/mysqld.sock 使用默认用户登录 ...