Setting Initial Permissions And User On SMCP Databases

Post date: Mar 03, 2015 4:37:23 PM

When initially setting up SMCP in a MySQL database, these commands need to be run in MySQL:

Create the 'control' or 'admin' database:

CREATE DATABASE smcpcontrols;

Now create a user for the control database - here we use 'adminpassword' for the password, but make up your own if you want:

CREATE USER 'smadmin'@'%' IDENTIFIED BY 'adminpassword';

Now give that user permissions on the smcpcontrols database:

GRANT ALL on smcpcontrols.* to 'smadmin'@'%';

Create the actual SMCP database (you can use any name that works for you):

CREATE DATABASE servmgr;

Add a user for the program to use with this database (use your own password):

CREATE USER 'smuser'@'%' IDENTIFIED BY 'smuserpw';

Give that user all permissions on the SMCP database:

GRANT ALL on servmgr.* to 'smuser'@'%';

Last thing: now add a record to the smcpcontrols database to allow your links to work (adjust the user and password if you used something different than the sample) - this assumes your server is 'localhost' - adjust as needed:

INSERT INTO smcpcontrols.companydatacredentials (

sdatabasename

, sdatabaseurl

, sdatabaseport

, sdatabaseuser

, sdatabaseuserpw

, sdatabaseid

, scomment

) VALUES (

'servmgr'

, 'localhost'

, '3306'

, 'smuser'

, 'smuserpw'

, 'smdb'

, 'Our Company SMCP Database'

)

Now, assuming your server is at 'localhost', on port 8080, this link should bring you to the login screen:

http://localhost:8080/sm/smcontrolpanel.SMLogin?db=smdb