Problem connecting to mysql db

[Wagan-rave]

hi,
I need more pages to access the db. Currently, in every page I have specified the variables needed for the connection, like this:
$ host = 'localhost';
$ db_user = 'root';
$ pass = 'root';
$ database = 'db_pro';

However, if for example you change the password to access the db should go to each page to change this value. I tried to create a file containing connection.php these variables and then calling this file in the pages where I need using the require, but it seems not work. How can I do?

[kelfro]

I need more pages to access the db. Currently, in every page I have specified the variables needed for the connection, like this:
$ host = 'localhost';
$ db_user = 'root';
$ pass = 'root';
$ database = 'db_pro';

However, if for example you change the password to access the db should go to each page to change this value. I tried to create a file containing connection.php these variables and then calling this file in the pages where I need using the require, but it seems not work. How can I do?

In what sense does not seem to work? If it is called right initialization should be able to connect normally and solve the problem. What you did is right, it remains to understand why it does not work.

Error that you reported?

[opaper]

hi,
mysql supports SSL. Did you check your server's logfiles? most implementations try a private key, then revert to password authentication. Starting the server in "verbose" mode also might enlighten you.

[Zecho]

creates a file called type connection.php
<? php
$ host = 'localhost';
$ db_user = 'root';
$ pass = 'root';
$ database = 'db_prova';
>

then all of your file instead of rewriting these lines, for example in the index.php file type:

<? php
include ( "connection.php");

BODY OF THE PAGE

>

Doing so in all your pages, in case you should change the login information (for example if you change your domain or put your code on other web servers) just changing the data in the file only connection.php.

You could use this method to simplify your pages and to simplify maintenance of the code (eg. A file with only the menus, one with only the header, one with only the footer). One need only recall it from your php page.