Re: [PHP] MySQL password file

On Monday 18 July 2005 18:53, Lawrence Kennon wrote: In my current hosting situation I don't have the ability to store my file that contains MySQL userids/passwords in a subdirectory that is not under the server root. In order to protect it from being included from a foreign host I thought up

Re: [PHP] MySQL Password Function

Hi, it's very simple intead of using insert into users set userPassword='123'; you say insert into users set userPassword=password('123'); Shaun wrote: Hi, I am trying to make my site more secure, can anyone suggest a tutorial on using the mySQL password function with PHP. I can't find anything

Re: [PHP] MySQL Password Function

From: Raditha Dissanayake [EMAIL PROTECTED] From: Shaun I am trying to make my site more secure, can anyone suggest a tutorial on using the mySQL password function with PHP. I can't find anything through google... it's very simple intead of using insert into users set userPassword='123';

Re: [PHP] MySQL Password Function

Hi, Oh, and this will do almost NOTHING to make your site more secure. Why do you think it will? ---John Holmes... You are partly right about this we had a nice flame war about this very issue couple of weeks ago on the jabber lists. Anyone interested in the nitty gritty can google on the

Re: [PHP] MySQL Password Function

From: Raditha Dissanayake [EMAIL PROTECTED] Oh, and this will do almost NOTHING to make your site more secure. Why do you think it will? You are partly right about this we had a nice flame war about this very issue couple of weeks ago on the jabber lists. Anyone interested in the nitty

Re: [PHP] MySQL Password Function

Shaun wrote: Hi, I am trying to make my site more secure, can anyone suggest a tutorial on using the mySQL password function with PHP. I can't find anything through google... Thanks for your help Not that this would make your site more secure (well, I guess it would be more secure than plain

Re: [PHP] MySQL Password Function

John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Shaun wrote: Hi, I am trying to make my site more secure, can anyone suggest a tutorial on using the mySQL password function with PHP. I can't find anything through google... Thanks for your help Not that

Re: [PHP] MySQL Password Function

Shaun wrote: John Nichel [EMAIL PROTECTED] wrote in message snip Not that this would make your site more secure (well, I guess it would be more secure than plain text), but just use it in your query INSERT INTO someDB.someTable ( username, password ) VALUES ( '{$username}',

Re: [PHP] MySQL Password Function

On Thu, 6 Nov 2003 09:09:57 -0500, you wrote: True, true. I actually use MD5() for the same reason, but, really, if someone has access to the database to read the hashes, odds are they have access to the rest of the database and your code. So what are you protecting really? Many people use the

RE: [PHP] mysql password function

Use this: $result = mysql_query(SELECT PASSWORD( . $_POST['password'] . )); $password = mysql_result($result,0); or just use mysql_fetch_row() or AS in your query so you don't have to recreate that complex column name. ---John Holmes... -Original Message- From: Murat Ö.

Re: [PHP] MySQL password()

: Tuesday, July 30, 2002 4:31 PM Subject: Re: [PHP] MySQL password() Try doing on the first time this: $query=SELECT * FROM users where username='$PHP_AUTH_USER' and passwd =password($PHP_AUTH_PW); then with mysql_num_rows you find out if the query returned any row.. or with is_resource

RE: [PHP] MySQL password()

Mmm.. think you misinterpreted my question... http://www.mysql.com/doc/M/i/Miscellaneous_functions.html PASSWORD(str) how do you unPASSWORD(str) in PHP? Basically, you don't. Instead, what you do is use the password that was provided as user input. You create a suitable

RE: [PHP] MYSQL Password

it from PHP, you can do this, but i dont know how ;) becuase i've never had to do it. beware of any security risks that this might open you up for... storing passwords as env. vars -Original Message- From: Jack Sasportas [mailto:[EMAIL PROTECTED]] Subject: Re: [PHP] MYSQL Password

Re: [PHP] MYSQL Password

pass the parameter -p and it will ask you for the password Andreas Pucko wrote: Hello, I am trying to get mysql running and connect via php to it. how can I set the password in a unixshell to get access to it? When I try to access the db I get: Warning: MySQL Connection Failed:

Re: [PHP] MYSQL Password

Can you connect to MySQL manually? If so, then you should be able to connect with PHP's mysql_connect($username,$password,$host); __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com The world is