mysql remote access issue

[lirn]

Hi Team, I cannot login the MYSQL today,would you please help to dig out what happened to my database. many thanks.

 

domain: lirn.heliohost.org 

I've added the '%' to the access hosts

[Krydos]

mysql> select user, host from mysql.user where user like 'lirn%';

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

| user      | host                |

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

| lirn      | %                   |

| lirn_dong | %                   |

| lirn      | localhost           |

| lirn_dong | localhost           |

| lirn      | tommy.heliohost.org |

| lirn_dong | tommy.heliohost.org |

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

6 rows in set (0.00 sec)

Have you tried changing the password?

[lirn]

got it ,I think the domain has been changed from lirn.heliohost.org  to tommy.heliohost.org, but I don't know why.

[Krydos]

We always recommend using tommy.heliohost.org as the mysql host for remote mysql.