linuxdebian
asked on
connect xampp MYSQL
Hello
I installed xampp windows xp verison.
I installed on xp1 machine and i did all necessery configuration(mysql root pass and all).
also apache works too.
But when i try from other xp2 computer to xp1 where is xammp mysql server,i get an error,
Connection failed. Remoteserver can not connect.(both xps in my local network)
any idea?
thanks
I installed xampp windows xp verison.
I installed on xp1 machine and i did all necessery configuration(mysql root pass and all).
also apache works too.
But when i try from other xp2 computer to xp1 where is xammp mysql server,i get an error,
Connection failed. Remoteserver can not connect.(both xps in my local network)
any idea?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
when i try to connect from xp2 to mysql server xp1.
error HTTP-status 404: not found
error HTTP-status 404: not found
Please remove bind-address.
Considering ip of remote machine: 172.16.2.100
Grant all privileges on *.* to 'username'@'172.16.2.100' identified by 'password';
Considering ip of remote machine: 172.16.2.100
Grant all privileges on *.* to 'username'@'172.16.2.100' identified by 'password';
ASKER
sorry again that error.HTTP-404
I have an program which works with mysql in XP2,actually i try this program uses external mysql uses.
For that i installed xammp on XP1 ,and try connect from xp1 to xp2.
But still i cannot ,it s interesting on XP1 internet explorer i can go phpmyadmin.
But program still can not connect db.
may be i need to create a new DB??
I have an program which works with mysql in XP2,actually i try this program uses external mysql uses.
For that i installed xammp on XP1 ,and try connect from xp1 to xp2.
But still i cannot ,it s interesting on XP1 internet explorer i can go phpmyadmin.
But program still can not connect db.
may be i need to create a new DB??
ASKER
i created a DB named crm.In that program there is a place for URL connection,i write
http://172.16.2.100/crm
and agin HTTP-404 error:((
http://172.16.2.100/crm
and agin HTTP-404 error:((
404 is page not found error.
For mysql connectivity just have a mysql client / query brower installed and check if you can connect remote host providing required parameters.
For mysql connectivity just have a mysql client / query brower installed and check if you can connect remote host providing required parameters.
i think u have not tried my comments
ASKER
sorry i skiped i think.I just concemtreted mysql server:))
can you tell me how ?"insoftservice".
can you tell me how ?"insoftservice".
404 is page not found error, please google about it!!
You make sure your webserver is working fine without involving mysql connection and using may be a simple html page.
and then check for connection issue!!
If you're in network you should be able to connect mysql using any mysql client!!
You make sure your webserver is working fine without involving mysql connection and using may be a simple html page.
and then check for connection issue!!
If you're in network you should be able to connect mysql using any mysql client!!
ASKER
But from out side of mysql server ,i a able to connect apache server.
I mean internet browser shows up xampp web site out side network.
I think only the problem permission somehow.Http with mysql db.
I mean internet browser shows up xampp web site out side network.
I think only the problem permission somehow.Http with mysql db.
hi,
say ur xp1 has xampp install ur able to view ur page. but when u try to get access same website on other m/c with mysql it fails but without mysql it works right? please confirm.
pls let me know wh ts ip on ur host is it ur ip or its 127.0.0.1
if its 127.0.0.1 then change it to ur local ip
then set permission to ur username ie grant permission with ip.
change ur mysql config where u have used localhost change it to ur ip please let me know if any issue
say ur xp1 has xampp install ur able to view ur page. but when u try to get access same website on other m/c with mysql it fails but without mysql it works right? please confirm.
pls let me know wh ts ip on ur host is it ur ip or its 127.0.0.1
if its 127.0.0.1 then change it to ur local ip
then set permission to ur username ie grant permission with ip.
change ur mysql config where u have used localhost change it to ur ip please let me know if any issue
ASKER
Hi
soory still can not connect.
ok here...
xp1 =xamp installed.(172.16.2.100).a
+ CRMM db created.
+ grant privileges user created.
xp2 = one program works with MYSQL DATABANK.and I try to connect to xp1(xampp) DATABANK.
+ internet explorer http://172.16.2.100 and comes xampp website.
+ internet expolrer htttp://172.16.2.100/phpmy
- on xp2 has a program which must use external DATABANK (hier is xammp databank) http://172.16.2.100/crmm(db name in mysql) and comes error HTTP-status 404: not found
soory still can not connect.
ok here...
xp1 =xamp installed.(172.16.2.100).a
+ CRMM db created.
+ grant privileges user created.
xp2 = one program works with MYSQL DATABANK.and I try to connect to xp1(xampp) DATABANK.
+ internet explorer http://172.16.2.100 and comes xampp website.
+ internet expolrer htttp://172.16.2.100/phpmy
- on xp2 has a program which must use external DATABANK (hier is xammp databank) http://172.16.2.100/crmm(db name in mysql) and comes error HTTP-status 404: not found
ASKER
xp1=172.16.2.100
xp2=172.16.2.200
xp2=172.16.2.200
" http://172.16.2.100/crmm(db name in mysql)"
DBNAME??? It will not display database like this!!
DBNAME??? It will not display database like this!!
ASKER
ASKER
mysql creates automatically test databank or?
ASKER
thanks
ASKER
i did
1.grant all privileges on *.* to 'username'@'ipaddress' identified by 'password';
2.comment out skip-networking
3.bind address 172.16.2.100
restart all
but no luck ?