Differences

This shows you the differences between two versions of the page.

--- сервис_mysql [2020/10/06 14:55]
val [Из командной строки]
+++ сервис_mysql [2024/09/02 05:39] (current)
val [Debian/Ubuntu]
@@ Line 9: / Line 9: @@
 <code>
-debian10# apt install default-mysql-server
+debian# apt install default-mysql-server
-server# apt install mysql-server
+ubuntu20# apt install mysql-server
 </code>
@@ Line 61: / Line 61: @@
 ===== Смена пароля пользователя 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?]]
+==== MariaDB ====
+<code>
+MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
+MariaDB [(none)]> SET PASSWORD = PASSWORD('12345678');
+# 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”]]
@@ Line 69: / Line 80: @@
 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678';
 </code>
-==== До версии 5.7 ====
+==== MySQL, до версии 5.7 ====
 <code>
 # mysqladmin --user=root password somepassword

Методические материалы Лохтурова Вячеслава