{"id":223,"date":"2015-04-27T14:06:17","date_gmt":"2015-04-27T14:06:17","guid":{"rendered":"http:\/\/betakb.veeble.org\/?p=223"},"modified":"2025-03-27T11:53:55","modified_gmt":"2025-03-27T06:23:55","slug":"sql-safe-mode-2","status":"publish","type":"post","link":"https:\/\/www.veeble.com\/kb\/sql-safe-mode-2\/","title":{"rendered":"How to disable Sql.safe mode via php.ini"},"content":{"rendered":"\n<p>Ever come across an error like this(sql.safe):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Notice: SQL safe mode in effect - ignoring host\/user\/password information in [path]\/adodb-mysql.inc.php on line 343 \n<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql_connect(): SQL safe mode in effect - ignoring host\/user\/password information in [path]\/adodb-  mysql.inc.php on line 339\n<\/pre>\n\n\n\n<p>The solution is straightforward.<\/p>\n\n\n\n<p>In the php.ini file, set<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[SQL]\nsql.safe_mode  = Off\n<\/pre>\n\n\n\n<p>If sql.safe_mode is enabled, mysql_connect() and mysql_pconnect() ignore any arguments passed. Instead, PHP attempts to connect using the following details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>host: local host<\/li>\n\n\n\n<li>user: the user PHP runs as<\/li>\n\n\n\n<li>password: an empty string (&#8220;&#8221;)<\/li>\n<\/ul>\n\n\n\n<p>So all the MySQL connect functions will fail.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-uagb-call-to-action uagb-block-179f1fd9 wp-block-button\"><div class=\"uagb-cta__wrap\"><h3 class=\"uagb-cta__title\">Fast Python Hosting<\/h3><p class=\"uagb-cta__desc\">Experience lightning-fast loading speeds for your Python apps with Veeble&#8217;s optimized hosting. Get the performance your project deserves.<\/p><\/div><div class=\"uagb-cta__buttons\"><a href=\"https:\/\/www.veeble.com\/in\/python-hosting\/\" class=\"uagb-cta__button-link-wrapper wp-block-button__link\" target=\"_blank\" rel=\"noopener noreferrer\">Get Started<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\"><path d=\"M504.3 273.6l-112.1 104c-6.992 6.484-17.18 8.218-25.94 4.406c-8.758-3.812-14.42-12.45-14.42-21.1L351.9 288H32C14.33 288 .0002 273.7 .0002 255.1S14.33 224 32 224h319.9l0-72c0-9.547 5.66-18.19 14.42-22c8.754-3.809 18.95-2.075 25.94 4.41l112.1 104C514.6 247.9 514.6 264.1 504.3 273.6z\"><\/path><\/svg><\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ever come across an error like this(sql.safe): Notice: SQL safe mode in effect &#8211; ignoring host\/user\/password information in [path]\/adodb-mysql.inc.php on line 343 mysql_connect(): SQL [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":8196,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-223","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php"],"uagb_featured_image_src":{"full":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_.png",1366,768,false],"thumbnail":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_-150x150.png",150,150,true],"medium":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_-300x169.png",300,169,true],"medium_large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_-768x432.png",768,432,true],"large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_-1024x576.png",1024,576,true],"1536x1536":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_.png",1366,768,false],"2048x2048":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/How-to-disable-Sql.safe-mode-via-php.ini_.png",1366,768,false]},"uagb_author_info":{"display_name":"Digin Dominic","author_link":"https:\/\/www.veeble.com\/kb\/author\/digin-dominic\/"},"uagb_comment_info":1,"uagb_excerpt":"Ever come across an error like this(sql.safe): Notice: SQL safe mode in effect - ignoring host\/user\/password information in [path]\/adodb-mysql.inc.php on line 343 mysql_connect(): SQL [&hellip;]","_links":{"self":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":5,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":8348,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/223\/revisions\/8348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media\/8196"}],"wp:attachment":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}