mrlongshen Posted July 28, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Share Posted July 28, 2013 (edited) i have a vps, but i also have a webhosting. can i install my control panel on webhosting or install in vps ? because my webhosting got the the domain. Or should i just buy a domain name only instead of buy a webhosting ? example my vps ip 192.168.1.1 so when i buy a domain i will just point to it ? regard confuse Edited August 18, 2013 by mrlongshen Link to comment Share on other sites More sharing options...
Jasc Posted July 28, 2013 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 270 Reputation: 20 Joined: 12/10/11 Last Seen: June 28, 2022 Share Posted July 28, 2013 I use both. My webhosting hosts my forums/website - it connects to my server via sql VPS hosts my server files, I find this method the best, that way if the server goes down, the website is independent and players can keep informed incase of your server moving to different host etc 1 Link to comment Share on other sites More sharing options...
mrlongshen Posted July 28, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted July 28, 2013 (edited) I use both. My webhosting hosts my forums/website - it connects to my server via sql VPS hosts my server files, I find this method the best, that way if the server goes down, the website is independent and players can keep informed incase of your server moving to different host etc thx alot sir +1 for u . hehee btw i need to configure my flux cp config, to my vps server database right ? 1000 MB (1GB) Web And Email Space 50000 MB (50GB) Bandwidth/month Unlimited Subdomain and Domain Unlimited Email Unlimited mySQL Unlimited Addon & Park Domain its enough right ? Edited July 28, 2013 by mrlongshen Link to comment Share on other sites More sharing options...
Myth Posted July 28, 2013 Group: Members Topic Count: 59 Topics Per Day: 0.01 Content Count: 225 Reputation: 5 Joined: 05/30/12 Last Seen: May 3, 2022 Share Posted July 28, 2013 yup, use ur phpmyadmin/mysql username and password for the database Link to comment Share on other sites More sharing options...
Jasc Posted July 28, 2013 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 270 Reputation: 20 Joined: 12/10/11 Last Seen: June 28, 2022 Share Posted July 28, 2013 (edited) I use both. My webhosting hosts my forums/website - it connects to my server via sql VPS hosts my server files, I find this method the best, that way if the server goes down, the website is independent and players can keep informed incase of your server moving to different host etc thx alot sir +1 for u . hehee btw i need to configure my flux cp config, to my vps server database right ? 1000 MB (1GB) Web And Email Space 50000 MB (50GB) Bandwidth/month Unlimited Subdomain and Domain Unlimited Email Unlimited mySQL Unlimited Addon & Park Domain its enough right ? As Myth said, use your sql user/password to connect flux cp to the vps. I always create a separate user just to connect to sql. Example: If I host my website with asurahosting, I will need to make sure that the new User has ALL privileges and the allowed host it can connect to is cpanel.asurahosting.com In my users list in phpmyadmin it looks like this user1/password/127.0.0.1 - allows my server to start using its local ip and permissions user2/password/localhost - allows any user on any IP to connect via phpmyadmin user3/password/cpanel.asurahosting.com - allows my webserver to connect to sql This way all the passwords are different and I can keep track of which user connects to what via sql. Those website stats you gave me seem pretty good, more than enough for what you need. Edited July 28, 2013 by Jasc Link to comment Share on other sites More sharing options...
mrlongshen Posted July 28, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted July 28, 2013 yup, use ur phpmyadmin/mysql username and password for the database thx alot sir I use both. My webhosting hosts my forums/website - it connects to my server via sql VPS hosts my server files, I find this method the best, that way if the server goes down, the website is independent and players can keep informed incase of your server moving to different host etc thx alot sir +1 for u . hehee btw i need to configure my flux cp config, to my vps server database right ? 1000 MB (1GB) Web And Email Space 50000 MB (50GB) Bandwidth/month Unlimited Subdomain and Domain Unlimited Email Unlimited mySQL Unlimited Addon & Park Domain its enough right ? As Myth said, use your sql user/password to connect flux cp to the vps. I always create a separate user just to connect to sql. Example: If I host my website with asurahosting, I will need to make sure that the new User has ALL privileges and the allowed host it can connect to is cpanel.asurahosting.com In my users list in phpmyadmin it looks like this user1/password/127.0.0.1 - allows my server to start using its local ip and permissions user2/password/localhost - allows any user on any IP to connect via phpmyadmin user3/password/cpanel.asurahosting.com - allows my webserver to connect to sql This way all the passwords are different and I can keep track of which user connects to what via sql. Those website stats you gave me seem pretty good, more than enough for what you need. ohh.. ok . i will create many user. so i will know. for password security. not only just admin only. right. hehe. thx sir. yeah its seem good, because i want make my own site instead ragnarok. hehe Link to comment Share on other sites More sharing options...
mrlongshen Posted August 2, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted August 2, 2013 (edited) I use both. My webhosting hosts my forums/website - it connects to my server via sql VPS hosts my server files, I find this method the best, that way if the server goes down, the website is independent and players can keep informed incase of your server moving to different host etc thx alot sir +1 for u . hehee btw i need to configure my flux cp config, to my vps server database right ? 1000 MB (1GB) Web And Email Space 50000 MB (50GB) Bandwidth/month Unlimited Subdomain and Domain Unlimited Email Unlimited mySQL Unlimited Addon & Park Domain its enough right ? As Myth said, use your sql user/password to connect flux cp to the vps. I always create a separate user just to connect to sql. Example: If I host my website with asurahosting, I will need to make sure that the new User has ALL privileges and the allowed host it can connect to is cpanel.asurahosting.com In my users list in phpmyadmin it looks like this user1/password/127.0.0.1 - allows my server to start using its local ip and permissions user2/password/localhost - allows any user on any IP to connect via phpmyadmin user3/password/cpanel.asurahosting.com - allows my webserver to connect to sql This way all the passwords are different and I can keep track of which user connects to what via sql. Those website stats you gave me seem pretty good, more than enough for what you need. hello sir, i dont understand.. i have a website. then i install main.sql. and log.sql then i config my inter.conf with on my website sql. but when i start cannot connect. how do i config my server on vps but running all sql in my webhosting ? is that possible ? or not ? and for the flux cp, should i install in website or vps ? bump post~ I install my control panel on my webhosting, and then i config my server.php to point my sql serves on the vps. but i got this error. Exception DetailsError: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.212.xxx' (4) what should i do ? just a control panel problem, but my server running well Edited August 2, 2013 by mrlongshen Link to comment Share on other sites More sharing options...
ccjosh Posted August 2, 2013 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 66 Reputation: 6 Joined: 11/13/12 Last Seen: November 17, 2014 Share Posted August 2, 2013 I suggest you host your flux on a webhost, then have it point to your VPS' MySQL Exception Details Error: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.212.xxx' (4) It might be permission thing, I usually do 'setsebool -P httpd_can_network_connect=1' if I'm on Linux Link to comment Share on other sites More sharing options...
mrlongshen Posted August 2, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted August 2, 2013 I suggest you host your flux on a webhost, then have it point to your VPS' MySQL Exception Details Error: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.212.xxx' (4) It might be permission thing, I usually do 'setsebool -P httpd_can_network_connect=1' if I'm on Linux sir im on centos .. same right ... ? i will try the 'setsebool -P httpd_can_network_connect=1' btw.. can i run the the main.sql and log.sql on my webhost ? cannot ea ? i want to save the database on webhost so then i can backup if the vps got problem. Link to comment Share on other sites More sharing options...
Myth Posted August 3, 2013 Group: Members Topic Count: 59 Topics Per Day: 0.01 Content Count: 225 Reputation: 5 Joined: 05/30/12 Last Seen: May 3, 2022 Share Posted August 3, 2013 i suggest dont use your webhost for sql hosting. use your webhost for flux cp only and connect your webhost sql to your vps Link to comment Share on other sites More sharing options...
ccjosh Posted August 3, 2013 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 66 Reputation: 6 Joined: 11/13/12 Last Seen: November 17, 2014 Share Posted August 3, 2013 Yes it's possible, but I think it's not advisable to host your DB on a shared web hosting. If you want to secure back ups, do a crontab that dumps your sql files to a database outside your VPS Link to comment Share on other sites More sharing options...
mrlongshen Posted August 3, 2013 Group: Members Topic Count: 98 Topics Per Day: 0.02 Content Count: 1302 Reputation: 77 Joined: 12/04/12 Last Seen: September 26, 2019 Author Share Posted August 3, 2013 i suggest dont use your webhost for sql hosting. use your webhost for flux cp only and connect your webhost sql to your vps how to connect the fluxcp to the sql database on forum. when i tried to connect mysql cannot connected. Its seem disallow connection from outside. Yes it's possible, but I think it's not advisable to host your DB on a shared web hosting. If you want to secure back ups, do a crontab that dumps your sql files to a database outside your VPS ohhh. thx alot sir . got command to backup database ? mayb automatically every weekend ? Link to comment Share on other sites More sharing options...
Question
mrlongshen
i have a vps, but i also have a webhosting. can i install my control panel on webhosting or install in vps ?
because my webhosting got the the domain. Or should i just buy a domain name only instead of buy a webhosting ?
example my vps ip 192.168.1.1 so when i buy a domain i will just point to it ?
regard
confuse
Edited by mrlongshenLink to comment
Share on other sites
11 answers to this question
Recommended Posts