creating a mysql dedicated user to either manage database locally or remotely on ubuntu 20.04

Hi @samunyi90,

First, you need to create the user and give him privileges to use/manage the databases you want. In the tutorial this can be found at STEP 3 - Creating a Dedicated MySQL User and Granting Privileges.

Now, if you’ve done that, you need to allow access from outside to your MySQL, the best way is to allow only your IP address.

Next, think you need to check is, if the password you used is correct. More often than not, this is the issue.

Next thing, I’ve seen happen is

mysql -u DBuser -p mypass

Whitespace IS apparently allowed between the -u #uname# but NOT between the -p and #password#

Therefore needed:

mysql -u DBuser -pmypass

Otherwise with white-space between -p mypass mysql takes ‘mypass’ as the db name OR you can use the following command

mysql -u DBuser -p DBname -h XXX.XXX.XXX.XXX

Additionally, can you post the command you used to create the user?