Skip to content

Instantly share code, notes, and snippets.

@pihomeserver
Created June 6, 2018 13:44
Show Gist options
  • Save pihomeserver/418653f149c1a7ecb6aabc434dbefc4f to your computer and use it in GitHub Desktop.
Save pihomeserver/418653f149c1a7ecb6aabc434dbefc4f to your computer and use it in GitHub Desktop.
MySQL / MariaDB - Remote root access
Allow remote connection
1) As root user execute (replace password)
```
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
```
2) In file /etc/mysql/mariadb.conf.d/50-server.cnf comment line
```
#bind-address = 127.0.0.1
```
3) Restart service
```
service mariadb restart
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment