Problem creating mysql users when options were change in the mysql configuration

coolfiger

• November 10, 2013 09:30

Good Day, We recently activated STRICT_TRANS_TABLES which is a global mysql setting. about 15 of our clients use this feature and require it on. Since we turned this account on we cannot create any mysql accounts . Se the attached file for the error. ran adminbin cpanel/cpmysql/Adduser .vB From all my reading there seems to be no way to overcome this except turning the strict trans option off. Can you suggest any solutions ?

• 

  iserversupport

  • November 10, 2013 21:06

  Which is your MySQL version and what is the output of "mysqladmin variables | grep sql_mode" ?

  0
• 

  coolfiger

  • November 10, 2013 22:05

  this is the output from your cmd # mysqladmin variables | grep sql_mode | sql_mode | STRICT_TRANS_TABLES Server version: 5.1.70-cll - MySQL Community Server (GPL) [COLOR="silver">- - - Updated - - - forgot to include cpanel version WHM 11.38.2 (build 12)

  0
• 

  cPanelMichael

  • November 12, 2013 18:28

  Hello :) Check to see if you have an additional my.cnf file added to the system. EX: /usr/my.cnf
  Also, what's the specific entry you have in /etc/my.cnf related to this variable? Thank you.

  0
• 

  coolfiger

  • November 13, 2013 13:14

  there is no additional my.cnf file on the server, the only one is /etc/my.cnf, and the variable in question within it is: sql_mode=STRICT_TRANS_TABLES Actually here is the entire my.cnf content if you will need it: root@xxxx.d [~]# cat /etc/my.cnf [mysqld] max_connections=500 log-slow-queries #safe-show-database sql_mode=STRICT_TRANS_TABLES #skip-networking skip-locking connect_timeout=300 key_buffer=16M join_buffer=1M record_buffer=1M sort_buffer=2M table_cache=1028 thread_cache_size=286 max_allowed_packet=5M wait_timeout=300 query_cache_limit=1M query_cache_size=32M query_cache_type=1 thread_concurrency=2 local-infile=0 open_files_limit=13756

  0
• 

  cPanelMichael

  • November 14, 2013 18:09

  I suggest opening a bug report if you are using a version of MySQL that supports this value: Submit A Bug Report You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  coolfiger

  • November 15, 2013 12:35

  a ticket has been opened for this Support Request Id 4396343

  0
• 

  cPanelMichael

  • November 20, 2013 18:15

  To update, it looks like this option did remain enabled on MySQL 5.1 after restarting MySQL. Thank you.

  0

Please sign in to leave a comment.