[Janet Jackson]

I'm not sure if it's the spaces between the red characters, but you should retry the query with them removed.

GRANT ALL PRIVILEGES ON hello_phpbb3 . * TO 'hello'@'localhost' IDENTIFIED BY 'mypassword'

And don't forget to replace 'mypassword' ;)

[Lord_Destros]

hmmmm, this is annoyin. I am still getting the same error. Either I am blind, deaf, and dumb (not completely impossible ), or............?


Any ideas ?

[DaSoul]

Check your username and password.

I assume that mysql and hlds server on the same machine. Correct?

[Lord_Destros]

The mysql/webserver is not on our game server. when i tried ip instead of localhost it didn't seem to work either. It still gave me the same error that I posted above.

[Janet Jackson]

What ip ? You should replace 'localhost' with the ip of your gameserver.

[DaSoul]

Originally Posted by Lord_Destros hmmmm, this is annoyin. I am still getting the same error. Either I am blind, deaf, and dumb (not completely impossible ), or............? Any ideas ?

Where are you running this command? You need to run it at the mysql prompt on your webserver/database server or you can run it maybe if you have access to phpmyadmin.

GRANT ALL PRIVILEGES ON hello_phpbb3.* TO 'hello'@'*' IDENTIFIED BY 'whateveryourdbpassword'

If you put * for the ip address then hello can access the database from every ip address. but if your game server only has one ip address you should probably put its ip address into that command. But you have to have admin permissions for the mysql system for the above mysql command to even work. So you maybe need to run it as root or admin.

[Lord_Destros]

i'm running it through phpmyadmin with what i believe to be full access. I have full cpanel/phpmyadmin access. * gives me same error..............

[DaSoul]

Originally Posted by Lord_Destros i'm running it through phpmyadmin with what i believe to be full access. I have full cpanel/phpmyadmin access. * gives me same error..............

Well phpmyadmin may not have access to the system tables. It depends upon which user is running as phpadmin. You should maybe contact the company that provides you with your cpanel. I am sure they have some type of support system where they can help you.

Do you have ssh access to your machine? You might try by actually using the mysql command line.

[Lord_Destros]

lol, this may sound dumb but i'm new to using sql but is it possible if one of you guys to send me a presetup version of this (with everything prealtered)

zomg, a steam update with free dod .

[DaSoul]

I don't think its possible for us to send to you a database with the proper permissions and also include the forum information for phpbb.