Skip to content

Mysql Troubleshooting

Vinzenz Hersche edited this page Jun 12, 2018 · 1 revision

Setup problems

If you have general mysql-problems on setup, it is always a good idea to put phpMyAdmin on the server and look, if you can login.

If this works, YouPHPTube should be able to use the database also.

If not, recheck your setup.

2002 No such file or directory

This can only appear after setup.

Recheck, if the php-mysql-extension is installed.

SQLSTATE[08004] [1040] Too many connections

If this error appears some times, the connection-limit of mysql-server is to low. This can disappear automaticly, when the visitors decreasing - this means, it can also break again, so prepare yourself.

In your my.conf file (usually located in /etc) find the line that says:

[mysqld]

And somewhere below that set

max_connections=500

Or whatever numeric value you need.

More information here: MySQL 5.5 Reference Manual: Too many connections.

Copy-paste from https://stackoverflow.com/questions/2229974/sqlstate08004-1040-too-many-connections

Clone this wiki locally