php - how to connect to database on another server

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Could I have my php scripts on server A and connect to the MySQL database on server B?

If yes, how it would be done? Thanks in advance

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

139 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T01:06:55+0000

its simple all thise above techniques are quite complicated

suppose you have database on server B and website on server A(say it has IP 192.234.12.1)

on cpanel whitelist the IP of server B

and create a new user having sufficient privileges in database (say this user is test)

then create this user as test@192.234.12.1