Common Problems with MariaDB and PHP
Error: Maximum Execution Time Exceeded
: This is a PHP limit; go into the php.ini
file and set the maximum execution time up from 30 seconds to something higher, as needed. It is also not a bad idea to double the RAM allowed per script to 16MB instead of 8MB.
Fatal error: Call to unsupported or undefined function mysql_connect() in ...
: This means that your PHP version isn't compiled with MariaDB support. You can either compile a dynamic MariaDB module and load it into PHP or recompile PHP with built-in MariaDB support. This process is described in detail in the PHP manual.Error: Undefined reference to 'uncompress'
: This means that the client library is compiled with support for a compressed client/server protocol. The fix is to add-lz
last when linking with-lmysqlclient
.Error: Client does not support authentication protocol
: This is most often encountered when trying to use the olderMariaDB
extension with MariaDB and later. Possible solutions are: downgrade to MariaDB 4.0; switch to PHP 5 and the newermysqli
extension; or configure the MariaDB server with--old-passwords
. (See "Client does not support authentication protocol
", for more information.)