Ikasten.IO
Learning, Aprendiendo

What’s the default password of root user in mariadb? 8 Enero, 2017

If you have just installed mariadb, you should run this command in order to set a password for the root user and secure your installation:

Besides asking you to provide the new root password, this utility will help you to remove anonymous user (created by default, intended for testing), disallow root login remotely (root should only be allowed to connect from ‘localhost’), remove test database and privileges ad reloading the privilege table. All of it just pressing the Enter key a couple of times 🙂 Not bad!

If that process doesn’t work, try this other one:

(using sudo, don’t specify any password)

Create a new database:

Grant privileges to a new user:

 

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *