Mysql No connection could be made because the target machine actively refused it

by

Your MySQL server is only accepting connections on *nix socket (/var/run/mysqld/mysqld.sock if you’re running Ubuntu) or for localhost only.

You have to edit your my.cnf (on Ubuntu again is located in /etc/mysql/my.cnf) and change the following:

bind-address = 0.0.0.0

And comment out the following

#skip-networking

Finally restart MySQL.

Be careful with that, if your MySQL machine is accessible from public Internet will be accepting connections from everybody!

More Related Contents:

  1. Fatal error: Call to undefined function mysqli_result()
  2. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  3. Mysqli multiple row insert, simple multi insert query [duplicate]
  4. How to make mysqli connect function?
  5. Laravel one to many relation with a one to one relation
  6. save user images in MYSQL database by which method? [closed]
  7. Can I mix MySQL APIs in PHP?
  8. How to change mysql to mysqli?
  9. How to prevent duplicate usernames when people register?
  10. Best way to INSERT many values in mysqli?
  11. PDO get the last ID inserted
  12. MySQLi prepared statements error reporting [duplicate]
  13. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  14. mysqli: can it prepare multiple queries in one statement?
  15. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  16. Importing CSV data using PHP/MySQL
  17. How to call a MySQL stored procedure from within PHP code?
  18. MySQLi count(*) always returns 1
  19. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  20. Using Mysqli bind_param with date and time columns?
  21. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  22. Selecting a float in MySQL
  23. MySQL skipping first row
  24. Unknown database error in PHP but it exists in PHPMyAdmin
  25. Can I blindly replace all mysql_ functions with mysqli_?
  26. Fatal error: Call to a member function query() on null
  27. mysql injection damages?
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment