Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Nov 19th, 2018 71 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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