Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with

socket=/var/lib/mysql/mysql.sock

you can check if mysql is running with the following command:

mysqladmin -u root -p status

try changing your permission to mysql folder. If you are working locally, you can try:

sudo chmod -R 755 /var/lib/mysql/

that solved it for me

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. How to use mysqli_query() in PHP?
  3. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  7. How do I quickly rename a MySQL database (change schema name)?
  8. What does SQL Select symbol || mean?
  9. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  10. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  11. MySQL DROP all tables, ignoring foreign keys
  12. Setting up foreign keys in phpMyAdmin?
  13. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  14. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  15. mysql is not recognised as an internal or external command,operable program or batch
  16. MySQL error code: 1175 during UPDATE in MySQL Workbench
  17. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  18. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  19. Data truncated for column?
  20. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  21. How to find MySQL process list and to kill those processes?
  22. How to update a record using sequelize for node?
  23. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  24. MySQL date format DD/MM/YYYY select query?
  25. MySQL Server on MAMP-Windows Will Not Start
  26. SQL statement not working – “Operand type clash: date is incompatible with int’
  27. How can I output MySQL query results in CSV format?
  28. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  29. Error: select command denied to user ‘‘@’‘ for table ‘‘
  30. #1214 – The used table type doesn’t support FULLTEXT indexes
  31. importing a CSV into phpmyadmin
  32. How can I rebuild indexes and update stats in MySQL innoDB?
  33. MySQL Error 1215: Cannot add foreign key constraint
  34. How to use the keyword ‘references’ in MySQL?
  35. select * from table where column = something or, when unavailable, column = something else
  36. Differences between utf8 and latin1
  37. There can be only one auto column
  38. MySQL – UPDATE query with LIMIT
  39. What are the recommended database permissions for WordPress?
  40. What’s a good strategy for planning WordPress DB growth?
  41. How can I find the source of slow queries in WordPress?
  42. $wpdb and MySQL Create Trigger
  43. wpdb->prepare function remove single quote for %s in SQL statment
  44. Programmatically changing role information; editing role name and deleting
  45. Fulltext search in posts sorted by relevancy
  46. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  47. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  48. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  49. How can I make wordpress suppress mysql errors?
  50. How to bulk delete all WordPress subscribers?
  51. Error while importing database
  52. Changing Table Prefix for an Existing WordPresss Site
  53. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  54. Mysql SELECT posts
  55. Connect another DB and fetch records from some tables
  56. Can I restart MySQL engine when WordPress website is live?
  57. Error: MySQL shutdown unexpectedly [closed]
  58. Why my wordpress loopback traffic while socket is setup?
  59. How to add a private user page populated from sql?
  60. Update or insert meta key value – On Duplicate key update
  61. Connect to MySQL using Windows Authentication
  62. Defining the same price to all WooCommerce Products
  63. Database Structure on Different Servers
  64. SQL syntax error. However, it works normally at phpmyadmin
  65. How to get INSERT errors from $wpdb?
  66. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  67. string literals in query
  68. Export Yoast Keywords from MySQL/phpMyAdmin
  69. Same database; different WordPress
  70. Create pages from MySQL database
  71. How to insert dash (-) into database using wpdb and new_to_publish hook?
  72. MySQL: How to change url in posts from xxx.com to yyy.org?
  73. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  74. Exporting completed webiste for another server
  75. Upgrade DB Loop – WordPress DB Version Conflict
  76. WordPress & MySQL , problem with use many array in meta_query
  77. Button writing to MYSQL database
  78. MySQL ‘duplicate entry’ error
  79. Find locations of all featured images of draft posts via SQL
  80. WordPress Dutch characters encoding problem
  81. How to show result of sql query in a page?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. How do I insert content of various MySQL fields in post?
  84. How to change link in all posts?
  85. Select latest 2 articles, but only from given category
  86. CONCAT_WS in custom sql query
  87. Query does not filter duplicate _sku numbers
  88. Ordering topics by most replies in X days using MYSQL statement
  89. MySQL Select within WP Page template
  90. wp_postmeta – lot of meta fields
  91. Running WordPress from MySQL Cluster with HAPRoxy
  92. Delete posts with word count less than x number of words
  93. MySQL: get post_tag items that are tags (not SEO keywords)
  94. $wpdb->get_var returns 0
  95. cannot log in to the mysql server (wamp and wordpress)
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?

Leave a Comment