I have a MySQL account, but I can only access it internally using 127.0.0.1. How can I enable remote access for users in a MySQL database so that I can use my local computer to access the database on the server
1 Answers
Log in to your MySQL using root or other administrator users:
mysql -u root -p123456
MySQL>use mysql;
MySQL>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION ;
MySQL>FLUSH PRIVILEGES;
Taking the root user as an example, you can replace it with your own user
Related Questions
mySQL RROR 2006 (HY000) at line XX MySQL server has gone away
1 answers
How to set foreign key constraints in MySQL?
1 answers
How to install Redis in Docker?
1 answers
mysql error：Your password has expired
1 answers
ERROR : MySQL server has gone away
1 answers
How to enable remote access for users in MySQL database
1 answers