Reset the MySQL OR MariaDB Root Password
  easystem   15 Maret 2018   fix error

To change the MySQL/MariaDB root password, follow these steps:

  1. Ensure that the MySQL/MariaDB server is running.

  2. Open a new Linux terminal.

  3. Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax:

    mysqladmin --user=root password "newpassword"

    OR
    ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret")

Tags :

mysql , cmd , sql , query

Bagikan :