mysql permissions help pls

[jmrccars]

hello.

can someone please help whats the proper way to add mysql users to make vB work?

i tried:


GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vb_database.* TO 'vbuser'@'192.168.0.2' IDENTIFIED BY 'vbuser';


but it didn't work, i still cant login to the mysql server from 192.168.0.2

my mysql server's ip add is 192.168.0.1, and the hosts im trying to access mysql from is 192.168.0.2.

also, what if i want to allow mysql access for 'vbuser' from localhost, 192.168.0.2 and 192.168.0.3 ONLY? how can i do that?

can i comma delimit the hosts? i read the mysql docs and been trying the past few hours but it just wouldn't work no matter how i try.

can someone please help me what im doing wrong?

thank you very much.

[Zachery]

You are currently showing up as unlicensed. To be able to receive support here at vBulletin.com, we ask you to please click HERE (http://www.vbulletin.com/members/membersupport_priority.php) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

Thank you.