Tag Archives: flush privileges

Mysql useful production query script

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… Read More »