We typically recommend that you create a read-only trevor database user that Trevor can connect as. You can do this easily by running the below commands against your MySQL database:
-- STEP 1. Create user with password
CREATE USER 'trevor' IDENTIFIED BY your_secure_password;
-- STEP 2. Ensure that the user has strictly read-only privileges
GRANT SELECT, SHOW VIEW ON database_name_you_want_to_connect_to_trevor.* TO 'trevor';
Comments
0 comments
Please sign in to leave a comment.