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

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 th

Re: [PHP] MySQL Password Function

Shaun wrote: "John Nichel" <[EMAIL PROTECTED]> wrote in message 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}', PASSWORD('{$password

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 h

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 te

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 >

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 ja

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 userPas

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 t

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 Ö. [mailto

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()

ECTED]> Cc: <[EMAIL PROTECTED]> Sent: 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 wi

RE: [PHP] MYSQL Password

variable and access 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]] >

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 wa

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 Fai