Answer the question
In order to leave comments, you need to log in
How can I restrict logging in to this account to anyone but the server system?
Hello, I came across such a problem, it costs openserver, it has mysql with databases, there are also system accounts there, the problem is that anyone who goes to the phpmyadmin page can enter mysql login, and will get full access to the databases, How can I make sure this doesn't happen?
PS if I delete this account, then I will not be able to do anything on the server, because there will be a lot of errors
Answer the question
In order to leave comments, you need to log in
I solved the problem by blocking the mysql account by entering the command
ALTER USER 'mysql'@'localhost' ACCOUNT LOCK;
ALTER USER 'mysql'@'::1' ACCOUNT LOCK;
ALTER USER 'mysql'@'127.0.0.1' ACCOUNT LOCK;
open server is a developer package. If you raise production on this, then it’s sooo in vain ...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question