Hello All,
For a new build I am seeing that mysql_install_db is putting entries in user table
where user="" in addition to the correct entries for root. See below
mysql> select * from user where user="";
+-------------------------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv
| Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv |
File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv |
Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv
| Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject |
max_questions | max_updates | max_connections |
+-------------------------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| localhost | | | N | N | N
| N | N | N | N | N | N |
N | N | N | N | N | N | N
| N | N | N | N |
N | | | | | 0 |
0 | 0 |
| testd4.aaaaa.com | | | N | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N
| | | | | 0 | 0 |
0 |
+-------------------------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
This is creating problem in conencting when I use -h <full-domain-name>. For localhost
it work.
Any reason that MySQL is creating these entries in addtion to the correct entries for
root.
Any explanation???
Regards,
