Setup mySQL Database

From MyLVS
Revision as of 17:43, 27 August 2015 by Admin (talk | contribs) (Created page with " ==Create the Database and the Users== Create the database, login into myslq: # mysql -u root -p On the SQL prompt type: mysql> create database mylvs; Create the default my...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Create the Database and the Users

Create the database, login into myslq:

# mysql -u root -p 

On the SQL prompt type:

mysql> create database mylvs;

Create the default mylvs user using the password = demo:

mysql> GRANT ALL PRIVILEGES ON mylvs.* TO mylvsuser@localhost IDENTIFIED BY 'demo';

Add the demo user into myLVS, table tblUsers:

mysql> insert into tblUsers (userID,name,operations,logview,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1','1');