Connecting to MySQL database

[NaK]

I uploaded my website but it doesn't work correctly. It uses a database, which I created, but my pages can't connect to the database. I have the database name, the user name and password and am using localhost as the host. Is there a different host definition?

 

[lylex10h]

See https://x10hosting.com/wiki/How_to_connect_to_a_MySQL_database
If that doesn't solve it, what is the username you are using?

 

[NaK]

I checked everything, including the database password and it seems to be OK.
Which username do you need? for the account or the database?
The account is yolk100@gmx.com
The database is gsnevada_admin

 

[lylex10h]

What is the user name in your database connection string and what is the connection error?

 

[NaK]

The database connection user name is gsnevada_admin. The password is !qazxsw@
I get a simple message (generated by the sql connector): Unable to connect.

 

[lylex10h]

Does the database user have all the permissions?
cPanel --> MySQL Databases --> Click on "gsnevada_admin" below Privileged Users.

 

[NaK]

Yes.

 

[lylex10h]

Is the user assigned to the database and can you access the database with phpMyAdmin?

 

[NaK]

Yes to both. I used NetObjects Fusion 12 to create the website and am now suspicious that the problem is with their database connector. When I try connecting with my own php mysql statement it seems to connect fine. I will look into this later and report.

 

[NaK]

What is the host for the database? I used "localhost" but if it's different it would explain the trouble I'm having connecting.

 

[lylex10h]

This is the code in my wp-config.php file (database, user and password changed)

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'my_database');

/** MySQL database username */
define('DB_USER', 'my_user');

/** MySQL database password */
define('DB_PASSWORD', 'my_p@$$W0rd');

/** MySQL hostname */
define('DB_HOST', 'localhost');

 

[NaK]

It still can't connect. I checked the PHP MySql syntax and everything seems to be OK. The same script works on three other hosts. There muct be something strange in the PHP configuration.

 

[lylex10h]

I used the following test script and it worked:

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php
$dbname = 'name';
$dbuser = 'user';
$dbpass = 'pass';
$dbhost = 'localhost';
$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");
$test_query = "SHOW TABLES FROM $dbname";
$result = mysqli_query($link, $test_query);
$tblCnt = 0;
while($tbl = mysqli_fetch_array($result)) {
  $tblCnt++;
  #echo $tbl[0]."<br />\n";
}
if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
}

From https://gist.github.com/M165437/421cd2d23e53a111541a483971f7368b

 

[NaK]

I'm using php 5.6:
mysql_connect("localhost", "admin", "password") or die('Error connecting to mysql');
mysql_select_db("databse_name") or die(mysql_error());

 

[lylex10h]

I use PHP 7 so that's probably it. Good luck.

 

[Anna]

You might want to switch over to mysqli or PDO for your connection, don't know by heart when it was removed but using mysql_xxx has been depreceted for a while. Simplest is to switch to mysqli_xxx, for most statements it is as easy as just changing mysql_connect to mysqli_connect etc. Some have minor syntax changes, such as mysql_connect() now takes four parameters, where the last one lets you select the database right away instead of using mysql_select_db() after the connection has been set up (you can still use that with mysqli as well though). I know there's a few more syntax changes too, but I haven't really had much reason to look them up.

 

[caftpx10]

...don't know by heart when it was removed...

ext/mysql was removed in PHP 7.0.

 

[NaK]

Problem solved. The website uses cookies and some of the database functions were set to refer to the cookies, which created a mess.