FreeBSD 11.0-RELEASE-p2
PostgreSQL 9.6.1
mysql Ver 14.14 Distrib 5.7.17, for FreeBSD11.0
On MySQL server I have a table with first field 'id' which is auto incremented and some other fields.
Some fields are readonly to my user and others are full access. Field 'id' is readonly to my user.
When I run the following INSERT command from the mysql client everything is OK.
INSERT INTO <table> (<field 1>, <field 2>, ..., <field n>) VALUES (<value 1>, <value 2>, ..., <value n>);
But when I run it from PostgreSQL client I receive the following error:
INFO: Successfully connected to MySQL database ... ERROR: failed to prepare the MySQL query: INSERT command denied to user 'user'@'x.x.x.x' for column 'id' in table 'table'
FreeBSD 11.0-RELEASE-p2 PostgreSQL 9.6.1 mysql Ver 14.14 Distrib 5.7.17, for FreeBSD11.0
On MySQL server I have a table with first field 'id' which is auto incremented and some other fields. Some fields are readonly to my user and others are full access. Field 'id' is readonly to my user.
When I run the following INSERT command from the mysql client everything is OK.
INSERT INTO <table> (<field 1>, <field 2>, ..., <field n>) VALUES (<value 1>, <value 2>, ..., <value n>);
But when I run it from PostgreSQL client I receive the following error:
INFO: Successfully connected to MySQL database ... ERROR: failed to prepare the MySQL query: INSERT command denied to user 'user'@'x.x.x.x' for column 'id' in table 'table'
Any ideas?