Reply to thread

Message

<blockquote data-quote="Heaplink" data-source="post: 102718" data-attributes="member: 8966">First of all, that is the the stupidest idea I have ever heard — but it is not impossible.First you need to install MySQL on the server you wan't to keep the database on (if you wan't phpmyadmin, you have to install PHP too - apache is really too heavy, so install them separately)&nbsp;Now install either Apache (windows, unix) or nginx (unix) with mysql and php on your other server. You'll have to portforward the MySQL database server on a desired port (I recommend NOT to use the default port (3306) but another port and portforward that and let mysql listen on that port)&nbsp;Then you make a secure user with a hard password so you are sure no noobs guess it. Now try to connect with a simple mysql_connect() function on your web server to the mysql server.&nbsp;Again, you'll have to choose your chosen port, since the default setting for the mysql port is 3306. So when you write the mysql_connect() connect like this:[PHP]mysql_connect('&lt;MySQL server IP&gt;:&lt;Chosen Port&gt;', '&lt;MySQL Username&gt;', '&lt;MySQL Password&gt;');[/PHP]of course without the &lt; and &gt; and such.</blockquote>

[QUOTE="Heaplink, post: 102718, member: 8966"] First of all, that is the the stupidest idea I have ever heard — but it is not impossible. First you need to install MySQL on the server you wan't to keep the database on (if you wan't phpmyadmin, you have to install PHP too - apache is really too heavy, so install them separately) Now install either Apache (windows, unix) or nginx (unix) with mysql and php on your other server. You'll have to portforward the MySQL database server on a desired port (I recommend NOT to use the default port (3306) but another port and portforward that and let mysql listen on that port) Then you make a secure user with a hard password so you are sure no noobs guess it. Now try to connect with a simple mysql_connect() function on your web server to the mysql server. Again, you'll have to choose your chosen port, since the default setting for the mysql port is 3306. So when you write the mysql_connect() connect like this: [PHP]mysql_connect('<MySQL server IP>:<Chosen Port>', '<MySQL Username>', '<MySQL Password>');[/PHP] of course without the < and > and such. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members