Passwords?

russellbcv

If I were to import a text file into a MySQL database which contain passwords is there an easy way I can encrypt all the passwords?

Would I need to use a php script or can I just import and encrypt the passwords?

planetsim

You may find a program in PHP or MysQL GUI type program that maybe able to do it however I havent seen any program that will do this.

You should probably just import the data into the database firstly. Then update all passwords with a simple update SQL statement. Also how are you going to encrypt them?

russellbcv

I had two choices

1) Import from an Access Database (ODBC)

2) Using a software called Navicat.

Can you import files directly from within MySQL ??

russellbcv

The problem I have is that my "register.php" encrypts the password but I don't know how to just add text into the sql database?

I can easily add users to the table using the .php and login using the username & passwords but when I try to import data into the sql table I cannot login which is mainly due to the passwords not be encypted.

If I could code something which doesnt encrypt the passwords and just adds as text then this would solve my problem

planetsim

Well have you imported them yet? How are the passwords meant to be encrypted ?

Once you have imported a simple statement like this

UPDATE tblname SET password = myencryptfunc(password)

myencryptfunc could be md5 or whatever way your doing it.

russellbcv

No not yet.

http://www.rbcserver.net/authenticate.html

username = jroper
password = passworm

As a test could you try and login and see if you are redirected to your own page.