Could not connect to the MariaDB - MySQL database

You will want to verify you are using the correct database name, username and password.

All databases and username will have your username appended to the beginning to prevent your information from being overwritten by other users using the same names. Because of this you will also want to keep database and usernames short as some applications have problems with longer names.

Keep passwords simple to alpha-numeric. Don't include dots and special characters as some apps have problems with this.

Make sure you have added the username to the database and the correct permissions were selected before adding. This is typically the "all" setting.

Hostname will always be "localhost" unless you are trying to connect to the database remotely using an application such as MySQL Navigator.

When connecting remotely MariaDB / MySQL is accessible via the standard port of 3306.


Share this page:


Was this article useful? Have any suggestions or improvements to the information?

Also Read

How can I parse .html as .php?

Create an .htaccess file and upload it to the root of your public_html directory. Include the...

What is the proper MariaDB - MySQL import and export format?

The easiest way to import and export a database is via the backup section of our hosting control...

Learn MariaDB

MariaDB is a drop-in replacement for MySQL. The lead developer and founder of MySQL, Michael...

Useful CSV to MySQL Script

Provided below is a great tool we have run into for converting CSV files into MySQL format: CSV...

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate 1064256 bytes)....