Content in MYSQL

• Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

  Use this command to fix it ALTER TABLE zl_report_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci Link or   First, check your collation of table
  863 views
• Server public key has changed Workbench

  Step 1 Go to C:\Users\%USERPROFILE%\AppData\Roaming\MySQL\Workbench\ssh and empty known_hosts file Step 2 In Workbench, go to Edit - Preferences - SSH and under the
  1961 views
• Switch to mysql account in linux

  mysql -u root -p
  1905 views
• Grand access to root and ssh in MYSQL

  GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
  1810 views
• IP blocked - too many connections in MYSQL

  mysqladmin -uroot -p flush-hosts
  1941 views
• Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

  1a) Connect to mysql (via localhost) mysql -uroot -p Create user CREATE USER 'user'@'%' IDENTIFIED BY 'password'; Grant permissions GRANT ALL PRIVILEGES ON *.* TO
  1901 views
• MySQL REPLACE() function

  MySQL REPLACE() replaces all the occurrences of a substring within a string. _______________________________________ SELECT * FROM schema.table;UPDATE schema.table set column= replace(column, 'aaa',
  1960 views
• #1227 - Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation

  In case you are uploading an sql file on cpanel, then try and replace root with your cpanel username in
  1209 views

one category up