I'm new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else.
Active7 months ago
/ Installing and Upgrading MySQL / Installing MySQL on macOS / Installing MySQL on macOS Using Native Packages 2.4.2 Installing MySQL on macOS Using Native Packages The package is located inside a disk image (.dmg ) file that you first need to mount by double-clicking its icon in the Finder. The MySQL server is installed on the Mac, but it does not load by default. Start MySQL by clicking Start using the MySQL Preference Pane, which was installed during the default installation. You can configure MySQL to automatically start when you turn on your computer using the MySQL Preference Pane.
Now I already reset the password the usual way:
(BTW: took me ages to work out that MySQL for some bizarre reason has renamed the field 'password' to 'authentication_string'. I am quite upset about changes like that.)
Unfortunately it seems I need to change the password a different way that is unknown to me. Maybe someone here has already come across that problem?
robsch
6,00555 gold badges4646 silver badges7676 bronze badges
dengar81dengar81
1,02022 gold badges99 silver badges1818 bronze badges
19 Answers
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
Query OK, 0 rows affected, 1 warning (0.01 sec)
This is where I found the answer: https://dev.mysql.com/doc/refman/5.6/en/alter-user.html
Ivar
3,2561111 gold badges3434 silver badges4444 bronze badges
MadmintMadmint
4,92811 gold badge66 silver badges1414 bronze badges
If you started mysql using
mysql -u root -p
Try
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Source: http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
shnrajshnraj
1,29111 gold badge88 silver badges44 bronze badges
I have same problem on Mac
First, log in mysql with sandbox mode
Then, set password
It works for me ~
via: https://dba.stackexchange.com/questions/118852/your-paswssword-has-expired-after-restart-mysql-when-updated-mysql-5-7-8-rcde
Community♦
Ezio ShikiEzio Shiki
![]()
If you use MySQL 5.7.6 and later:
If you use MySQL 5.7.5 and earlier:
Johel AlvarezJohel Alvarez
Run these:
Then run
Crack win 8.1. Windows Vista Business/Enterprise/N/VL.
It should log in. Now run FLUSH privileges;
Then exit the MySQL console and try logging in. If that doesn't work run these:
Change xxxxxx to ur new password. Then try logging in again.
Update.See this http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
It should solve your problem.
If you are on oracle try this
user4942382
On MySQL 5.7.x you need to switch to native password to be able to change it, like:
slfan
7,2322020 gold badges5555 silver badges7171 bronze badges
Vadim SmilanskyVadim Smilansky
Install Mysql Macos
Maybe try that ?
or
Depending on which access you use.
(and not sure you should change yourself field names..)
Mateo BarahonaMateo Barahona
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
Use this line..
Manoj BeheraManoj Behera
On
Ver 14.14 Distrib 5.7.19, for macos10.12 (x86_64) , I logged in as:mysql -uroot -p then typed in the generated password by MySQL when you install it. Then.
ALTER USER 'root'@'localhost' IDENTIFIED BY '<new_password>';
Example:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ab1234';Query OK, 0 rows affected (0.00 sec)mysql> exitBye$ mysql -uroot -p
And you can type in 'Ab1234'
Kenny AlvizurisKenny Alvizuris
UPDATE user SET authentication_string=PASSWORD('MyPassWord') WHERE User='root';ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('MyPassWord') WHERE User='root' at line 1
Resolved with
Reference from below site
Siddharth PandeySiddharth Pandey
This worked for me:
ALTER USER USER() IDENTIFIED BY 'auth_string';
I found it here:http://dev.mysql.com/doc/refman/5.7/en/alter-user.html#alter-user-current
Abhishek UpadhyayaAbhishek Upadhyaya
Mysql 5.7.24 get root first login
step 1: get password from log
step 2: login with him to mysql
step 3: you put new root password
![]() Install Mysql On Macbook
you get
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
how fix it?
run this
SET GLOBAL validate_password_policy=LOW;
Try Again
SET PASSWORD = PASSWORD('xxxxx');
Robert ARobert A
When you use
SET PASSWORD = PASSWORD('your_new_password'); it may crash for it
(ERROR 1819 (HY000): Your password does not satisfy the current policy requirements)
.you can use giannis christofakis
SET GLOBAL validate_password_policy=LOW; to slove it.
5,68744 gold badges4343 silver badges6262 bronze badges
未来陆家嘴顶尖的投资人未来陆家嘴顶尖的投资人
Here is the way works for me.
mysql>
show databases ;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
uninstall plugin validate_password;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
alter user 'root'@'localhost' identified by 'root';
Query OK, 0 rows affected (0.01 sec)
mysql>
flush privileges;
Query OK, 0 rows affected (0.03 sec)
sunling90sunling90
in 5.7 version. 'password' field has been deleted. 'authentication_string' replace it
HUAN LIUHUAN LIU
I also got the same problem in mac OS X 10.10.4(Yosemite).SET PASSWORD work for me.Alter password for mysql-mysql> SET PASSWORD = PASSWORD('your_password');Query OK, 0 rows affected, 1 warning (0.01 sec)
set your Mysql environment path variable in .bash_profile and add the below line
export PATH=$PATH:/usr/local/mysql/bin,after that, run the following command :source .bash_profile
MoumitaMoumita
Had the problem after I installed mysql workbench and mysql community server. Got generated password during the server installation.Double clicking on the exisiting local instance in workbench triggered a dialog where I could set the new password.
MalteMalte
mysql> SET PASSWORD = PASSWORD('your_new_password'); That works for me.
Mysql Mac Tutorial
zhaozhao
remember versions 5.7.23 and up - the user table doesn't has column password instead authentication string so below works while resetting password for a user.
PravinPravin
Not the answer you're looking for? Browse other questions tagged mysqlmacos or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |