Guest User

Untitled

a guest
Nov 19th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 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. [mysqld]
  31. ...
  32. ...
  33. init_connect='SET collation_connection = utf8_general_ci'
  34. character-set-server = utf8
  35. collation-server = utf8_general_ci
  36. ...
  37.  
  38. [client]
  39. ...
  40. ...
  41. # ЗАКОМЕНТИРОВАТЬ !
  42. #default-character-set = utf8_general_ci
  43. #default-character-set = utf8
  44. ...
Add Comment
Please, Sign In to add comment