mysql connection

[predator50]

Hello mxc community.

 

I have a website hosted on a commercial webhoster. Now i wanted to add statistic scripts but it doesn't work. My question is...how to allow mysql db access on my home pc (where the server runs at this moment) from the website ?

[Fanky]

Dude,there's a shit load of guide in this forum(and not only here).

 

did you searched on your own?

[predator50]

yes ofc. could you post me a link if so many guids are existant in mxc forum.

[claww]

Hello mxc community.

 

I have a website hosted on a commercial webhoster. Now i wanted to add statistic scripts but it doesn't work. My question is...how to allow mysql db access on my home pc (where the server runs at this moment) from the website ?

 

look  create a new user in  navicat   

 

1. Click on Manage users

2. Add User

3. Username = "user of database" default is  " root"

Host: your domain IP/Host

a new password

4. Click  OK

 

5. Select your new user  and  you have now a  box in right place  " Global Privileges "    and here  enable  "Select and Show View "  other disable

 

 

now at username  instead of " root " how you put in localhost      put  "root@myhostdomain.com" 

 

if is not clearly tell me ;)