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!
PHP中文网2017-05-16 12:04:47
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