godaddy VPS ( Turn off MySQL strict MODE ) + Transfer DNS

im having issue my site is not accepting members to register all activation code are wrong and it does not save members data ...etc its because of mysql strict mode should be off in my server i have the VPS Ready with the Cpanel installed ( Godaddy ) please if you know what you are doing let me know as This Command at PHPMYADMIN SET atatglobal.sql_mode= ''; Will not work ! let me know i want to also Transfer DNS from old shared Cpanel to the new one and make account for Developers ..etc let me know