Setup mySQL Database: Difference between revisions
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...") |
(No difference)
|
Revision as of 17:43, 27 August 2015
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');