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
WsCube Tech is the leading IT training institute and software development company in India. With headquarters in Jodhpur, it is on a mission to skill, reskill, and upskill individuals in the ever-evolving technology domains.
Subscribe to our newsletter to receive the latest updates and offers.
All rights reserved by WsCube Tech