Hello

Hi

I have two server, one is database hosted and another one is application base server, in database server i gave the remote access , i can access the database by command prompt but in web through i cant, am not able to understand what i missed.

can you please help me how to get out this situation.


Note : This two server is linux based

Right...this takes us back to last year, when you asked a similar question: https://www.linuxquestions.org/quest...in-4175630472/

You aren't providing us details; saying "linux based" tells us nothing, nor does "web through i cant". You don't tell us version/distro of Linux, what web app(s) you're using to try to access the database, etc. We can't guess, but if you can access it over command-line, then your problem is simple; you haven't configured your web page/system/program/whatever, to use the right connection details. And since you don't tell us what those things are, we don't know what to tell you.

Please say which distro you have on these machines (including version), which version of mariadb you have, and which shell you are using. Also are you accessing through SSH or directly to the database via an exposed external port?

1 members found this post helpful.

am extremely very sorry, I didn't mentioned rest of information .

I have two dedicated Linux server, OS is CentOS 7, On first server i configured the maria db and i set the grant privileges to that server (grant all on *.* to 'root'@'%' . On second server i hosted one web application. now my issues on second server is by command prompt i can access my database by using following command

mysql -u root -h database_ipaddress -p

but on same server i make a simple php page for checking database connectivity.

<?php
$servername = "00.00.00.00";
$username = "root";
$password = "xxxxxxxx";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

when i run webpage like http://abc.com/database.php the its showing error like this

This page isn’t workingsaleszipemail.com is currently unable to handle this request.
HTTP ERROR 500


Thanks

How is the arrangement between the web server with PHP and the mariadb daemon? Are they on the same machine or different machines? If they are on different machines, are they on the same LAN or not?

A 500 error is generic and does not provide any real information.

Check the apache logs on the web server at /var/log/httpd. I assume your using apache.

Did you install the apache php and php-mysql modules?

Does your php script have the correct permissions?

Your missing the database name in the mysqli connect statement
$conn = new mysqli($servername, $username, $password, database_name);

1 members found this post helpful.

@michaelk


Thanks Michael

Its solved. I installed php-mysql modules, now i can access database by webpage.


Thanks once agian.

2 members found this post helpful.