View source for Configuring MySQL to Run on a Separate Server

<includeonly>=== Configuring MySQL to Run on a Separate Server ===</includeonly>
This procedure sets up database connection pooling between the two servers.

<ol>
<li>Enable permissions on MySQL, so web servers can access the database server:<br/><pre>GRANT ALL ON *.* to 'root'@'web_server_IP_Address' IDENTIFIED BY 'password'</pre> 
</li>
<li>Direct the database server to the application server:
  <ol type="a">
  <li>Edit <tt>{install-dir}/profiles/IS_default/configuration/tomcat/conf/server.xml</tt></li>
  <li>Replace <tt>url="jdbc:mysql://{{domain}}/relationals"</tt> with<br/>   <tt>url="jdbc:mysql://IP_address_of_database_server/relationals"</tt></li>
  <li>Save the file</li>
  <li>If the Application server is currently running, then [[Restart the Application Server]].</li>
  </ol>
</li>
</ol>

''Learn More:'' http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/replication-solutions-backups.html
<noinclude>

[[Category:Installation]]
</noinclude>