The SQL server is rejecting any INSERT queries. Why? No comments yet

Answer: Please note that some of our hosting packages have a set limit for maximum database size. If you have reached the limit, the sql server will reject any inserts. You can easily monitor your databases usage following the steps:

1. Login to your control panel.
2. Go to Website Manager.
3. Depending on the type of database, click on MySQL Manager or PostgreSQL Manager.

You will be presented with a screen which contains a list of your current databases and a form through which you can create new databases. You can monitory the current database usage from the list and particularly the Space Quota and Used Space columns.

I am trying to access mysql via SSH command line, what is the path to mysql command via SSH? No comments yet

Answer: The command line is as follows: mysql -h<HOST> -D<DB> -u<USER> -p<PASS>

I can’t establish MySQL connection and get this error: “Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) ? No comments yet

Answer: You cannot make connection through socket, please use correct MySQL settings to establish connection (please refer to this post about database settings).

How can I connect to my MySQL/PostgreSQL database? What settings should I use for my script/software? No comments yet

Answer: The correct MySQL/PostgreSQL database settings are:

• DB Host: See your MySQL/PostgreSQL Manager section under DB Host column.

• DB Port: 3306(for MySQL) / 5432(for PostgreSQL)

• DB Name: The database name you have assigned, listed inside MySQL/PostgreSQL Manager section of your control panel.

• DB Username: The database username you have assigned, listed inside MySQL/PostgreSQL Manager section of your control panel.

• DB Password: The database password you have assigned.