Posts

Showing posts from December, 2015

Mysql Basic Commands

How to install MySQL in RHEL and Centos # yum install mysql* -y ----------------------------------------------------- How to start MySQL # service mysqld start # /etc/init.d/mysqld start ---------------------------------------------------- How to set root password in MySQL # mysqladmin password "redhat" ---------------------------------------------------- How to Login in Mysql # mysql -u root -predhat mysql> ---------------------------------------------------- How to change root and Users password mysql> UPDATE mysql.user SET Password=PASSWORD('redhat123') WHERE User='root'; ----------------------------------------------------------------------------------------- How to Create database mysql> create database DB-NAME; How to Check database mysql> show databases; How to Create User mysql> CREATE USER 'USER_NAME'@'localhost' IDENTIFIED BY 'PASSWORD'; How to given PRIVILEGES mysql> GRANT ALL PRIVILEGES ON `DB-NAME` . * TO