Setup mySQL Database: Difference between revisions

Latest revision as of 18:09, 27 August 2015

moved

@@ 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');