phpMyAdmin throws an error whe I try to log in using remote IP.
If I set localhost in setting I am succeed to log in phpMyAdmin. I didn't have this error lately. It started when I updated OpenServer.
Asked
Active
Viewed 54 times
0
nbk
- 31,930
- 6
- 24
- 40
Denis_54213213
- 7
- 2
-
root has usually all privileges which makes it very dangerous to allow access from everywhere, so it is usually restricted to localhost. – nbk Oct 04 '20 at 15:38
-
And how I can be able to log in ? what login and password should use ? – Denis_54213213 Oct 04 '20 at 15:43
-
1Does this answer your question? [Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server](https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server) – Progman Oct 04 '20 at 15:46
-
Where should I write in it in OpenServer ? – Denis_54213213 Oct 04 '20 at 15:51
-
you have to run the command in the link directly in mysql – nbk Oct 04 '20 at 15:52
-
Where is mysql folder located in OpenServer ? – Denis_54213213 Oct 04 '20 at 16:00