daily pastebin goal
38%
SHARE
TWEET

Untitled

a guest Nov 19th, 2018 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. show variables like 'char%';
  2.    
  3. +--------------------------+----------------------------+
  4. | Variable_name            | Value                      |
  5. +--------------------------+----------------------------+
  6. | character_set_client     | utf8                       |
  7. | character_set_connection | utf8                       |
  8. | character_set_database   | utf8                       |
  9. | character_set_filesystem | binary                     |
  10. | character_set_results    | utf8                       |
  11. | character_set_server     | utf8                       |
  12. | character_set_system     | utf8                       |
  13. | character_sets_dir       | /usr/share/mysql/charsets/ |
  14. +--------------------------+----------------------------+
  15.    
  16. select * from catalogs;
  17.    
  18. which mysql
  19.    
  20. /usr/bin/mysql
  21.    
  22. dpkg -S $(which mysql)
  23.    
  24. mysql-client-core-5.6: /usr/bin/mysql
  25.    
  26. mysql -uroot -p123
  27.    
  28. sudo apt-get install mysql-server.
  29.    
  30. Ubuntu 18.04 Server
  31. В файле конфигурации /etc/mysql/mysql.conf.d.mysql.cnf
  32. В блоке [mysqld], прописать
  33.  
  34. [mysqld]
  35. ...
  36. ...
  37. init_connect='SET collation_connection = utf8_general_ci'
  38. character-set-server = utf8
  39. collation-server = utf8_general_ci
  40. ...
  41.  
  42. В блоке [client] прописать
  43.  
  44. [client]
  45. ...
  46. ...
  47. # ЗАКОМЕНТИРОВАТЬ !
  48. #default-character-set = utf8_general_ci
  49. #default-character-set = utf8
  50. ...
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top