How to add a mysql user to a mysql server via the command line. Identify the access IP(s) you are wishing to connect from, and
privileges to do what it needs to do. Or you can use the host "%" to mean "from everywhere". And use '%' not "%".

Example Command Line

mysql> create user 'your_username'@'%' identified by 'your_pass';
mysql> grant all on yourdb.* to 'your_user'@'%';