MySQL Forums
Forum List  »  Newbie

Re: How do i access mysql from outside?
Posted by: Muhamad Ridwan
Date: November 14, 2021 04:40PM

Use a GRANT command in the following format to enable access for the remote user. Ensure that you change 1.2.3.4 to the IP address that you obtained previously, and my_password to the password that you want fooUser to use:

mysql> GRANT ALL ON fooDatabase.* TO fooUser@'1.2.3.4' IDENTIFIED BY 'my_password';

Regards, Muhamad Ridwan

Options: ReplyQuote


Subject
Written By
Posted
Re: How do i access mysql from outside?
November 14, 2021 04:40PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.