Prometheus and Grafana : Monitor MySQL/MariaDB
1.Install MySQL Exporter #curl -s https://api.github.com/repos/prometheus/mysqld_exporter/relea…
1.Install MySQL Exporter #curl -s https://api.github.com/repos/prometheus/mysqld_exporter/relea…
issue : “The MySQL80 service on Local Computer started and then stopped. Some services stop au…
MySQL Server (Master) IP : 192.168.0.1 MySQL Server (Slave) IP : 192.168.0.2 1. Install MySQL in…
Issue: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for…
1. Adding the MySQL Yum Repository Centos 8 - #wget https://repo.mysql.com/mysql80-…
Solution: 1.Log in to MySQL console with root user #mysql -u root -p 2.Created a new user …
Issue: mysql_connect(): Too many connections Solutions: directly connect to the mySQL serv…
Error : "Host is blocked because of many connection errors" Solutions : # mysql -u …
Problems Table 'mysql.servers' doesn't exist at ../web-lib-funcs.pl Solution #…
Error: [ERROR] /usr/libexec/mysqld: Table './syslog/syslog_incoming' is marked as crash…
Error : Cannot load from mysql.proc. The table is probably corrupted Solution : #mysql_upgrade …
1. Stop mysql service # service mysqld stop 2. Move mv /var/lib/mysql/mysql.sock /var/lib/mysql…
Problems nagios error : ./nagios/nagios_servicechecks' is marked as crashed and should be …
Problems : 121129 10:15:13 InnoDB: Using Linux native AIO /usr/libexec/mysqld: Can't create/…
Resolved: # edit /my.ini Add: [mysqld] skip-name-resolve OR Disable: # bind-address = 127.0.0.1 …
Quick PHP code to test ldap connection $ldap = ldap_connect(“domain.com”); $username=”username@d…