I recently acquired a running PIWIK system however I had to recover just about everything. I have since given myself root access to both my VM and Mysql server. However when I update the config.ini file with the new Database connection info it doesn’t seem to take. I continually get
SQLSTATE[HY000]  Can’t connect to MySQL server on ‘127.0.0.1’ (111)
when attempting to login. I can access the database just fine with my new root password but I can’t seem to give that data to the piwik config files to it can use it.
I updated the config.ini to and am now kind of at a loss on what I need to do to get piwik to use this new configuration data. IF it matters the previous config was using a salt under General.
host = 127.0.0.1
username = root
password = xxxxxxxx
dbname = piwik
tables_prefix = piwik_
Thanks in advanced