Différences

Ci-dessous, les différences entre deux révisions de la page.

--- info:mysql:changer_son_mot_de_passe_mysql [2023/03/20 14:28] – radeff
+++ info:mysql:changer_son_mot_de_passe_mysql [2024/02/29 08:39] (Version actuelle) – radeff
@@ Ligne 1: / Ligne 1: @@
-====== password: Changer son mot de passe MySQL ======
+====== Changer son mot de passe MySQL ======
 On peut changer facilement son mot de passe depuis phpmyadmin:
@@ Ligne 11: / Ligne 10: @@
   SET PASSWORD FOR monty@host = password( 'new_password' );
+===== change password for user lambda =====
+<code>
+mysql -u root -p
+use mysql;
+update user set password=PASSWORD("NEWPASSWORD") where User='lambda';
+</code>
+===== change root password not having it =====
+vous avez perdu le password root et vous ne voulez pas réinstaller mysql en faisant un backup des tables? rien de plus simple
+source: http://www.cyberciti.biz/tips/recover-mysql-root-password.html
+<code>
+Step # 1 : Stop mysql service
+# /etc/init.d/mysql stop
+Output:
+Stopping MySQL database server: mysqld.
+Step # 2: Start to MySQL server w/o password:
+# mysqld_safe --skip-grant-tables &
+Output:
+[1] 5988
+Starting mysqld daemon with databases from /var/lib/mysql
+mysqld_safe[6025]: started
+Step # 3: Connect to mysql server using mysql client:
+# mysql -u root
+Output:
+Welcome to the MySQL monitor.  Commands end with ; or \g.
+Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
+Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
+mysql>
+Step # 4: Setup new MySQL root user password
+mysql> use mysql;
+mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
+mysql> flush privileges;
+mysql> quit
+</code>
 {{tag>password security mysql}}