mysqlmampsequelpro
MySQL said: Can't connect to MySQL server on '127.0.0.1' (4)
the above problem has few solutions here but I couldn't get any of them working so asking.
I have installed mamp and also sequel pro. I am trying to connect using sequel pro but I am getting this error. The whole error is
Unable to connect to host 127.0.0.1, or the request timed out.
Be sure that the address is correct and that you have the necessary
privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Can't connect to MySQL server on '127.0.0.1' (4)
This is the first time I am trying to connect via standard connection.
I tried socket connection it works but I cannot connect the database with my nodejs application. Thanks
Solution
I had same experience using Sequel Pro.
Go to Preferences (Sequel Pro) => Network and increase the timeout seconds to maybe 30.
That solved my issue.
- How do I set the default schema for a user in MySQL?
- How to output geoJSON file from mysql spatial table?
- PHPMyAdmin Configuration not working because of MySQL user password?
- The best way of storing many to many hierarchical data in sql
- JDBC connection without database definition
- Can Magento Connect to Another MySQL database?
- PHP isset() with multiple parameters
- bootstrap table doesnot display data
- CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
- ERROR 2006 (HY000): MySQL server has gone away
- Problems selecting multiple column
- Order rows based on another table?
- MySQL Workbench edit data
- brew start and brew restart wont start service
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Use queryset result as a parameter to a raw SQL in Django
- Getting multiple values for a date for Google Charts
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it