0

Im a rookie programmer and have been using mysql for the past 6 months. But all the sudden it reported a 1862 error and that my password was expired.

I have seen other answer to this. Such as: Mysql password expired. Can't connect and Mysql password expired. Can't connect. But since im essentially a newcomer to mysql (besides sql statements), I have no idea what to do.

I have read to you can just write: SET PASSWORD = PASSWORD('XXXXXXXXXXX') And that would fix the problem. But I have no idea where to write this or how to acces it.

Please help

Community
  • 1
  • 1
JakesPH
  • 1
  • 1
  • Do you have access to the `root` account? If not, time for rescue mode. – tadman Aug 14 '16 at 10:38
  • I believe that the account has root access, yes. But it will not let me acces the database or any sql-scripting. + I can't start up mysql command line. It chraches after I enter the password. – JakesPH Aug 14 '16 at 10:45
  • If it's the literal `root` account and you're locked out, you need to restart with permissions checking turned off ("rescue mode"). – tadman Aug 14 '16 at 10:46
  • Have do I do that? – JakesPH Aug 14 '16 at 10:48
  • 1
    It's not a Stack Overflow question because this isn't programming and it's been answered a billion times before. Search "mysql recover root password". – tadman Aug 14 '16 at 10:50
  • But (also for future reference) how do I acces programes, that allow me do this: http://dev.mysql.com/doc/refman/5.7/en/set-password.html. And thanks for helping anyway – JakesPH Aug 14 '16 at 10:53
  • If your MySQL server is operated by a commercial hosting service or a company IT department, contact them for help on this. – O. Jones Aug 14 '16 at 12:26
  • Unfortunnally It's not the case. But thanks for the answer anyhow. – JakesPH Aug 14 '16 at 16:13

0 Answers0