[Gambas-user] Problem with MySQL LONGTEXT field type

[werner 007]

Ciao Luigi

I believe it comes from permissions.
Try this: Give all permissions to user Test for schema mysql and schema
Test.
That should work.

Regards, Werner


>From the mySQL Help:

There are two sets of permissions for stored functions,

   1. permissions to create and manage stored functions
   2. permissions to use functions.

To create a function in a database, the user must have the CREATE ROUTINE
privilege.
To use a function, the caller must have the EXECUTE privilege for the
particular database.
To change an existing function, the user must have the ALTER ROUTINE
privilege.
Permissions can be granted globally in the mysql.user table.
Permissions can also be granted at the database level in the mysql.db table.
Permissions can be granted for a specific routine in the mysql.procs_priv
table.

-- 
View this message in context: http://www.nabble.com/Problem-with-MySQL-LONGTEXT-field-type-tp20999713p21255943.html
Sent from the gambas-user mailing list archive at Nabble.com.