MySQL

Reset MySQL root pwd

Posted on

Resetting MySQL Root Password: Red Hat and CentOS If you’ve forgotten your MySQL root password (or are involved with some nefarious activity), here is how you can reset that password on a Red Hat (RHEL) system or a CentOS system: Stop MySQL: root#  service mysqld stop Start MySQL in safe mode: root#  mysqld_safe –skip-grant-tables & […]

MySQL

Use mysqladmin command to change root password

Posted on

If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows: $ mysqladmin -u root password NEWPASSWORDHowever, if you want to change (or update) a root password, […]

MySQL

Common MySQL Commands

Posted on

Common Useful MySQL Commands Applicable to Centos Versions: Centos 5.x Centos 6.x Requirements Explanation of requirements.  MySQL and MySQL-server installed on a Centos 5.x system DBA access rights to MySQL on a Centos 5.x system Doing the Work Basic description of what will be done and what is expected. Database file locations: In Centos 5.x […]

MySQL

Change MySQL root PWD

Posted on

Use mysqladmin command to change root password If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:$ mysqladmin -u root password NEWPASSWORDHowever, if you want to […]