[root@centos71 ~]# mariadb -u myuser -p123 -h 127.0.0.1 -P 4006 sales-main

ERROR 1044 (42000): Access denied for user 'myuser'@'127.0.0.1' to database 'sales-main'

[root@centos71 ~]# mariadb -u myuser -p123 -h 127.0.0.1 -P 4006

Welcome to the MariaDB monitor.  Commands end with ; or \g.

MariaDB [(none)]> use sales-main

Database changed

MariaDB [sales-main]> show tables;

+-------------------+

| Tables_in_sales-main |

+-------------------+

| t1                |

+-------------------+

1 row in set (0.003 sec)

MariaDB [sales-main]> show grants;

+---------------------------------------------------------------------------------------------------------+

| Grants for myuser@%                                                                                   |

+---------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO `myuser`@`%` IDENTIFIED BY PASSWORD '*password' |

| GRANT ALL PRIVILEGES ON `sales-%`.* TO `myuser`@`%`                                                      |

+---------------------------------------------------------------------------------------------------------+

2 rows in set (0.002 sec)