How to change the administrator password by mysql

This article mainly explains the "mysql how to change the administrator password", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql how to change the administrator password" bar!

Mysql modifies the administrator password

Kill the mysql process

Kill `cat / data/mysqldata/3306/ mysql.pid`

Disable connection disable authentication mode to start mysql

Mysqld_safe-defaults-file=/data/mysqldata/3306/my.cnf-skip-grant-tables-skip-networking&

Change the administrator password (this environment has renamed the administrator to system)

Mysql

Update mysql.user set password=password ('xxxxxx') where user='system'

Restart mysql

Mysqladmin shutdown

Mysqld_safe-- defaults-file=/data/mysqldata/3306/my.cnf &

Thank you for your reading, the above is the content of "how to change the administrator password in mysql". After the study of this article, I believe you have a deeper understanding of how to modify the administrator password in mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!