Guest User

Untitled

a guest
Nov 19th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  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. ...
Add Comment
Please, Sign In to add comment