lirn Posted April 8, 2019 Share Posted April 8, 2019 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 Quote Link to comment Share on other sites More sharing options...
Krydos Posted April 8, 2019 Share Posted April 8, 2019 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? Quote Link to comment Share on other sites More sharing options...
lirn Posted April 8, 2019 Author Share Posted April 8, 2019 got it ,I think the domain has been changed from lirn.heliohost.org to tommy.heliohost.org, but I don't know why. Quote Link to comment Share on other sites More sharing options...
Krydos Posted April 8, 2019 Share Posted April 8, 2019 We always recommend using tommy.heliohost.org as the mysql host for remote mysql. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.