piwik: 不能连接mysql数据库

此前运行正常的piwik系统,周末突然发现不工作了,提示:

错误1030,不能连接mysql数据库。

大吃一惊,ssh登陆服务器,mysql登陆后发现数据库都还正常,用root账号可以查看。

同时用:

mysql -upiwik -p -h localhost

 

这个也可以正常工作,非常奇怪。

但用这个则不能登陆:

mysql -upiwik -p -h 127.0.0.1

 

于是修改config.ini.php,修改连接参数,可以正常启用。

但发现本机别的mysql应用都正常,估计是mysql user的问题,于是重新添加该用户,授权到对应host也可以解决此问题。

grant all privileges piwik.* to 'piwik'@'127.0.0.1' identified by 'passwd'

 


已发布

分类

来自

标签:

评论

《 “piwik: 不能连接mysql数据库” 》 有 14 条评论

  1. itstitle

    excerptsa

  2. order enclomiphene cheap online no prescription

    buying enclomiphene no prescription overnight delivery

  3. acheter kamagra bonne

    sans ordonnance kamagra comprime pharmacie ordonnance

  4. how to order androxal buy online canada

    buy androxal in United Kingdom

  5. buying dutasteride usa cheap

    Buy dutasteride no perscription needed

  6. get flexeril cyclobenzaprine canadian sales

    how to buy flexeril cyclobenzaprine generic in usa

  7. buy gabapentin cheap canada pharmacy

    how to buy gabapentin cheap buy online no prescription

  8. order fildena purchase australia

    buying fildena australia generic online

  9. discount itraconazole purchase discount

    ordering itraconazole uk suppliers

  10. how to buy staxyn generic from canadian pharmacy

    purchase staxyn canadian sales

  11. cheapest buy avodart generic discount

    buying avodart lowest price

  12. buying xifaxan generic drug

    online order xifaxan medication interactions

  13. ordering rifaximin generic in usa

    ordering rifaximin canada cost

  14. kupte si kamagra žádný skript

    hwat ise cena kamagra

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注