hello,
i need to connect a mysql database which is on a remote PC using PHP or smt like that
both PC are connected to internet
i use xampp and win7
i know that i will use
mysql_connect("remote PC's IP", "login name set up for my PC", "login password");
additionally, remote PC should give permission to me to read and write its mysql database.
i did this:
CREATE USER 'remote'@'%' IDENTIFIED BY '***';
GRANT ALL PRIVILEGES ON * . * TO 'remote'@'%' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `remote` ;
GRANT ALL PRIVILEGES ON `remote` . * TO 'remote'@'%';
but it was not fixed. mysql_connect("remote PC's IP", "login name set up for my PC", "login password") gives error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on '79.***.***.***' (10060) in C:\xampp\htdocs\baglan.php on line 3
Can't connect to MySQL server on '79.***.***.*** (10060)
could you please help me about this issue
hello again
i did what you said but no luck...
in my database i have a privilege as
User Host Password Global privileges Grant
mustafa % some pswd all privileges yes
and i add an inbound rule to windows firewall for port 10060 and 3306
any advice...