I am new here at zymic and a novice with MySQL. When I attempt to create a new table in database with SQL Buddy I get the following error displayed in a pink box above the "CREATE A NEW TABLE" section:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') CHARSET latin1' at line 1"

In addition, when I attempt to add a field at the same time I get the following pop-up error:

"There was an error receiving data from the server."

So I've tried executing SQL statement directly from the "Query" input box. When I try to create a table with this:



I get the same pop-up window as before that reads:

"There was an error receiving data from the server."

It seems to me that my user account may not have CREATE privileges. But I know that I checked all the boxes when creating the user and I can see all privileges listed in the list of users. Additionally, when I try to create a table with the following:



I get this message in a pink box below the input box:

The following errors were reported:
A table must have at least 1 column

Any help would be VERY appreciated. Thank you.

You need to ensure you are using the correct syntax.

If that is still not working, try deleting and re-creating the database user and ensure you have full priviledges on the user.

I've tried that a number of times. I've created and deleted multiple databases and users with no luck.

Is there a way I can access my database via phpMyAdmin? Or even via a remote shell?

We removed PHPMyAdmin due to the resources it required and we do not offer shell accounts.