SHARE
TWEET

Untitled

a guest Jun 17th, 2018 185 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
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