问题
ayear@DESKTOP-GPCA3B0:~/AdonisJS$ node ace.js migration:run
[ error ] Host 'DESKTOP-GPCA3B0' is not allowed to connect to this MySQL server
at Packet.asError (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/packets/packet.js:728:17)
at ClientHandshake.execute (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/home/ayear/AdonisJS/node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:559:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
at Readable.push (node:internal/streams/readable:390:5)
因为用户 root 不允许主机 DESKTOP-GPCA3B0 访问。
解决方法
创建一个用户并允许任意地址访问 % 表示任意
adonis.* 表示数据库 adonis
MySQL 版本 8.0
mysql> CREATE USER 'myUserName'@'%' IDENTIFIED BY 'myPassword';
Query OK, 0 rows affected (0.03 sec)
mysql> GRANT ALL PRIVILEGES ON adonis.* TO 'myUserName'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)