I have the same problem with trying to dynamically create a database. According to HostGator website hosting support, you can only use cpanel to create a db when you are using a shared server. My conclusion? You can only share a single database using the template unles you are hosted on a dedicated server. Is this correct?

Concerning the dynamic DB creation, it is probable that you can not do it on a shared hosting and that is only available with dedicated server.
That seems normal because to perform such DB creation dynamically, you probably need a MySQL root login or at least a MySQL user that has the privileges to create the DB dynamically.

In general, when using shared hosting, you have to use the hosting administration tool to create the DB (here cPanel).

Yes that make sense that you don't have the MySQL root login when you are working on a shared server.

Hello, I have dedicated server and I try to use MySQL root login for config file. I checked connection the root login with MySQL by next command :
shell> mysqladmin version
shell> mysqladmin variables
shell> mysqladmin -h `hostname` version variables
shell> mysqladmin -h `hostname` --port=3306 version
shell> mysqladmin -h host_ip version
shell> mysqladmin --protocol=SOCKET --socket=/tmp/mysql.sock version
All command excecuted success.
When I trying make slave site from FE by Temlate of master with separate DB I see error MakeDB - DB Connection fail.WARNNOTCONNECTDB.
Could you give your recomendation about resolve the problem?

Br, Dmitry.

Give in your "mutlisites.cfg.php" the MySQL root login and password.
See user manual page 14.

Hello, I added to mutlisites.cfg.php MySQL root login (root/psw) and wrote about it in previous post. Unfortunately, after add root info to cfg I can not make template based site with separate DB (I have BD connection problem). My mutlisites.cfg.php is:
define( 'MULTISITES_DIR_RIGHTS', 0755);
define( 'MULTISITES_DB_GRANT_HOST', 'localhost');
define( 'MULTISITES_DB_ROOT_USER', 'root');
define( 'MULTISITES_DB_ROOT_PSW', 'root_password');
Do you have any ideas?

Br, Dmitry.

NO except debug to identify the parameters used to perform the DB connection.
If you want that we have a look on your environement, we also have billable support that you can order at www.jms2win.com/download?page=shop.produ...35&category_id=1