Problems with mysqsl. My password of Root are wrong.

September 20, 2019 213 views
MySQL

Today when I get access I can’t find my password when I try to show a message
“Access denied for user root”
How can I login again?

LOG:

2019-09-20T09:28:09.389180Z 8918 [Warning] IP address ‘134.209.105.46’ could not be resolved: Name or service not known
2019-09-20T09:28:09.616703Z 8918 [Note] Access denied for user 'arabela’@'134.209.105.46’ (using password: YES)
2019-09-20T09:28:11.345160Z 8919 [Warning] IP address '157.245.102.49’ has been resolved to the host name '319025.cloudwaysapps.com’, which resembles IPv4-address itself.
2019-09-20T09:28:11.561292Z 8919 [Note] Access denied for user 'arabele’@'157.245.102.49’ (using password: YES)
2019-09-20T09:32:36.671362Z 8920 [Note] Access denied for user 'arda’@'93-54-88-248.ip128.fastwebnet.it’ (using password: YES)
2019-09-20T09:37:52.685218Z 8921 [Warning] IP address '51.255.36.166’ has been resolved to the host name '166.ip-51-255-36.eu’, which resembles IPv4-address itself.
2019-09-20T09:37:52.768573Z 8921 [Note] Access denied for user 'ardene’@'51.255.36.166’ (using password: YES)
2019-09-20T09:42:35.787539Z 8922 [Warning] IP address '104.248.244.198’ could not be resolved: Name or service not known
2019-09-20T09:42:35.871965Z 8922 [Note] Access denied for user 'ardys’@'104.248.244.198’ (using password: YES)
2019-09-20T09:45:05.441542Z 8923 [Note] Access denied for user 'aria’@'ns3108168.ip-54-37-253.eu’ (using password: YES)
2019-09-20T09:45:19.376640Z 8924 [Note] Access denied for user 'ariadne’@'83-83-24-197.cable.dynamic.v4.ziggo.nl’ (using password: YES)
2019-09-20T09:52:12.487631Z 8925 [Note] Access denied for user 'arina’@'103.86.50.220’ (using password: YES)
2019-09-20T09:52:31.177768Z 8926 [Note] Access denied for user 'aris’@'c-174-48-207-118.hsd1.fl.comcast.net’ (using password: YES)
2019-09-20T09:54:12.221928Z 8927 [Note] Access denied for user 'arjun’@'83-85-83-91.cable.dynamic.v4.ziggo.nl’ (using password: YES)
2019-09-20T09:56:54.820299Z 8928 [Note] Access denied for user 'arlen’@'sv.stayapp.com.br’ (using password: YES)
2019-09-20T09:57:31.116096Z 8929 [Warning] Host name 'static.belong.com.au’ could not be resolved: Name or service not known
2019-09-20T09:57:31.364721Z 8929 [Note] Access denied for user 'arlena’@'155.143.208.98’ (using password: YES)
2019-09-20T09:58:54.154053Z 8930 [Warning] IP address '157.230.16.157’ could not be resolved: Name or service not known
2019-09-20T09:58:54.238605Z 8930 [Note] Access denied for user 'arleta’@'157.230.16.157’ (using password: YES)
2019-09-20T10:00:01.085385Z 8931 [Warning] IP address '104.41.5.236’ could not be resolved: Name or service not known
2019-09-20T10:00:01.199347Z 8931 [Note] Access denied for user 'arleyne’@'104.41.5.236’ (using password: YES)
2019-09-20T10:02:12.490418Z 8932 [Note] Access denied for user 'arlinda’@'ec2-3-9-121-172.eu-west-2.compute.amazonaws.com’ (using password: YES)
2019-09-20T10:06:53.730772Z 8933 [Note] Access denied for user 'armando’@'cpe-70-112-64-139.austin.res.rr.com’ (using password: YES)
2019-09-20T10:09:18.665284Z 8934 [Note] Access denied for user 'arn’@'positif.positiftunisie.com’ (using password: YES)
2019-09-20T10:10:40.997483Z 8935 [Warning] IP address '51.38.230.224’ has been resolved to the host name '224.ip-51-38-230.eu’, which resembles IPv4-address itself.
2019-09-20T10:10:41.069589Z 8935 [Note] Access denied for user 'arnie’@'51.38.230.224’ (using password: YES)
2019-09-20T10:11:46.622437Z 8936 [Note] Access denied for user 'arno’@'host166-5-static.0-79-b.business.telecomitalia.it’ (using password: YES)
2019-09-20T10:13:56.850945Z 8937 [Note] Access denied for user 'arrie’@'c-24-11-216-231.hsd1.tn.comcast.net’ (using password: YES)
2019-09-20T10:15:15.475662Z 8938 [Warning] IP address '46.20.4.154’ has been resolved to the host name '46.20.4.154.static.ttnet.com.tr’, which resembles IPv4-address itself.
2019-09-20T10:15:15.601720Z 8938 [Note] Access denied for user 'arshad’@'46.20.4.154’ (using password: YES)
2019-09-20T10:19:38.542172Z 8939 [Note] Access denied for user 'arvin’@'167.99.59.228’ (using password: YES)
2019-09-20T10:20:12.709347Z 8940 [Note] Access denied for user 'arvind’@'positif.positiftunisie.com’ (using password: YES)
2019-09-20T10:21:07.534629Z 8941 [Warning] IP address '59.149.36.225’ has been resolved to the host name '059149036225.ctinets.com’, which resembles IPv4-address itself.
2019-09-20T10:21:07.745824Z 8941 [Note] Access denied for user 'arwin’@'59.149.36.225’ (using password: YES)
2019-09-20T10:22:22.432058Z 8942 [Note] Access denied for user 'aryn’@'115.74.227.62’ (using password: YES)
2019-09-20T10:29:40.510938Z 8943 [Note] Access denied for user 'ashien’@'pool-98-118-86-115.bstnma.fios.verizon.net’ (using password: YES)
2019-09-20T10:31:49.735676Z 8944 [Note] Access denied for user 'ashlee’@'cpc121238-nmal25-2-0-cust90.19-2.cable.virginm.net’ (using password: YES)
2019-09-20T10:32:36.378888Z 8945 [Note] Access denied for user 'ashleigh’@'206.189.51.28’ (using password: YES)
2019-09-20T10:37:21.079937Z 8946 [Note] Access denied for user 'ashoka’@'93-42-253-165.ip89.fastwebnet.it’ (using password: YES)
2019-09-20T10:38:45.615354Z 8947 [Note] Access denied for user 'ashton’@'conniescottproductions.com’ (using password: YES)
2019-09-20T10:40:05.977068Z 8948 [Warning] IP address '109.19.160.172’ has been resolved to the host name '172.160.19.109.rev.sfr.net’, which resembles IPv4-address itself.
2019-09-20T10:40:06.087406Z 8948 [Note] Access denied for user 'ashvini’@'109.19.160.172’ (using password: YES)
2019-09-20T10:40:54.220013Z 8949 [Note] Access denied for user 'ashwin’@'134.209.62.13’ (using password: YES)
2019-09-20T10:43:04.420403Z 8950 [Note] Access denied for user 'asmar’@'178.128.117.203’ (using password: YES)
2019-09-20T10:44:41.849220Z 8951 [Note] Access denied for user 'aster’@'14.225.18.134’ (using password: YES)
2019-09-20T10:47:10.535607Z 8952 [Note] Access denied for user 'astrix’@'85-170-60-19.rev.numericable.fr’ (using password: YES)
2019-09-20T10:49:47.971596Z 8953 [Warning] IP address '185.234.217.88’ could not be resolved: Name or service not known
2019-09-20T10:49:57.181352Z 8960 [Note] Access denied for user 'athar’@'cable-188-2-63-170.dynamic.sbb.rs’ (using password: YES)
2019-09-20T10:51:53.299485Z 8962 [Note] Access denied for user 'atique’@'134.209.62.13’ (using password: YES)
2019-09-20T10:53:59.466827Z 8969 [Note] Access denied for user 'atl-sales’@'c-174-48-207-118.hsd1.fl.comcast.net’ (using password: YES)
2019-09-20T10:54:24.693482Z 8975 [Note] Access denied for user 'atmane’@'host207-211-static.2-79-b.business.telecomitalia.it’ (using password: YES)
2019-09-20T10:56:14.710511Z 8976 [Note] Access denied for user 'atta’@'c-73-125-64-67.hsd1.fl.comcast.net’ (using password: YES)
2019-09-20T10:57:10.803077Z 8977 [Note] Access denied for user 'attilio’@'cpc81485-lanc8-2-0-cust185.3-3.cable.virginm.net’ (using password: YES)
2019-09-20T10:59:05.041744Z 8978 [Note] Access denied for user 'auberta’@'45.119.84.18’ (using password: YES)
2019-09-20T10:59:38.520350Z 8979 [Note] Access denied for user 'aubine’@'toroon0631w-lp130-01-184-146-183-181.dsl.bell.ca’ (using password: YES)
2019-09-20T11:00:18.761394Z 8980 [Note] Access denied for user 'aubreanna’@'27.254.159.157’ (using password: YES)
2019-09-20T11:00:49.949582Z 8981 [Note] Access denied for user 'aubree’@'45.119.84.18’ (using password: YES)
2019-09-20T11:01:39.961829Z 8982 [Note] Access denied for user 'aubrey’@'IP-80-94-29-40.internet.lantech.com.pl’ (using password: YES)
2019-09-20T11:04:10.337585Z 8983 [Note] Access denied for user 'aubry’@'89-212-177-76.static.t-2.net’ (using password: YES)
2019-09-20T11:06:55.445026Z 8985 [Note] Access denied for user 'audra’@'103.86.50.220’ (using password: YES)
2019-09-20T11:07:23.657002Z 8986 [Note] Access denied for user 'audre’@'74.208.211.127’ (using password: YES)
2019-09-20T11:08:55.414247Z 8988 [Note] Access denied for user 'audric’@'prospe42.lnk.telstra.net’ (using password: YES)
2019-09-20T11:10:46.437288Z 8989 [Note] Access denied for user 'audry’@'165.22.62.126’ (using password: YES)
2019-09-20T11:11:55.051308Z 8990 [Note] Access denied for user 'audwin’@'146.185.141.208’ (using password: YES)
2019-09-20T11:12:11.256955Z 8991 [Note] Access denied for user 'audy’@'dhcp-089-099-095-186.chello.nl’ (using password: YES)
2019-09-20T11:15:31.263521Z 0 [Note] Giving 2 client threads a chance to die gracefully

1 Answer

Hello,

In case that you’ve lost your MySQL root password, I would recommend following the steps from this step by step guide on how to reset your MySQL root password:

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password

Hope that this helps!
Regards,
Bobby

by Mateusz Papiernik
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-enabled user account. This tutorial will cover how to...
  • Tks for your answer!
    I can’t access with save mode, I don’t know what’s happen. I lost all informations of my Data Base, maybe I had Hacker attack

Have another answer? Share your knowledge.