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

phpcms cannot connect to remote database

angryTom

Release： 2020-02-18 12:23:46

Original

2288 people have browsed it

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;

Copy after login

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;

Copy after login

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

and replace:

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

Copy after login

with:

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

Copy after login

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!