I have problems setting up the MySQL database for my application

If you have problems setting up the mysql database for your application please make sure that:

  • Your application is using the correct mysql hostname: localhost
  • Your application is using the correct mysql database / username / password. Make sure you have followed this tutorial for creating them;
  • Don't forget to specify your mysql username and database with the prefix yourusername_ in front of its given name. For example your CPanel username is siteground and you have named your database joomla. In this case you have to refer to your database as siteground_joomla;
  • Your application is connecting to TCP port 3306.

You can also check cPanel's video tutorial for additional information:

http://www.cpanel.net/media/tutorials/addmysql.htm

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to export/import a MySQL database via SSH

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

Error about legacy type authentication (old-style) when connecting remotely to MySQL

This particular error can occur in some MySQL clients. The reason for it is that our servers...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...

How to reset the password for a MySQL database?

You may need to change the password of your database in order to improve the security of your...

I cannot create views in MySQL

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...