Gsi_Ire
Member
Registered: 9th Aug 04
Location: Republic of Ireland
User status: Offline
|
right, my situation is as follows.
I have set up mysql on 1 of my pc's at home which is connected directly to the internet and created a database.
I have a user 'root' which as full access from all hosts.
I installed mysql-front on another pc on my network and was able to connect to the database with full access and check and change anything I want.
I have opened port 3306 in my firewall to allow connections to the database from the internet (in this case i plan on using it for a forum while i test it out)
I set up the config file for the forum I want to use with the correct ip address as the databse host and with the user details I set up with full access.
However when I try and attach the databse to the forum throught a set up procedure on my web page it gives access denied to server! In my sql I can see how many times it has attempted to attach to the database, so its reaching the db but not connecting.
The only think I can find that is not working is, if i try to use telnet to connect to the db from the second pc (which can connect throught my-sql) i get error "bad handshake"
I am very new to this, so if anyone has any previous experiance or suggestions please let me know.
Cheers
|
paul_spurrell
Member
Registered: 14th Sep 01
Location: Bath Avon
User status: Offline
|
is the mysql database on the same box as the forum software?
|
paul_spurrell
Member
Registered: 14th Sep 01
Location: Bath Avon
User status: Offline
|
Can you access the Database from using mysql administrator?
|
Gsi_Ire
Member
Registered: 9th Aug 04
Location: Republic of Ireland
User status: Offline
|
no the forum is stored on some web space a friend has lent me. the web space supports everything needed but he has no free databases.
i can access the db using the mysql admin that came with mysql download and with mysql-front which i dl'ed afterwards
|
paul_spurrell
Member
Registered: 14th Sep 01
Location: Bath Avon
User status: Offline
|
when you say "I have a user 'root' which has full access from all hosts."
Have you confirmed that you can actually connect from a different machine?
Sorry i only know a little about mysql
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
you are trying to access the db on your pc on your home network from free webspace?
Have you setup port forwarding on your router?
Why not just install apache locally?
|
Gsi_Ire
Member
Registered: 9th Aug 04
Location: Republic of Ireland
User status: Offline
|
yes i have comfirmed within my home network.
using mysql-front i connected to the database and was able to edit and create users and create a new database etc
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
but you are accessing your home network from outside?
|
Gsi_Ire
Member
Registered: 9th Aug 04
Location: Republic of Ireland
User status: Offline
|
i have the config file set up to connect throught the ip address on the net ofc and its reaching the db (i can see the number of failed connections)
i have yet to try connecting to the db from outside my network with anything other than the forum.
[Edited on 20-07-2005 by Gsi_Ire]
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
just install apache on your local pc or buy some webspace 
|
Gsi_Ire
Member
Registered: 9th Aug 04
Location: Republic of Ireland
User status: Offline
|
i am going to buy someweb space once i can get it to work 
apache, going to show my ignorance, but does that install onto xp pro for example or is it a complete o/s?
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
will install on xp, http://easyphp.org
|
