Error 1372 Mysql
Contents |
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL mysql change password for user Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization mysql change password root Data Types Functions and Operators SQL Statement Syntax Data Definition Statements ALTER DATABASE Syntax ALTER EVENT Syntax ALTER FUNCTION mysql password hash should be a 16-digit hexadecimal number Syntax ALTER INSTANCE Syntax ALTER LOGFILE GROUP Syntax ALTER PROCEDURE Syntax ALTER SERVER Syntax ALTER TABLE Syntax ALTER TABLE Partition Operations ALTER TABLE Online Operations in MySQL Cluster ALTER TABLE and mysql password command line Generated Columns ALTER TABLE Examples ALTER TABLESPACE Syntax ALTER VIEW Syntax CREATE DATABASE Syntax CREATE EVENT Syntax CREATE FUNCTION Syntax CREATE INDEX Syntax CREATE LOGFILE GROUP Syntax CREATE PROCEDURE and CREATE FUNCTION Syntax CREATE SERVER Syntax CREATE TABLE Syntax CREATE TABLE ... LIKE Syntax CREATE TABLE ... SELECT Syntax Using FOREIGN KEY Constraints Silent Column Specification Changes CREATE TABLE and Generated Columns Secondary
Mysql Default Password
Indexes and Generated Virtual Columns Setting NDB_TABLE options in table comments CREATE TABLESPACE Syntax CREATE TRIGGER Syntax CREATE VIEW Syntax DROP DATABASE Syntax DROP EVENT Syntax DROP FUNCTION Syntax DROP INDEX Syntax DROP LOGFILE GROUP Syntax DROP PROCEDURE and DROP FUNCTION Syntax DROP SERVER Syntax DROP TABLE Syntax DROP TABLESPACE Syntax DROP TRIGGER Syntax DROP VIEW Syntax RENAME TABLE Syntax TRUNCATE TABLE Syntax Data Manipulation Statements CALL Syntax DELETE Syntax DO Syntax HANDLER Syntax INSERT Syntax INSERT ... SELECT Syntax INSERT DELAYED Syntax INSERT ... ON DUPLICATE KEY UPDATE Syntax LOAD DATA INFILE Syntax LOAD XML Syntax REPLACE Syntax SELECT Syntax SELECT ... INTO Syntax JOIN Syntax UNION Syntax Subquery Syntax The Subquery as Scalar Operand Comparisons Using Subqueries Subqueries with ANY, IN, or SOME Subqueries with ALL Row Subqueries Subqueries with EXISTS or NOT EXISTS Correlated Subqueries Subqueries in the FROM Clause Subquery Errors Optimizing Subqueries Rewriting Subqueries as Joins UPDATE Syntax MySQL Transactional and Locking Statements START TRANSACTION, COMMIT, and ROLLBACK Syntax Statements That Cannot Be Rolled Back Statements That Cause an Implicit Commit SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax LOCK TABLES a
sometime you may get this below error. Ex: mysql>grant all privileges on *.* to 'root'@'localhost' identified by password
Mysql Change User
'welcome'; "ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal mysql delete user number" Solution: mysql> select password ('welcome'); +-------------------------------------------+| password ('welcome') |+-------------------------------------------+| *DF216F57F1F2066124E1AA5491D995C3CB57E4C2 |+-------------------------------------------+ 1 row in set (0.02 mysql password generator 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) http://dev.mysql.com/doc/en/set-password.html 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 http://knowmysql.blogspot.com/2013/09/mysql-grant-password-error-error-1372.html 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.
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, size = 128.0M 2013-07-26 11:02:10 12400 [Note] InnoDB: Completed initialization of buffer pool 2013-07-26 11:02:10 12400 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2013-07-26 11:02:10 12400 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2013-07-26 11:02:10 12400 [Note] InnoDB: Database physically writes the file full: wait... 2013-07-26 11:02:11 12400 [Note] InnoDB: Setting log file ./ib