Alarm information: (1142, u"SELECT command denied to user 'stat'@'124.64.123.253' for table 'user'")
Note: 1: The database connected by conn in the first line is the database used in the second box.
I feel like the third box appears out of thin air....
2: In navicat This sql can be run
Masters, please take a look and give me some keywords. I can search it myself!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
The error message prompts that the account 'stat' does not have select permission to access the database table remotely (ip:xxx.xxx.xxx.xxx). Check the db account permission settings yourself. Note that the account permissions not only refer to the account name, but also the IP matching.
Cross-database or cross-DB? A logical database server can provide multiple databases, and these databases are all reachable with one database connection. Just like a mysql server can have multiple schemas, the tables under these schemas can be accessed through schema_name.table_name and do not necessarily have to be the current schema