MySQL, phpMyadmin - Question

[Anzix]

Hello,
I recenly aquired a vb lisence and I tried to do the import script and it says SELECT command is disabled. I asked my host about and he said they disabled it for secruity reason. So he gave me his passwords to change it.

Does anyone know how to turn it on... Hes using cpanel and whm

alright I just tried it on my server and i got the same error:

Invalid SQL: SELECT COUNT(*) AS count FROM fragwire_phpb1.phpbb_users
mysql error: Access denied for user: 'fragwire_g2k@localhost' to database 'fragwire_phpb1'

I check the privaliges and it is all set to yes

 

[ProWebUK]

You need to change the priviledges in phpMyAdmin whilst logged in as root.

 

[FarCry]

looks more like an issue that you dont have the right password...

 

[Anzix]

Nope, UK helped me I logged into phpmyadmin in root and edit that users priv's and it worked. Thanks Uk

 

[ProWebUK]

looks more like an issue that you dont have the right password...

The first statement said your query is not being accepted, the second said mysql did not allow access to do that command.... although after a quick look it does look like the problem you stated