Skip to content

Instantly share code, notes, and snippets.

Last active Oct 16, 2017
What would you like to do?

Configuración de MariaDB para acceso remoto

Enter current password for root (enter for none): <enter>
Set root password? [Y/n] <Y>
New password: <distribuidos>
Re-enter new password: <distribuidos>
Remove anonymous users? [Y/n]  <Y>
Disallow root login remotely? [Y/n] <n>
Remove test database and access to it? [Y/n] <n>
Reload privilege tables now? [Y/n] <Y>

mysql -u root -p  
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* to 'icesi'@'' IDENTIFIED by '12345';  
MariaDB [mysql]> use mysql;  
MariaDB [mysql]> select * from user;  

MariaDB [mysql]> exit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment