Home >CMS Tutorial >PHPCMS >phpcms cannot connect to remote database

phpcms cannot connect to remote database

angryTom
angryTomOriginal
2020-02-18 12:23:462286browse

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 = '?step=dbtest&dbhost='+$('#dbhost').val()+'&dbuser='+$('#dbuser').val()+'&dbpw='+$('#dbpw').val()+'&dbname='+$('#dbname').val()+'&tablepre='+$('#tablepre').val()+'&sid='+Math.random()*5;

is replaced with:

var url = '?step=dbtest&dbhost='+$('#dbhost').val()+'&dbuser='+$('#dbuser').val()+'&dbpw='+'&dbpw='+escape($('#dbpw').val())+'&dbname='+$('#dbname').val()+'&tablepre='+$('#tablepre').val()+'&sid='+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