phpmyadmin help needed

[blatant3]

first of all id like to say that this is my first time as a registered member here. so hello to everyone, and thank you in advance for any advice that you might give me.
ok having said that, heres the problem i have.

no matter what i try im not able to grant user privleges in phpmyadmin..ive tried everything(at least i think i have)and to no avail. the only thing im allowed to do in my database is INSERT and SELECT. this is not good as i need to alter tables that i have made and its crucial to the functionality of my website.
does anyone have any advice?

[Webforumz Staff]

I've used phpmyadmin before, but I've never used it with user priveledges.

After having a quick look through the documentation is seems that there are a few things that you need to do:
<blockquote id="quote" class="ffs">quote:<hr height="1" noshade="noshade" id="quote" />NOTE: phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's "Privileges" page can be used for this.<hr height="1" noshade="noshade" id="quote" /></blockquote id="quote">
I would see the section in the docs entitled: Using authentication modes
<blockquote id="quote" class="ffs">quote:<hr height="1" noshade="noshade" id="quote" />Then each of the true users should be granted a set of privileges on a set of particular databases. Normally you shouldn't give global privileges to an ordinary user, unless you understand the impact of those privileges (for example, you are creating a superuser).
For example, to grant the user real_user with all privileges on the database user_base:
GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';
What the user may now do is controlled entirely by the MySQL user management system.
With HTTP or cookie authentication mode, you don't need to fill the user/password fields inside the $cfg['Servers'] array.<hr height="1" noshade="noshade" id="quote" /></blockquote id="quote">
<blockquote id="quote" class="ffs">quote:<hr height="1" noshade="noshade" id="quote" />[4.5] Is it possible to let users create their own databases?

Starting with 2.2.5, in the user management page, you can enter a wildcard database name for a user (for example "joe%"), and put the privileges you want. For example, adding SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER would let a user create/manage his/her database(s).<hr height="1" noshade="noshade" id="quote" /></blockquote id="quote">
That's about all I can find.

Without knowing your specific configuraton, the version of phpmyadmin you are using and your hosting environment, there is little specific advice I can give you.