Skip to content

Instantly share code, notes, and snippets.

@d4n13lbc
Last active October 16, 2017 22:03
Show Gist options
  • Save d4n13lbc/fcd4db8ef3bb9495d68b88051454e092 to your computer and use it in GitHub Desktop.
Save d4n13lbc/fcd4db8ef3bb9495d68b88051454e092 to your computer and use it in GitHub Desktop.

Configuración de MariaDB para acceso remoto

root@db_server>/usr/bin/mysql_secure_installation
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'@'192.168.56.101' IDENTIFIED by '12345';  
MariaDB [mysql]> use mysql;  
MariaDB [mysql]> select * from user;  

MariaDB [mysql]> exit  

http://www.2daygeek.com/start-stop-restart-enable-reload-mysql-mariadb-server-service-in-linux/#

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