Excerpt | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
NOTE TO WRITERS: Add the following to the beginning of your hosting page: The following sections describe how to replace the default H2 databases with MySQL:
|
...
To create tables in the registry and user manager database (
WSO2CARBON_DB
), use the below script:Info You may have to enter the password for each command when prompted.
Code Block language powershell mysql -u regadmin -p -Dregdb < '<PRODUCT_HOME>/dbscripts/mysql.sql';
Note If you are using MySQL version 5.7 or later, use rename
mysql5.7.sql
tomysql.sql
and execute the following script insteadcommand:mysql -u regadmin -p -Dregdb < '<PRODUCT_HOME>/dbscripts/mysql.sql';
We plan to merge the two scripts (
';mysql5.7.sql
and
mysql.sql
) in a later version.Restart the server.
Info You can create database tables automatically when starting the product for the first time by using the
-Dsetup
parameter as follows:For Windows:
<PRODUCT_HOME>/bin/wso2server.bat -Dsetup
For Linux:
<PRODUCT_HOME>/bin/wso2server.sh -Dsetup
...