All geek questions in one place

New users cannot log in to PHPmyadmin

I am currently having a problem with the ability to log in multiple users using phpmyadmin without viewing the databases. I use this method: http://alandoyle.com/tutorials/configuring-phpmyadmin-for-multiple-users/

Although this method works for the most part, although when creating a new user, where I check "Grant all privileges to a wildcard name (username_%)", the choice does not allow me to log in with this user if I do not specify a password and turn on "$ cfg ['Servers'] [$ i] ['AllowNoPassword'] ".

What I tried:

I tried to create the same user where I won’t check it, but while I can log in, I see all the root databases. In contrast, when I do not select a password, and I can only see the databases related to this user.

+6
source share
4 answers

EDIT: I found that setting the LOCALHOST user seems to fix this problem. Using ANYHOST for some reason does not work for local logins.

I have the same problem after changing my password on my test server. I can no longer connect to new users. I was messing around, but I think this might have something to do with adding blowfish security or something.

My PHP scripts also cannot connect. I also can’t give all new privileges to new users. I'm not sure what I did to make this happen. I have outdated users who can achieve this.

+18
source

You MUST have BOTH localhost and% for each user. Only then can you log in locally from other hosts or client programs. This is why you find that the root user has so many entries.

Steps to solve this problem:

  • login to phpmyadmin using root
  • Choose privileges
  • Select the user you want to change (for example, to grant log access rights).
  • If you already passed the host like any (%), now change it to localhost.
  • Make sure you click the "keep old" button and update

Here is a screenshot showing the settings I am referring to. enter image description here Now log out and log in as a new user.

+13
source
  • You need to create mySql users
  • You need to grant mySql privileges to each user for their own databases only.
  • Then I suggest you make simple form identification in phpMyAdmin

So, all (grants) privileges, I think, should be managed from mySql, and not in any other way ...

0
source

When you select the rights of a new user, check the GRANT flag if you want to enable the user.

0
source

Source: https://habr.com/ru/post/887510/

More articles:


All Articles