View previous topic :: View next topic |
Author |
Message |
hc2995 -
Joined: 07 Aug 2006 Posts: 644 Location: Maryland, USA
|
Posted: Sat Sep 16, 2006 12:59 am Post subject: cannot connect to host, Access is denied! |
|
|
Ok i know iv typed in all the corect stuff, im trying to connect to a mysql DB on another PC (on my network) iv typed in its local IP, and the external ip (i have forwarded the port for mysql) after chcking whats wrong i get something like "Cannot connect to mysql on remote host, Access is denied!" so im asking how do i allow access to remote hosts on my network? _________________ Where have i been? School got heck-tick, had to move half way around the state, then back... and then i had to change jobs, so iv been away for a while :P |
|
Back to top |
|
|
bprsk8r4272 -
Joined: 07 Mar 2006 Posts: 124 Location: Rochester, NY
|
Posted: Sat Sep 16, 2006 2:17 am Post subject: |
|
|
did you enable that feature while installing mysql and if so did you enter the root password _________________
|
|
Back to top |
|
|
Tim1681 -
Joined: 17 Jan 2005 Posts: 160 Location: Bristol, CT, USA
|
Posted: Sat Sep 16, 2006 5:38 am Post subject: |
|
|
You have to make an account for the server in MySQL using the computer's network name or IP address .. i forget which one. I had to do this with my servers. Google "MySQL user privileges" it and see what u come up with. _________________ mysql> SELECT * FROM users WHERE clue > 0;
0 rows returned.
|
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Sat Sep 16, 2006 10:27 am Post subject: |
|
|
Using MySQLAdmin or PHPMyAdmin, find the username you want to connect with and change the host from "Localhost" to "%" which means any host. Save settings and try again. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
hc2995 -
Joined: 07 Aug 2006 Posts: 644 Location: Maryland, USA
|
Posted: Sun Sep 17, 2006 12:52 am Post subject: |
|
|
ok changing from localhopst to % worked :D _________________ Where have i been? School got heck-tick, had to move half way around the state, then back... and then i had to change jobs, so iv been away for a while :P |
|
Back to top |
|
|
|