MySQL/version/5.7 - Revision history

Woozle at 02:04, 25 December 2018

2018-12-25T02:04:43Z

← Older revision		Revision as of 02:04, 25 December 2018
Line 9:		Line 9:
	* [https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords Setting, Changing And Resetting MySQL Root Passwords]		* [https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords Setting, Changing And Resetting MySQL Root Passwords]
	** default value for [https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-grant-tables --skip-grant-tables] is now FALSE, so you have to specify <code>--skip-grant-tables=TRUE</code>		** default value for [https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-grant-tables --skip-grant-tables] is now FALSE, so you have to specify <code>--skip-grant-tables=TRUE</code>

			Also, you may need to create the <code>/run/mysql</code> folder and [[chown]] it to <code>mysql:adm</code> or whatever user is appropriate on your system. (You can determine what user:group MySQL is using on your system by looking at the log files, typically <code>/var/log/mysql</code>.

Woozle: exact version

2018-12-25T02:00:06Z

exact version

← Older revision		Revision as of 02:00, 25 December 2018
Line 1:		Line 1:
	==Recovering / Setting passwords==		==Recovering / Setting passwords==
	A lot of the instructions online for doing this no longer work with 5.7.		A lot of the instructions online for doing this no longer work with 5.7. The following is true for version 5.7.24-0ubuntu0.18.04.1

	Obsolete instructions:		Obsolete instructions:

Woozle: Created page with "==Recovering / Setting passwords== A lot of the instructions online for doing this no longer work with 5.7. Obsolete instructions: * [https://stackoverflow.com/questions/4429..."

2018-12-25T01:58:22Z

Created page with "==Recovering / Setting passwords== A lot of the instructions online for doing this no longer work with 5.7. Obsolete instructions: * [https://stackoverflow.com/questions/4429..."

New page

==Recovering / Setting passwords==
A lot of the instructions online for doing this no longer work with 5.7.

Obsolete instructions:
* [https://stackoverflow.com/questions/44298160/mysql-mariadb-10-0-29-set-root-password-but-still-can-login-without-asking-p Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?]: the SQL command for changing passwords is different
** [https://dev.mysql.com/doc/refman/5.7/en/set-password.html SET PASSWORD] is deprecated, but may work
** [https://dev.mysql.com/doc/refman/5.7/en/alter-user.html ALTER USER] is preferred.
** '''BUT''' that won't work when grant tables are skipped; you have to use <code>update user set authentication_string=PASSWORD("new_password") where User='root';</code>
* [https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords Setting, Changing And Resetting MySQL Root Passwords]
** default value for [https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-grant-tables --skip-grant-tables] is now FALSE, so you have to specify <code>--skip-grant-tables=TRUE</code>