mysql连接字符串加密配置,在php中加密/安全数据库连接字符串

one of the project required me to encrypt DB connection string (username & password).

Usually I use .htaccess to restrict user to access from web.

But this project want me to store userid & password not in clear text.

解决方案

It's impossible.

If you encrypt the MySQL password for example with mcrypt, only way to decrypt that MySQL password is to use your secret mcrypt password, which will be, obviously, stored also in some PHP script or elsewhere on the server.

Whoever has an access to the server or can read the script will get an access to MySQL password or any other password used to decrypt MySQL password.

If you project requires you to store password not in clear text, ask the project manager about this logical problem - how can I decrypt the password and how can I store a password to decrypt the password.