ketr64

sure. will do.

Hi Peter,

This is really strange. If I wouldn’t have the remote privilege to create a table then I would not be able to create a table from the WP server with mysql. Because when I use the script your plugin generate to create the table and execute it in mysql from that WP server it works. With the same user.

Here is the result of the show grants;:
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO nttyadmin@% WITH GRANT OPTION |

Is it the right setting?

Thanks

Rene

PS: I don’t see any additional error message on the page. What is at the bottom of the page is:
The following CREATE TABLE statement failed
CREATE TABLE TABLE2
(COL1 varchar(10) NULL
) ENGINE InnoDB DEFAULT CHARACTER SET utf8 COLLATE=utf8_general_ci;

There you go.

One link shows that the db cnx works and the other the page with the error message.

https://ibb.co/RNjHXhQ

https://ibb.co/gzqqc89

Yes. I can. But how do I do that? Do you an email @ ? I don’t seem to be able to do it with a post.

Fyi I tried the same thing on a 5.7.30 MySQL db and I got the same error message.
I have one error in the top ‘banner’ which is ‘ERROR: CREATE TABLE failed’ and at the bottom of the page
The following CREATE TABLE statement failed
CREATE TABLE TEST1
(COL1 varchar(100) NULL
) ENGINE InnoDB DEFAULT CHARACTER SET utf8 COLLATE=utf8_general_ci;

I am running WP v5.4.2 and my environment is on AWS Lightsail.

To create the table I used the Data Explorer page. I entered my information, saved the design and then used the button ‘create table’. So I did not ‘touch’ the script the plugin submits.
I have to say that my MySQL db is version 8.0.20 on AWS Lightsail. Maybe something to consider.