SQL2
INSTRUCTOR VINAY NOAH Create new user and grant permission to access the specific database + 1 2 3 4 create user felightadmin identified by "felightrocks" ; grant All ON felight . * to felightadmin ;
Posts
SQL1
Creating a Database, Using it & Droping Database MySQL mq> create database felight; + In the above query felight is the database name. After creating the database suppose if want to create table in it then you should be inside it. Which we can do by executing below query. + mq> use felight; + Below query is used to drop (or delete) database execute below query. WARNING: Beware the once you drop a database you can revert from it or you can not recover. + mq> drop felight; I expect you to have MySQL installed in your laptop or in you system and make use of console only for our further practice session. + The reason I am using console is because + 1. Irrespective of any UI is available or not, we can always log into SQL Console. + 2. If you practice using console then you will understand the concepts more clearly then you would do by using the softwares like Apex, phpmyadmin, sqldeveloper etc. These tools you should start using to once you master ...