phpcms cannot connect to remote database-PHPCMS-php.cn

Home

CMS Tutorial

PHPCMS

phpcms cannot connect to remote database

angryTom

Feb 18, 2020 pm 12:23 PM

phpcmsdatabaseconnect

phpcms cannot connect to remote database

phpcms cannot connect to the remote database

Cause: The database password is a special character.

When installing phpcms, it appears that the database server cannot be connected. Please check the configuration, but the database information is completely correct.

I searched a lot on the Internet but could not solve the problem. Later I found out that it was the database password. There are two ways to solve this problem if there are special characters "such as: !@#".

Related recommendations: phpcms tutorial

The first is to change the database password , but this is not particularly good, right?

Second method: modify two places in total

1 Modify install/step5.tpl.php line 127

var url = &#39;?step=dbtest&dbhost=&#39;+$(&#39;#dbhost&#39;).val()+&#39;&dbuser=&#39;+$(&#39;#dbuser&#39;).val()+&#39;&dbpw=&#39;+$(&#39;#dbpw&#39;).val()+&#39;&dbname=&#39;+$(&#39;#dbname&#39;).val()+&#39;&tablepre=&#39;+$(&#39;#tablepre&#39;).val()+&#39;&sid=&#39;+Math.random()*5;

is replaced with:

var url = &#39;?step=dbtest&dbhost=&#39;+$(&#39;#dbhost&#39;).val()+&#39;&dbuser=&#39;+$(&#39;#dbuser&#39;).val()+&#39;&dbpw=&#39;+&#39;&dbpw=&#39;+escape($(&#39;#dbpw&#39;).val())+&#39;&dbname=&#39;+$(&#39;#dbname&#39;).val()+&#39;&tablepre=&#39;+$(&#39;#tablepre&#39;).val()+&#39;&sid=&#39;+Math.random()*5;

2. Modify install/step6.tpl.php line 55

and replace:

var dbpw = &#39;<?php echo $dbpw?>&#39;;

with:

var dbpw = &#39;var dbpw = escape(&#39;<?=$dbpw?>&#39;);&#39;;

For more information about PHPcmsWebsite Construction Introductory Tutorial, please pay attention to the PHP Chinese website! ! !

The above is the detailed content of phpcms cannot connect to remote database. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn