search

Home  >  Q&A  >  body text

phpMyAdmin on Mac cannot connect to the database created by itself

When I connect to navicat, there are 6 databases displayed. Why can’t PHP connect? Moreover, I have changed the secret of the database, but one suddenly appears on phpMyAdmin, root user and root secret. New user

去如烟去如烟2089 days ago1196

reply all(6)I'll reply

  • 天蓬老师

    天蓬老师2019-04-08 10:35:03

    MAMP PRO supports users to set commonly used ports:

    Jietu20190408-103427.jpg

    reply
    0
  • 去如烟

    去如烟2019-04-07 22:15:35

    Re-describe the problem: MAMP PRO comes with a MySQL database, and I also installed one locally. What I saw in phpMyAdmin is that it comes with MAMP PRO. The port is 8889, the user is root, and the password is root. The port I installed myself is 3306, root + custom password. Thinking something was wrong, I changed the password of phpMyAdmin and found that phpMyAdmin could not be opened, but navigat could be opened. Then I took a look, This page That’s not right. Why hasn’t the password I changed changed? ? ? ?

    屏幕快照 2019-04-07 下午10.12.09.png

    reply
    0
  • 秋香姐家的小书童

    秋香姐家的小书童2019-04-07 22:04:21

    Reinstall it

    reply
    0
    • 去如烟

    No need to reinstall

    — 去如烟 · 2019-04-07 22:15:59
    去如烟

    In fact, changing the password in phpMyAmin is changing the MySQl database. In the picture above, the password should be changed in the configuration. Only when these two user passwords are matched can phpMyAmin be opened.

    — 去如烟 · 2019-04-07 22:18:58
  • Cancelreply