Admin-Ahead Community

General Category => General Discussion => Topic started by: Aby on January 13, 2014, 06:35:15 am

Title: SQL safe mode in effect errors
Post by: Aby on January 13, 2014, 06:35:15 am

SQL safe mode in effect errors

Sql.safe mode Errors
If you have any mysql connection errors and received error with cpanel user name authentication errors. If sql.safe_mode is enabled, mysql_connect() and mysql_pconnect() ignore any arguments passed to them. Instead, PHP attempts to connect using the following details:

host: local host
user: the user PHP runs as
password: an empty string (“”)

For example,

Notice: SQL safe mode in effect – ignoring host/user/password information in

mysql_connect(): SQL safe mode in effect – ignoring host/user/password information in

This is caused due to your php.ini sql safe mode settings.

Login your php.ini file.

Code: [Select]

vi /usr/local/lib/php.ini
and turn off sql.safe mode.

[SQL]

Code: [Select]

sql.safe_mode  = Off
Restart apache

Code: [Select]

/etc/init.d/httpd restart
Thats all!!