php in windows

Posted on 2011-03-13
Last Modified: 2012-05-11
I have a php code run on windows I have only one machine i dont want my staff to know password  how can i conceal config.php which keep my sql user name and password from mystaff
Question by:teera
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +4
LVL 12

Expert Comment

by:Mohamed Abowarda
ID: 35124917
You will have to store the username and password in more secure place, I recommend you to store them in database and use MD5 hash.

Author Comment

ID: 35125094
Hi Medo3337
 If i encript it only that file it work or not and how can i encrypt it
LVL 12

Accepted Solution

Mohamed Abowarda earned 100 total points
ID: 35125134
To encrypt the password with MD5 hash use php md5() function

$password = "This variable will store the original password";
$password = md5($password);

Now $password contains the encrypted password.

I don't recommend you to save your login information into PHP file.
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

LVL 13

Expert Comment

ID: 35125165
I think what teera needs is prevent others from viewing his "MySQL Account" (which is written in config.php to connect to DB)
If I'm right, then teera needs some kind of sourcecode encoding, so that other can't view it.

Some recommendation: Ioncube, Zend Guard (all non-free unfortunately)

Author Comment

ID: 35125448
Hi experts

Are there any software is free I need only encript 2 or 3 file
LVL 27

Assisted Solution

by:Lukasz Chmielewski
Lukasz Chmielewski earned 100 total points
ID: 35125772
It is not that simple. Is your skilled with computers / programming ?
Either you encrypt the file as dsmile says or you could buy another machine (or for that matter put a virtual one) and install a web server there with proper permissions. The machine you have now would have just an access to view the page / application.

Expert Comment

ID: 35126658
Encrypt and store in config file... the simple one
LVL 34

Assisted Solution

by:Beverley Portlock
Beverley Portlock earned 200 total points
ID: 35127998
IF they have access to the PC in question then, ultimately, there is nothing you can do.

In securing systems the first rule is to restrict physical access to the machine because anyone in the room with it can do what they like. Even if you password protected the machine they could reboot it using a "Live CD" or an OS on a memory key and then read whatever files they wished. Chnaging the OS to Mac or Linux would make no difference either. If you stripped the machine down and removed all CDs, floppies, USB connectors, etc then you still would not be secure because it only takes a few seconds to pop the lid and remove the hard drive.

I know this seems extreme, but it makes the point - as long as other have physical access to the machine then data stored on it cannot be secure. Your only hope would be to add encryption software and encrypt the entire hard disk and then never give the encryption key out for any reason and never let anyone else use the PC either.

Personally, I would rent a low cost VM on an external server and put everything on it instead and logon with SSH.
LVL 14

Assisted Solution

by:Scott Madeira
Scott Madeira earned 100 total points
ID: 35128462
If your concern is with the other people knowing your MySQL username and password for the database then I suggest you create an additional user in the database with what ever rights they need for the data and give that username and password to your employees.  this is what would be in the config.php file.

You would have the root/admin username and password available to you if you ever needed to access the database outside of your application.

When your employees no longer need access to the database you can delete the new username/password.
LVL 12

Expert Comment

by:Mohamed Abowarda
ID: 35128678
Put config.php in a folder and set the access permissions for that folder, so your staff wouldn't be able to access it.
LVL 34

Assisted Solution

by:Beverley Portlock
Beverley Portlock earned 200 total points
ID: 35129105
For all of you who think that changing a password on a machine that is not physically secured, here is how to reset ANY MySQL password including the root password

"If you set a root password previously, but have forgotten it, you can set a new password. The following sections provide instructions for Windows and Unix systems, as well as generic instructions that apply to any system. "

Notice that this is listed in the MySQL on line manuals - I'm not leaking secrets here.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit ( and similar technologies have enjoyed wide adoption, making it possib…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question