Page 1 of 1

Connect to xampp MYSQL from network

PostPosted: 23. September 2011 14:35
by deefpi
Hello.

I have a network: 2 PC`s and router.
I want to make a one database and that database will be on one of these two PC in network. So I install it on one of them with IP: 192.168.0.103.
I open config in PHP to allows all user to connect to apache. I write on Mozilla adress: ip/phpmyadmin/ and everything works. But I have a problem when I want to connect to database from my application. I have a error: Host not allowed to connect to this mysql server. I know that I must change binding adres in mysql config so I write adres: 192.168.0.103. And I know i must change mysql users table but I dont know what the pattern is and what I must write them.
Host: IP second PC in network?
User: Can I write a mysql administrator password (root etc)
Password: like users.

Next I must make everything on "Yes".
It a good way?

Re: Connect to xampp MYSQL from network

PostPosted: 23. September 2011 14:39
by Sharley
We require your XAMPP version and your Windows Version to proceed.
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Thanks.

Re: Connect to xampp MYSQL from network

PostPosted: 23. September 2011 14:57
by deefpi
Windows 7 Enterprise
Xampp 1.7.7 [PHP: 5.3.8]

Re: Connect to xampp MYSQL from network

PostPosted: 23. September 2011 15:12
by Sharley
Ok, you don't need to do all that.

Open phpMyAdmin and change the Localhost to Any Host, usually has a % when changed, for the user name that will connect to the database you choose.

See if that helps, you may have to change some settings back to the defaults.

Good luck :)

Re: Connect to xampp MYSQL from network

PostPosted: 23. September 2011 15:47
by deefpi
Its working but I must change my bind adres to 0.0.0.0 too. But its working :)

Thx a lot!

Re: Connect to xampp MYSQL from network

PostPosted: 23. September 2011 15:51
by Sharley
8) Your welcome.

Good luck. :D