search

Home  >  Q&A  >  body text

javascript - mysql kuaku query

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!

高洛峰高洛峰2782 days ago301

reply all(1)I'll reply

  • PHP中文网

    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

    reply
    0
  • Cancelreply