pymysql.err.InternalError: (1862, u'Your password has expired. To log in you must change it using a client that supports expired passwords.')

Hello everyone,

when i try to create a new site on frappe this error appears

Mac-Pro:frappe-bench gvargas$ bench new-site erp.local
MySQL root password: **
Traceback (most recent call last):
** File “/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py”, line 162, in _run_module_as_main

** “main”, fname, loader, pkg_name)**
** File “/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py”, line 72, in _run_code**
** exec code in run_globals**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in **
** main()**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main**
** click.Group(commands=commands)(prog_name=‘bench’)**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 722, in call**
** return self.main(args, kwargs)
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 697, in main
*
** rv = self.invoke(ctx)**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke**
** return _process_result(sub_ctx.command.invoke(sub_ctx))**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 895, in invoke**
** return ctx.invoke(self.callback, ctx.params)
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 535, in invoke**
** return callback(args, kwargs)
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/commands/site.py”, line 34, in new_site
*
** verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/commands/site.py”, line 65, in _new_site**
** admin_password=admin_password, verbose=verbose, source_sql=source_sql,force=force, reinstall=reinstall)**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/installer.py”, line 36, in install_db**
** create_database_and_user(force, verbose)**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/installer.py”, line 60, in create_database_and_user**
** if force or (db_name not in dbman.get_database_list()):**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 549, in get_database_list**
** return [d[0] for d in self.db.sql(“SHOW DATABASES”)]**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql**
** self.connect()**
** File “/Developers/bench-repo/frappe-bench/apps/frappe/frappe/database.py”, line 86, in connect**
** charset=‘utf8mb4’, use_unicode = True, conv = conversions)**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/init.py”, line 90, in Connect**
** return Connection(args, kwargs)
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py”, line 706, in init
*
** self.connect()**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py”, line 932, in connect**
** self._request_authentication()**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py”, line 1152, in _request_authentication**
** auth_packet = self._read_packet()**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py”, line 1014, in _read_packet**
** packet.check_error()**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/connections.py”, line 393, in check_error**
** err.raise_mysql_exception(self._data)**
** File “/Developers/bench-repo/frappe-bench/env/lib/python2.7/site-packages/pymysql/err.py”, line 107, in raise_mysql_exception**
** raise errorclass(errno, errval)**
pymysql.err.InternalError: (1862, u’Your password has expired. To log in you must change it using a client that supports expired passwords.')

and i don’t know what to do, because when try to log into mysql with root this log in:

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.17

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> exit
Bye

so… anyone could help me please ?? thank you so much!

Solved.

/usr/local/mysql/bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

and done.

but now i had this problem:

pymysql.err.InternalError: (3065, u"Expression #1 of ORDER BY clause is not in SELECT list, references column ‘c6d2cec0a2672282.tabHas Domain.modified’ which is not in SELECT list; this is incompatible with DISTINCT")

and don’t know what to do now…

Thank you!

by the way… i have MySQL 5.7 installed

omg… i solved this too…

add

[mysqld]
sql-mode=“”

on my.cnf

and that’s all…