Entries from 2012-01-01 to 1 month

MySQL commands I learned today.

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 commands I learned today.

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…

How to set a root password for MySQL.

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

Test Post

This is a test post.