Sunday, April 11, 2010

#Setting Up root password for the first time:
mysqladmin -u root password "newpassword"

#Change MySQL password:
mysqladmin -u root password "newpassword" -p
Enter Passsword: ******* <<> update user set password=PASSWORD("dheeraj") where User='dheeraj';

#Create Database:
create database "database name";
i.e-> create database hello;

#Show database:
show databases;

#Show Tables:
use mysql;
show tables;

#Show password:
select user,password from user;

#Show host:
select User,password,host from user;
select * from user where user="dheeraj";

No comments:

Post a Comment