MYSQL Interview Questions | MYSQL Interview Questions and Answers

MYSQL Interview Questions

mysql> drop database databasename;

mysql> SELECT SUM(*) FROM [table name];

mysql> drop table tablename;

mysql> SELECT * FROM tablename;

mysql> show columns from tablename;

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv)
VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
mysql> flush privileges;
or
mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

# mysqladmin -u root password newpassword

# mysqladmin -u root -p oldpassword newpassword

# mysql -u root -p
mysql> use mysql;
mysql> grant usage on *.* to sonia@localhost identified by 'passwd';
mysql> flush privileges;

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

All rights reserved by WsCube Tech