Guest User

Untitled

a guest
Dec 16th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  2.  
  3. development:
  4. adapter: mysql2
  5. host: localhost
  6. username: root
  7. password: xxxx
  8. database: xxxx
  9.  
  10. mysqladmin variables | grep socket
  11.  
  12. | socket | /tmp/mysql.sock |
  13.  
  14. development:
  15. adapter: mysql2
  16. host: localhost
  17. username: root
  18. password: xxxx
  19. database: xxxx
  20. socket: /tmp/mysql.sock
  21.  
  22. development:
  23. adapter: mysql2
  24. host: 127.0.0.1
  25. username: root
  26. password: xxxx
  27. database: xxxx
  28.  
  29. shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
  30. (ENTER YOUR PASSWORD, IF NECESSARY)
  31. (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)
  32.  
  33. shell> cd /usr/local/mysql
  34. shell> sudo ./bin/mysqld_safe
  35. (ENTER YOUR PASSWORD, IF NECESSARY)
  36. (PRESS CONTROL-Z)
  37. shell> bg
  38. (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)
  39.  
  40. development:
  41. adapter: mysql2
  42. host: localhost
  43. username: root
  44. password: xxxx
  45. database: xxxx
  46. socket: /Applications/MAMP/tmp/mysql/mysql.sock
  47.  
  48. staging:
  49. adapter: mysql2
  50. host: 127.0.0.1
  51. username: root
  52. password: xxxx
  53. database: xxxx
  54. socket: your-location-socket
  55.  
  56. mysqladmin variables | grep socket
  57.  
  58. mysqladmin: connect to server at 'localhost' failed
  59. error: 'Can't connect to local MySQL server through socket '/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock' (2)'
  60. Check that mysqld is running and that the socket: '/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock' exists!
  61.  
  62. mysql --help
  63.  
  64. socket: /tmp/mysql.sock
  65.  
  66. socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
  67.  
  68. socket: /Applications/MAMP/tmp/mysql/mysql.sock
  69.  
  70. socket: /tmp/mysql.sock
  71.  
  72. socket: /var/mysql/mysql.sock
  73.  
  74. socket: /var/run/mysqld/mysql.sock
  75.  
  76. staging:
  77. # socket: /var/run/mysqld/mysql.sock
  78.  
  79. bundle exec rake redmine:plugins:migrate RAILS_ENV=production
  80.  
  81. development:
  82. adapter: mysql2
  83. encoding: utf8
  84. reconnect: false
  85. database: difiuri_falcioni
  86. pool: 5
  87. username: root
  88. password:
  89. host: localhost
  90. socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
  91.  
  92. sudo service mysqld restart
Add Comment
Please, Sign In to add comment