alter table [tablename] add [columnname] varchar (20); Add a new column to a table. alter table [tablename] drop [columnname]; Delete a column from a table. alter table [tablename] change [columnname] [newcolumnname] varchar (20); Change a…

mysql -u [username] -p; Login a sql server. show databases; List all databases on the sql server. create database [databasename]; Create a database on the sql server. drop database [databasename]; Delete a database on the sql server. grant…

To setup root password for first time, use mysqladmin command at shell prompt as follows: $ mysqladmin -u root password NEWPASSWORD MySQL Change root Password