phpMyAdmin on Mac cannot connect to the database created by itself
去如烟
去如烟 2019-04-07 21:44:07
0
6
1211

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

去如烟
去如烟

reply all(3)
Peter-Zhu

MAMP PRO supports users to set commonly used ports:

Jietu20190408-103427.jpg

去如烟

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

秋香姐家的小书童

Reinstall it

  • reply No need to reinstall
    去如烟 author 2019-04-07 22:15:59
  • reply 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.
    去如烟 author 2019-04-07 22:18:58
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template