💡 💾 Cambiar password root y plugin mysql native password mariadb
💡 💾 Cambiar password root y plugin: mysql native password mariadb
Por defecto el usuario root tiene password invalido, es necesario establecer un nuevo password al usuario root, puede ser un password vacio "", o crear nuevo usuario y contraseña.
select user,host,password,plugin,authentication_string from mysql.user;
use mysql;
alter user root@localhost identified via mysql_native_password;
alter user "root"@"localhost" identified by "password";
flush privileges;
select user,host,password,plugin,authentication_string from mysql.user;
use mysql;
update user set authentication_string=PASSWORD("") where user = "root";
update user set plugin="mysql_native_password" where user = "root";
flush privileges;
https://stackoverflow.com/questions/5...
Otras formas:
sudo /etc/init.d/mariadb start
sudo /etc/init.d/mysql start
sudo mysqladmin --user=root password "123"
mysqladmin.exe -u root password secret