phpmyAdmin error 1142

Our discussions on Web Hosting that will tell you everything you need to know. Find advice, questions and answers on the who's, what's, when's and where's of the Web Hosting world.
Post Reply
barnes
Newbie
Posts: 4
Joined: Sun Oct 01, 2017 9:28 am

Sat Oct 13, 2018 1:09 pm

Hello,

I can not create a table via phpAdmin with my mySQL credentials. (error 1142 - the create command is forbidden to the user ***)
So I can not import a database and therefore can not go back to an earlier version of my database. how can i solve this error? please help.


Thank you


User avatar
geniushost
Junior Member
Posts: 24
Joined: Mon Nov 13, 2017 1:34 pm

Wed Oct 24, 2018 12:43 pm

Hello,

table creation, is possible via phpmyadmin tool. However, this type of message may be related to a quota overflow on your database, for example a table with a size larger than 100MB. This quota is set up on most of shared hosting plans. I suggest you to contact the technical department so that a technician carries out a more in-depth analysis on that.
User avatar
Rs-Calvin
Junior Member
Posts: 12
Joined: Tue Oct 23, 2018 3:41 pm
Location: Melbourne
Contact:

Wed Oct 24, 2018 3:51 pm

Hello,

You can grant the permission to the user if you have root access to MySQL.
Let me know further.

Thanks
Calvin K
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests