Create new dbuser

[valkis]

Website URL

http://xanthis37.free.nf/

Error Message

HTTP ERROR 500

Other Information

I transferred all the files the website needs and created the data base “if0_36055389_xanthis37”
Also created the tables and filled them with the correct data.However I still take the 500 message. The only thing I didn’t do is to create the database user. Can i have help on this?

[Frank419]

@valkis

The only thing I didn’t do is to create the database user.

You can’t do this normally. The only exception is that Softaculous automatically creates extra DB users, but since you are configuring things manually, you’ll have to use your hosting account credentials.
So your DB user would be if0_36055389 here.

By the way, take note that we don’t use localhost here.

Read these for more information:

Common MySQL Connection Errors

Many websites use MySQL databases to store information and settings. However, there are some reasons why the connection to the database may fail. This article describes some commonly seen error messages when connecting to a database, as well as some general tips to keep in mind when setting up a database connection. Common Error Messages Using MySQL is great, but the error message returned if there is an issue logging in to your database can be quite confusing. Here are some commonly seen error…

How to connect with MySQL

Both the popular PDO and MySQLi libraries are available on all accounts and PHP versions, which are the libraries all (modern) scripts use to connect to a MySQL database. However, to use a database, you need to configure a few things first. Before you can use a database, you need to create the database first. You can create a database through your control panel in the section called MySQL Databases. Simply enter a desired name in the text box and click Create Database. To use the database with…

[Admin]

@valkis

However I still take the 500 message.

A HTTP ERROR 500 just means your PHP code has crashed. It could be a problem with the database itself, the credentials, or something else entirely.

The first thing to do is enable error messages so you can try to get a real error message with details about the actual issue.

Http error 500

When trying to access your website, you may see a page which returns the status code “500”. In Google Chrome, you’ll see a page with the error code HTTP ERROR 500. There are typically two reasons which can cause this error: The PHP code has crashed. The .htaccess file contains invalid rules. Here are some things you can try to debug and fix this. Fixing crashing PHP code A HTTP ERROR 500 simply tells you that the PHP code has crashed, but gives no information as to why it has crashed. Gett…

[valkis]

I don’t understand why I can’t connect to the base. I use the following code:

define(‘DB_SERVER’, ‘localhost’);
define(‘DB_USERNAME’, ‘if0_36055389’);
define(‘DB_PASSWORD’, ‘Χχχ’);
define(‘DB_NAME’, ‘if0_36055389_xanthis37’);
$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);

Also try with the following code:
$link = mysqli_connect(DB_USERNAME, DB_PASSWORD, DB_NAME);

What is wrong;

[YT_Xaos]

Please edit your post and remove your password.

@valkis

define(‘DB_SERVER’, ‘localhost’);

This is probably why. Please check your SQL server in the client area.

[Admin]

I have reset your hosting account password. You can find it in the client area, and will need to update your code to use it. Feel free to change the password again, just make sure to not reuse this password.

Please note that this is a public forum, anything you share here can be seen by anyone. So always make sure to hide sensitive details in the code you share, especially passwords and other credentials.