Setup mySQL Database: Difference between revisions

From MyLVS
Jump to navigation Jump to search
(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...")
 
 
Line 1: Line 1:


==Create the Database and the Users==
moved
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');

Latest revision as of 18:09, 27 August 2015

moved