Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: SQL safe mode in effect errors  (Read 2439 times)

0 Members and 1 Guest are viewing this topic.

Aby

  • Guest
SQL safe mode in effect errors
« 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!!