It looks like some of the new logic that was added recently may have lead to some problems. We are no longer able to add SQLForms due to the following error:

Some error(s) occurred:

• Databaselink does not have enough privileges (Needs ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, UPDATE)

I confirmed the database link user and password was correct. I also confirmed the privileges for this user. The existing SQLForms and SQLReports which use this link appear to be working fine.

William

mysql> SHOW GRANTS FOR CURRENT_USER();
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for jvgqtvro@localhost                                                                                                                                                                                     |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, EXECUTE ON *.* TO 'jvgqtvro'@'localhost' IDENTIFIED BY PASSWORD '*E24909AF8D94E418FF1C0F73D1093C4F274E891C'                                           |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `bonterrabuilders\_data`.* TO 'jvgqtvro'@'localhost' |
| GRANT ALL PRIVILEGES ON `bonterrabuilders_com`.* TO 'jvgqtvro'@'localhost'                                                                                                                                        |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.02 sec)

As you can see all the grants are there. I did some debugging and the @privileges array was empty after you gathered the grants for the user. Looks like a regex or split error. 

Yes, the backslash is coming through, apparently from mysql. Right now, it's showing 2 backslashes when I dump the @grants. I've added lines to the module to dump database name and the @grants list:

Databasename = bonterrabuilders_data

$VAR1 = [
          'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, EXECUTE ON *.* TO \'jvgqtvro\'@\'localhost\' IDENTIFIED BY PASSWORD \'*E24909AF8D94E418FF1C0F73D1093C4F274E891C\'',
          'GRANT ALL PRIVILEGES ON `bonterrabuilders_com`.* TO \'jvgqtvro\'@\'localhost\'',
          'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `bonterrabuilders\\_data`.* TO \'jvgqtvro\'@\'localhost\''
        ];
 

Here's what I get from the show grant command via mysql cmd-line tool:

As you can see, somewhere in the dbLink->db->buildArray methods, special chars are getting backslashed which is causing the backslash that mysql adds to get backslashed again. Is there a way we can tell the dbLink calls not to add more backslashes. We can add a backslash to the db name via following:

   $databaseName =~ s/_/\\_/g;

William 

Can you please post your DSN?

Without it we have no way to fix the bug.