Mysql Error 1372 Hy000
Contents |
sometime you may get this below error. Ex: mysql>grant all privileges on *.* to 'root'@'localhost' identified by password mysql change password for user 'welcome'; "ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal
Mysql Change Password Root
number" Solution: mysql> select password ('welcome'); +-------------------------------------------+| password ('welcome') |+-------------------------------------------+| *DF216F57F1F2066124E1AA5491D995C3CB57E4C2 |+-------------------------------------------+ 1 row in set (0.02
Mysql Password Hash Should Be A 16-digit Hexadecimal Number
sec) mysql>grant all privileges on *.* to 'root'@'localhost' identified by password '*DF216F57F1F2066124E1AA5491D995C3CB57E4C2'; Query OK, 0 rows affected (0.02 sec) mysql>flush privileges; Query OK, 0 rows affected (0.02 sec)
Mysql Password Command Line
Now the error gone.Try this when you are getting this error. Better always try this below way to create MySQL user. mysql>grant all privileges on *.* to 'root'@'localhost' identified by 'welcome'; Query OK, 0 rows affected (0.00 sec) mysql>flush privileges; Query OK, 0 rows affected (0.02 sec) Posted by Prabhu Raja Singh at Thursday, September 12, 2013 mysql default password Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: error, flush, grant, mysql, password, privileges Newer Post Older Post Home Subscribe to: Post Comments (Atom) About me D.Prabhu Raja Singh,MySQL DBA I created this blog to share ideas and experiences in MySQL with anyone who happens to come across this blog. Translate Blog Archive ► 2015 (4) ► September (1) ► July (1) ► April (1) ► January (1) ► 2014 (7) ► December (1) ► May (1) ► April (3) ► February (1) ► January (1) ▼ 2013 (28) ► December (1) ► November (2) ► October (2) ▼ September (2) Percona Tool Kit Installation MySQL Grant Password Error : ERROR 1372 (HY000): P... ► August (1) ► July (1) ► June (1) ► May (1) ► April (2) ► March (5) ► February (4) ► January (6) ► 2012 (5) ► December (5) For any queries : knowmysql@gmail.com Total Pageviews Feedjit Feedjit Live Blog Stats Powered by Prabhu Raja Singh.D Awesome Inc. template. Powered by Blogger.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss mysql change user the workings and policies of this site About Us Learn more about cpanel dbd::mysql::db do failed: password hash should be a 16-digit hexadecimal number Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow mysql delete user Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each http://knowmysql.blogspot.com/2013/09/mysql-grant-password-error-error-1372.html other. Join them; it only takes a minute: Sign up Mysql user creation script up vote 21 down vote favorite 4 I'm trying to automate MySQL user creation procedure. I thought of creating a temp file that would contain mysql user creation statements, then I would have call it like this : mysql -u root -proot < temp But http://stackoverflow.com/questions/9529651/mysql-user-creation-script I'm stuck with mysql syntax : here's the content of my temp file : DROP DATABASE IF EXISTS mytestdatabase; CREATE DATABASE mytestdatabase; SELECT @password:="my password"; DELETE FROM mysql.user WHERE Host='localhost' AND User='mytestdatabase'; GRANT ALL PRIVILEGES ON mytestdatabase.* TO 'mytestdatabase'@'localhost' IDENTIFIED BY PASSWORD '@password'; FLUSH PRIVILEGES; But the line GRANT ALL PRIVILEGES ON mytestdatabase.* TO 'mytestdatabase'@'localhost' IDENTIFIED BY PASSWORD '@password'; (Password hash should be a 41-digit hexadecimal number ) is not interpreted as I would expect it to be. Even if I remove single quotes around the @password tag I still have errors (syntax error) How can I make this work ? mysql database share|improve this question edited Mar 2 '12 at 8:05 Korhan Ozturk 7,17542336 asked Mar 2 '12 at 7:38 ling 1,36611418 What's the error message? –Korhan Ozturk Mar 2 '12 at 7:44 ERROR 1372 (HY000) at line 9: Password hash should be a 41-digit hexadecimal number –ling Mar 2 '12 at 7:48 add a comment| 6 Answers 6 active oldest votes up vote 38 down vote acce
the following error while creating a user http://www.orafaq.com/forum/t/188804/ through MySQL Prompt: [wpfmb type='error' theme=2]mysql> create user test identified by password ‘test345'; ERROR 1372 (HY000): mysql change Password hash should be a 41-digit hexadecimal number[/wpfmb] This is because MySQL expects you to enter password in an encrypted format. You can resolve this error by following the steps given mysql change password below. mysql> select password(‘test345’); +———————+ | password(‘test345’) | +———————+ | 2ff898e158cd0311 | +———————+ +-------------------------+ 1 row in set (0.00 sec) mysql> create user test identified by password ‘2ff898e158cd0311′; Query OK, 0 rows affected (0.00 sec) That's it. Posted in Cpanel ← Previous Next → Leave a Reply Click here to cancel reply. CommentName * Email * Website Search Copyright © 2016 cPanel Plesk. Powered by WordPress and cPanel Register to Get FREE Offers Why Pay for Software when you can GET it for FREE Email JOIN US TONIGHT! Powered by ConvertPlug™
Polls :: Message Navigator E-mail to friend ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number for mysql root user [message #591264] Fri, 26 July 2013 01:15 pradies Messages: 245Registered: May 2008 Senior Member Hi, I am trying to install mysql 5.6.10 on CentOS release 5.4 (Final). I have downloaded all the rpm from the dev.mysql.com. I am following the below link for installing the mysql(ignored in case of perl) http://opensourcedbms.com/dbms/installing-mysql-5-6-on-cent-os-6-3-redhat-el6-fedora/ After the installation when I am trying to SET PASSWORD for root first time I am getting the error ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number. After google found that solution for this error is for not root user. Same solution tested for root user but didn't get any success. I am not getting the solution of this error on net. kindly help me in this case. [root@imob1 old]# rpm -ivh MySQL-shared-5.6.10-1.linux_glibc2.5.x86_64.rpm Preparing... ########################################### [100%] package MySQL-shared-5.6.10-1.linux_glibc2.5.x86_64 is already installed [root@imob1 old]# rpm -ivh MySQL-server-5.6.10-1.linux_glibc2.5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%] 2013-07-26 11:02:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-07-26 11:02:10 12400 [Note] InnoDB: The InnoDB memory heap is disabled 2013-07-26 11:02:10 12400 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-07-26 11:02:10 12400 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-07-26 11:02:10 12400 [Note] InnoDB: CPU does not support crc32 instructions 2013-07-26 11:02:10 12400 [Note] InnoDB: Using Linux native AIO 2013-07-26 11:02:10 12400 [Note] InnoDB: Initializing buffer pool, si