Bug #68740 MySQL 5.6 crashes setting root password
Submitted: 21 Mar 2013 16:46 Modified: 21 Mar 2013 16:56
Reporter: Oli Sennhauser Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S2 (Serious)
Version:5.6.10 OS:Linux (2.6.32-311-ec2 #23-Ubuntu SMP Thu Dec 2 11:14:40 UTC 2010 i686 GNU/Linux)
Assigned to: CPU Architecture:Any
Tags: crash, set password

[21 Mar 2013 16:46] Oli Sennhauser
Description:
mysql> set password for root@localhost = password('');
ERROR 2013 (HY000): Lost connection to MySQL server during query

How to repeat:
see description

possibly we forgot to upgrade mysql...

Suggested fix:
throw an error or catch or fix code.

Thread pointer: 0x95ae650
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = ffffffffa48352ec thread_stack 0x30000
/opt/mysql/server-5.6/bin/mysqld(my_print_stacktrace+0x33)[0x8529dd3]
/opt/mysql/server-5.6/bin/mysqld(handle_fatal_signal+0x4a4)[0x828c0a4]
[0xb78a6400]
/opt/mysql/server-5.6/bin/mysqld(_Z15change_passwordP3THDPKcS2_Pc+0x2b6)[0x82b9296]
/opt/mysql/server-5.6/bin/mysqld(_ZN16set_var_password6updateEP3THD+0x37)[0x828a347]
/opt/mysql/server-5.6/bin/mysqld(_Z17sql_set_variablesP3THDP4ListI12set_var_baseE+0x8f)[0x828a72f]
/opt/mysql/server-5.6/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2a60)[0x8310f40]
/opt/mysql/server-5.6/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x332)[0x8314ec2]
/opt/mysql/server-5.6/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xb5c)[0x8315b0c]
/opt/mysql/server-5.6/bin/mysqld(_Z10do_commandP3THD+0xdc)[0x831709c]
/opt/mysql/server-5.6/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x165)[0x82df8c5]
/opt/mysql/server-5.6/bin/mysqld(handle_one_connection+0x50)[0x82df980]
/opt/mysql/server-5.6/bin/mysqld(pfs_spawn_thread+0x18d)[0x8779d3d]
/lib/tls/i686/nosegneg/libpthread.so.0(+0x5985)[0xb7887985]
/lib/tls/i686/nosegneg/libc.so.6(clone+0x5e)[0xb7675b7e]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (95f8028): set password for root@localhost = password('')
Connection ID (thread ID): 13
Status: NOT_KILLED
[21 Mar 2013 16:55] MySQL Verification Team
Probably a duplicate of: http://bugs.mysql.com/bug.php?id=68385
Make sure your mysql.user table is the correct structure for 5.6.10.