#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";
Sunday, April 11, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment