Connect to xampp MYSQL from network

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Connect to xampp MYSQL from network

Postby deefpi » 23. September 2011 14:35

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?
deefpi
 
Posts: 3
Joined: 23. September 2011 14:15

Re: Connect to xampp MYSQL from network

Postby Sharley » 23. September 2011 14:39

We require your XAMPP version and your Windows Version to proceed.
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Thanks.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Connect to xampp MYSQL from network

Postby deefpi » 23. September 2011 14:57

Windows 7 Enterprise
Xampp 1.7.7 [PHP: 5.3.8]
deefpi
 
Posts: 3
Joined: 23. September 2011 14:15

Re: Connect to xampp MYSQL from network

Postby Sharley » 23. September 2011 15:12

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 :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Connect to xampp MYSQL from network

Postby deefpi » 23. September 2011 15:47

Its working but I must change my bind adres to 0.0.0.0 too. But its working :)

Thx a lot!
deefpi
 
Posts: 3
Joined: 23. September 2011 14:15

Re: Connect to xampp MYSQL from network

Postby Sharley » 23. September 2011 15:51

8) Your welcome.

Good luck. :D
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 107 guests