Powershell – Small issue with the Domain Name System (DNS) Server Cmdlets

Windows DNS will auto configure certain records based on whether your server has a FQDN or not. Example the NS and SOA and A record for the DNS server. Looks like you just installed the machine and the DNS role. You haven't given it a name other than the auto assigned WIN-EG75FS9C2F2 random name. Once you give it a FQDN like server.domain.com, DNS will be able to add records into any zones you create in DNS.

mysql> select User,Host from user where user like '%core%';
+------------+-----------+
| User       | Host      |
+------------+-----------+
| ro_ml_core | %         |
| ro_ml_core | localhost |
+------------+-----------+
2 rows in set (0.00 sec)

It is necessary to have both (% and localhost) accounts for ro_ml_core to be able to connect from anywhere as ro_ml_core. Without the localhost account, the anonymous-user account for localhost that is created by mysql_install_db would take precedence when ro_ml_core connects from the localhost. As a result, ro_ml_core would be treated as an anonymous user. The reason for this is that the anonymous-user account has a more specific Host column value than the 'ro_ml_core'@'%' account and thus comes earlier in the user table sort order.

About sort order:

The server uses sorting rules that order rows with the most-specific Host values first. Literal host names and IP addresses are the most specific. (The specificity of a literal IP address is not affected by whether it has a netmask, so 192.168.1.13 and 192.168.1.0/255.255.255.0 are considered equally specific.) The pattern '%' means "any host" and is least specific. The empty string '' also means "any host" but sorts after '%'. Rows with the same Host value are ordered with the most-specific User values first (a blank User value means "any user" and is least specific).