How to configure Plastic SCM with MySQL

It's very simple to set up, you only need to create (or edit) a file named 'db.conf' on the Plastic SCM server installation directory. It must have the following content:

Note: In the following two examples of code, the lines <ConnectionString>....</ConnectionString> must be on one complete line. It has been split here for the sake of visual clarity.

<DbConfig>

  <ProviderName>mysql</ProviderName>

  <ConnectionString>Server=_SERVER_;User ID=_USER_;Password=_PASSWORD_;

    Database={0};Pooling=true</ConnectionString>

  <DatabasePath></DatabasePath>

</DbConfig>

Replace the parameters _SERVER_, _USER_, and _PASSWORD_ with the appropriate ones according to the server configuration that you want to use. Thus, a valid 'db.conf' file in our development environment would be:

<DbConfig>

  <ProviderName>mysql</ProviderName>

   <ConnectionString>Server=venus;User ID=myuser;Password=mypwd;

     Database={0};Pooling=true</ConnectionString>

  <DatabasePath></DatabasePath>

</DbConfig>

Finally, we must set the MySQL configuration parameter max_allowed_packet to support up to 10MB. If you require more information about how configure this parameter, you can take a look at this article.