#mysql -u root -p
when prompted for the password ...enter the pw
though connecting to mysql as root is not recommended at all.
Create a super user by
GRANT ALL ON *.* TO user@localhost IDENTIFIED BY "userpassword"
WITH GRANT OPTION
This is a much safer way
You can also specify which host the user can connect to mysql
Take care and caution : if you give user2 GRANT ALL privelege on a db with
GRANT OPTION
then that user2 can give GRANT *.* to user3
Regards,
Sunil Dhaka
----------------------------------------------
Find out more about this and other Linux India
mailing lists at http://lists.linux-india.org/
