R Programming By Example

Setting up user/password in both Linux and macOS

Once you have the MySQL database installed on your computer, you need to make sure that you can access it with an explicit user/password combination. If you have already set them up, you should be able to access the database as shown ahead.

The <YOUR_PASSWORD> value is shown in the second line and without Command Prompt ($) because it should not be included in the first line, and you should wait for MySQL to request it, which is usually after you execute the first line, and this is done with an invisible prompt, meaning that you won't see what you are typing (for security reasons):

$ mysql -u <YOU_USER> -p
<YOUR_PASSWORD>

If you see information similar to what is shown ahead and you get Command ...