why is my sql user missing the alter right?

[Garo_Master]

I keep activating it, but I still can't alter anything, and one of my WP plugins won't work right without it.

 

[Corey]

Can you try creating a new MySQL user and assigning it the permissions to see if it is just the one user or if it happens to all of them?

-Corey

 

[Garo_Master]

I deleted my first user and created another, but I still can't alter anything.
Edit:
I noticed in phpMyAdmin that my user is different from the one that is in MySQL, does that mean anything?
Edit:
I also notice I can't create my own databse using phpMyAdmin.
why is that?

 

[Corey]

Creating users, databases, and assigning permissions has to be done through the MySQL section in cPanel, and not through PHPMyAdmin

 

[Garo_Master]

what about my other question?
this is it:
"I noticed in phpMyAdmin that my user is different from the one that is in MySQL, does that mean anything?"
Edit:
and I still don't have alter access to my database and the tables within it.

 

[Corey]

What user are you seeing in phpMyAdmin, and what one are you seeing in the MySQL section?

 

[Garo_Master]

for the mySQL, gmsword_wrdp1, but in phpMyadmin, its gmsword@localhost.

 

[Fedlerner]

The user you see on PhpMyAdmin is not your MySQL user.
As Corey has already say, you need to create go to cPanel > MySQL databases, and there you can: Create a MySQL database, Create a MySQL user & assign the user to the database.

 

[Garo_Master]

I already have, but I can't alter the tables, and the only way i know how is through phpMyAdmin. Is there any other way?

 

[Fedlerner]

No, if you want to manually edit them, the only way is PhpMyAdmin.
Are you getting an error when trying to alter the tables from PHP?

 

[Garo_Master]

I'm trying to use a word press plugin that edits the prefix of each table and it says that my user is missing the alter right.
Edit:
when trying to use a wordpress plugin that edits the wp_ prefix to something else, I get an error.
Wordpress itself hasn't worked right after the maintenance a few months back.
I got it working through the admins advice, but it still isn't working completely correct.

 

[Corey]

Wordpress is compatible with our intermediate PHP version, I haven't heard of anyone having issues with it once they switched.

You'll have to make the alter changes through phpMyAdmin.