- Enable remote access from any IP
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 127.0.0.1
127.0.0.1 Changed to * o 0.0.0.0 to accept connections from outside.
- Create certificate files:
sudo mysql_ssl_rsa_setup -v
- Create a user from anywhere (using %):
mysql> CREATE USER ‘unusuario’@’%’ IDENTIFIED BY ‘pass1234’ ;
mysql> GRANT ALL PRIVILEGES ON . TO ‘unusuario’@’%’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> SELECT user FROM mysql.user;
mysql> SHOW GRANTS FOR ‘unusuario’@’%’;
- Check connections
$ mysqladmin version
$ mysqladmin -h 192.168.2.86 –port=3306 version -u unusuario -p
- Create sample database
mysql> CREATE DATABASE proyecto;
mysql> USE proyecto
mysql> CREATE TABLE robot (t_tobot FLOAT(20), consumo FLOAT(20), timestamp TIMESTAMP);
- This is a reminder for Grafana
cat /etc/default/grafana-agent
go to integrations
section
mysqld_exporter:
enabled: true
data_source_name: "unusuario:put-password-here@(localhost:3306)/"
sudo systemctl status grafana-agent.service