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.

  • 578 Users Found This Useful

Was this answer helpful?

Related Articles

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following: MySQLDump all databases into a...

How can I view/modify data in my MariaDB - MySQL database?

Only make changes if you know exactly what you are doing. Often incorrect changes can have an...

How do I backup a MariaDB - MySQL Database?

In the control panel, within Backup section, under Download a SQL Database Backup will be your...

What is the path to PHP5?

We are currently running the latest stable version of PHP5. /usr/bin/php

Learn MySQL

If you do not know how to use MySQL there are some great guides at the following websites....