Related

Product Now Available: Managed MySQL Databases Product
Can't connect to MySQL server on 'DomainIP ' (111) Question Question
What is the root password asked by "mysql_secure_installation" script on a debian 9 system that was setup using SSH (i.e. no root password)? Question Question

Question

Mysqli_connect create error 500

Posted June 7, 2017 7.1k views
MySQLDebian

Hey! I get HTTP error 500 everytime I try to use mysqli_connect in my php file.

This is my code and link to the file I am having trouble with:
http://138.68.86.134/getInfo.php

<?php
  session_start();

  if(!isset($_SESSION["access"])) {
    echo "null";
  } else if (isset($_SESSION["access"])) {
   // Here I am trying to use mysqli_connect
    $db = mysqli_connect("138.68.86.134", "root", "mypassword", "database")
    echo "Confirmed";
  } else {
    echo "Something went wrong...";
  }

 ?>

This is my Info.php file:
http://138.68.86.134/info.php

I’ve followed every step for Debain LAMP tutorial here on DigitalOcean still this doesn’t work. I am very frustrated and I would highly appreciate any answer! Much love <3

Add a comment
southsweden
By:
southsweden
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
Mohsen47 June 7, 2017

@southsweden

Try this quick solution and if it works I will explain it to you.

Replace 138.68.86.134 with 127.0.0.1 and try again.

Reply Report
  • southsweden June 7, 2017

    It works thanks so much! Please explain how this works.

    Reply Report
    • Mohsen47 June 7, 2017

      @southsweden

      Please mark my answer as accepted.

      I already explained that here:

      I think your problem is that the mysqld daemon is only listening on localhost and you are getting connection refused error and even if it is listening on all interfaces the root user by default is accessible only from localhost.

      Reply Report
jtittle1 June 7, 2017

@southsweden

Before we get to troubleshooting, I would highly recommend and encourage you to use a created user instead of root. Should someone find a way in to your application, root access grants them the ability to remove everything (including other databases). You should never run as root :-).

…

That said, you’re missing a ; at the end of the function call for mysqli_connect().

i.e. This line:

$db = mysqli_connect("138.68.86.134", "root", "mypassword", "database")

Should be:

$db = mysqli_connect("138.68.86.134", "root", "mypassword", "database");
Reply Report
  • Mohsen47 June 7, 2017

    @jtittle

    You are absolutely right.

    I think his problem is that the mysqld daemon is only listening on localhost and he gets connection refused error and even if it is listening on all interfaces the root user by default is accessible only from localhost

    Reply Report
  • southsweden June 7, 2017

    Yes thanks very clever. Never thought of that. How do I create a second user on phpmyadmin?

    Reply Report
    • Mohsen47 June 7, 2017

      @southsweden

      I usually work from the terminal and does not use phpmyadmin but there must be a user’s section above where you can create users and grant them privileges from the web UI.

      From the terminal you can use this query from mysql client:

      CREATE USER 'name'@'host' identified by 'password';

      GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'host';

      `REVOKE DROP ON databasename.* FROM ‘user’@'host’

      It is safer to revoke drop privileges from your database user in case your application is breached.

      Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help