PDA

View Full Version : MySQL, phpMyadmin - Question


Anzix
12-03-2003, 04:45 PM
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
12-03-2003, 07:14 PM
You need to change the priviledges in phpMyAdmin whilst logged in as root.

FarCry
12-03-2003, 08:40 PM
looks more like an issue that you dont have the right password...

Anzix
12-04-2003, 12:07 AM
Nope, UK helped me I logged into phpmyadmin in root and edit that users priv's and it worked. :-) Thanks Uk

ProWebUK
12-04-2003, 07:52 AM
Originally posted by phriendly-Mark
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 :D