Add a new blog
October 23

Create a MySQL user to have both local and remote access for all databases

Create a mysql user:   CREATE USER 'myUser'@'localhost' IDENTIFIED BY 'YourNewPassword';  CREATE USER 'myUser'@'%' IDENTIFIED BY 'YourNewPassword'; Then GRANT ALL ON *.* TO 'myUser'@'localhost';  GRANT ALL ON *.* TO 'myUser'@'%'; Optional: limit user to single database: GRANT ALL ON name_of_database.* TO 'myUser'@'localhost'; GRANT ALL ON name_of_database.* TO 'myUser'@'%'; Don't forget to flush:  FLUSH PRIVILEGES; Tips: optional for MySQL 8.0 if using 3rd party remote access with error "Authentication plugin 'caching_sha2_password' cannot be...

October 23

Query to enable a single user to access a remote MySQL database

Create a remote user for single DB access. GRANT ALL PRIVILEGES ON new_db.* TO 'new_db_user'@'%' IDENTIFIED BY 'YourUserPassword'; FLUSH PRIVILEGES; ...

Send us a message. We will reply as soon as we can.