Advertisement
Guest User

Untitled

a guest
Jun 17th, 2018
293
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. Not sure if it's misconfigured, but select @@datadir; returns:
  2. [CODE]+-----------------+
  3. | @@datadir |
  4. +-----------------+
  5. | /var/lib/mysql/ |
  6. +-----------------+
  7. [/CODE]
  8.  
  9. /var/lib/mysql doesn't contain any .sock file.
  10.  
  11. nano /etc/mysql/my.cnf lists:
  12. [CODE][client]
  13. port = 3306
  14. socket = /var/run/mysqld/mysqld.sock
  15.  
  16. # Here is entries for some specific programs
  17. # The following values assume you have at least 32M ram
  18.  
  19. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  20. [mysqld_safe]
  21. socket = /var/run/mysqld/mysqld.sock
  22. nice = 0
  23.  
  24. [mysqld]
  25. #
  26. # * Basic Settings
  27. #
  28. user = mysql
  29. pid-file = /var/run/mysqld/mysqld.pid
  30. socket = /var/run/mysqld/mysqld.sock
  31. port = 3306
  32. basedir = /usr
  33. datadir = /var/lib/mysql
  34. tmpdir = /tmp
  35. lc_messages_dir = /usr/share/mysql
  36. lc_messages = en_US
  37. skip-external-locking
  38. #
  39. # Instead of skip-networking the default is now to listen only on
  40. # localhost which is more compatible and is not less secure.
  41. bind-address = 127.0.0.1
  42. #
  43. # * Fine Tuning
  44. #
  45. max_connections = 100
  46. connect_timeout = 5
  47. wait_timeout = 600
  48. max_allowed_packet = 16M
  49. thread_cache_size = 128
  50. sort_buffer_size = 4M
  51. bulk_insert_buffer_size = 16M
  52. tmp_table_size = 32M
  53. max_heap_table_size = 32M
  54. [/CODE]
  55.  
  56. /var/run/mysqld/mysqld.sock and /var/run/mysqld/mysqld.pid both are 0777
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement