CentOS6.5 the MySQL initial password through shell, turn on remote login, authorize Telnet user

CentOS6.5 under the shell to modify the MySQL initial password, open remote login, authorized Telnet users;

Recently writing a shell script for an automated deployment, you need to modify the MySQL initial password through the shell, turn on remote logins, authorize Telnet users,

After some search and experiment, get the following several commands to share with you:

To modify the initial password:
MYSQLADMIN-UROOT-PVYCE2UWSAQX3XOFR password "123456"


Enable remote login to authorize Telnet users:
MYSQL-UROOT-PROOT-E "Grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT option;"


To make an authorization effective immediately:
MYSQL-UROOT-PROOT-E "flush privileges;"

CentOS6.5 the MySQL initial password through shell, turn on remote login, authorize Telnet user