To recover your MySQL or MariaDB root password, you will need: While this tutorial’s instructions may work with other system or database server versions, they have been explicitly tested with Ubuntu 18.04 and distribution-supplied packages. The procedure for changing the root password differs depending on whether you have MySQL or MariaDB installed and the default systemd configuration that ships with the distribution or packages from other vendors. This tutorial demonstrates how to reset the root password for MySQL and MariaDB databases installed with the apt package manager on Ubuntu 18.04. Only if the default configuration for authentication was altered, and this results in an access denied error, follow the steps in this tutorial.
Before you reset your database root password, try to access the database with the sudo mysql command.
In this scenario, it may not be necessary to reset the password. Note: On fresh Ubuntu 18.04 installations, the default MySQL or MariaDB configuration usually allows you to access the database (with full administrative privileges) without providing a password as long as you make the connection from the system’s root account.
0 kommentar(er)
