MySQL user privs

[CWC]

I'm trying to port a MySQL database over from the original host and I'm having problems. Mainly, it seems I can't do a CREATE ALGORITHM query on account of not having SUPER privileges, and I can't find any way to give that privilege in PHPMyAdmin. Is this something I don't have access to as a HostGator client, or am I just missing something key?

[Serra]

Originally Posted by CWC

I'm trying to port a MySQL database over from the original host and I'm having problems. Mainly, it seems I can't do a CREATE ALGORITHM query on account of not having SUPER privileges, and I can't find any way to give that privilege in PHPMyAdmin. Is this something I don't have access to as a HostGator client, or am I just missing something key?

You must be missing something. You can create a new user with any privilege you want.

[CWC]

Really? Because when I'm in PHPMAdmin, I try the following query:

GRANT ALL PRIVILEGES ON <database>. * TO '<user>'@'localhost' IDENTIFIED BY '<pwd>'

And I get this error:

MySQL said: Documentation
#1044 - Access denied for user '<user>'@'localhost' to database '<database>'

[Serra]

Originally Posted by CWC

Really? Because when I'm in PHPMAdmin, I try the following query:

MySQL said: Documentation
#1044 - Access denied for user '<user>'@'localhost' to database '<database>'

I'm not sure that you can grant privileges in phpMyAdmin. You can in cPanel, so do it there.

[CWC]

The other problem queries (CREATE VIEW and CREATE ALGORITHM) also seem not to work in MyAdmin, and I don't have any other way to run them.

[Serra]

Originally Posted by CWC

The other problem queries (CREATE VIEW and CREATE ALGORITHM) also seem not to work in MyAdmin, and I don't have any other way to run them.

It is a mySQL 5 server or mySQL 4?

[CWC]

5.0.45-community

[CWC]

Hm. Looks like putting it in a script and running it there actually allowed me to create the view; so it was just PHPMyAdmin screwing up. Thanks!