I have grafana 4.4.3 on an ubuntu 16.4 LTS which is installed on an vm and its IP is 220.127.116.11 . I also have a mysql database version 5.0.95 on a CentOS 5.9 and its ip is 18.104.22.168 and mydatabase name is : voip
I want to set mysql as backend for grafana. I’v changed my grafana.ini file like this:
type = mysql
host = 22.214.171.124:3306
name = voip
user = root
password = t@123
I also set my root account to be used as a remote account.
when I want to start grafana-server service, it gives me this error:
Fail to initialize orm engine" logger=sqlstore error=“Sqlstore::Migration
failed err: this user requires old password authentication. If you still
want to use it, please add ‘allowOldPasswords=1’ to your DSN. See also
I also checked to see if my allowOldPasswords is set to 1 or not and it was set.
what should I do? Did I don anything wrong?