SELECT command denied

[gegerva]

Hello to all

To be honest I am a dumb**s when it comes to mysql.

Now, that being told, here is my problem: i am trying to add a forum to my site, where someone register to the main site, they will be registered to the forum also.

I got to the part where i have to add  my site DB user to my forums DB and my forums DB user to your my site DB.

The message I'm getting : SELECT command denied to user 'mysite'@'x.x.232.75' for table 'vb_user'

I would appreciate any help

 

 

[s0c0]

Have you tried adding the user to your MySQL server?  You will need to do this if not.  You will have to give the user the right privileges as well including (most likely, but read the documentation) SELECT, UPDATE, DELETE, INSERT, and possible CREATE.

 

Hello to all

To be honest I am a dumb**s when it comes to mysql.

Now, that being told, here is my problem: i am trying to add a forum to my site, where someone register to the main site, they will be registered to the forum also.

I got to the part where i have to add  my site DB user to my forums DB and my forums DB user to your my site DB.

The message I'm getting : SELECT command denied to user 'mysite'@'x.x.232.75' for table 'vb_user'

I would appreciate any help

[gegerva]

As i mentioned  I am DA

but when i did this iswhat i get

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `database`.* TO

'user'@'localh' at line 2

and on the top of all i'm not sure where to add the user