M
M
Mark Eshkilev2021-08-16 15:57:33
MySQL
Mark Eshkilev, 2021-08-16 15:57:33

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 611a6070e3d31487013561.pngproblem 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

2 answer(s)
M
Mark Eshkilev, 2021-08-16
@mark_edinoroglove

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;

R
Ruslan Fedoseev, 2021-08-16
@martin74ua

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 question

Ask a Question

731 491 924 answers to any question