User Tools
сервис_mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
сервис_mysql [2020/10/06 14:55] val [Из командной строки] |
сервис_mysql [2021/03/12 10:34] val |
||
|---|---|---|---|
| Line 61: | Line 61: | ||
| ===== Смена пароля пользователя root ===== | ===== Смена пароля пользователя root ===== | ||
| - | ==== Начиная версии 5.7 ==== | + | * [[https://mariadb.com/kb/en/authentication-plugin-unix-socket/|Authentication Plugin - Unix Socket]] |
| * [[https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/|How to reset your MariaDB root password?]] | * [[https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/|How to reset your MariaDB root password?]] | ||
| + | ==== MariaDB ==== | ||
| + | |||
| + | <code> | ||
| + | MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password; | ||
| + | |||
| + | MariaDB [(none)]> SET PASSWORD = PASSWORD('ewsgh3sd'); | ||
| + | |||
| + | # service mysql restart | ||
| + | </code> | ||
| + | |||
| + | ==== MySQL, начиная c версии 5.7 ==== | ||
| + | |||
| * [[https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/|Change user password in MySQL 5.7 with “plugin: auth_socket”]] | * [[https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/|Change user password in MySQL 5.7 with “plugin: auth_socket”]] | ||
| Line 69: | Line 80: | ||
| ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678'; | ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678'; | ||
| </code> | </code> | ||
| - | ==== До версии 5.7 ==== | + | ==== MySQL, до версии 5.7 ==== |
| <code> | <code> | ||
| # mysqladmin --user=root password somepassword | # mysqladmin --user=root password somepassword | ||
сервис_mysql.txt · Last modified: 2021/10/12 10:28 by val
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
