Re: Are MySql passwords sent in the clear?

2010-07-06 Thread David McMath
I think the quoted section is more about how passwords are stored in the database itself than about how they're communicated during login. I read http://dev.mysql.com/doc/refman/5.5/en/secure-connections.html to suggest that there isn't much encryption going on at all, particularly The standar

Re: Are MySql passwords sent in the clear?

2010-07-06 Thread Paul DuBois
http://dev.mysql.com/doc/refman/5.1/en/user-names.html: " MySQL encrypts passwords using its own algorithm. This encryption is the same as that implemented by thePASSWORD() SQL function but differs from that used during the Unix login process. Unix password encryption is the same as that implem

Re: Are MySql passwords sent in the clear?

2010-07-06 Thread John Scoles
andrew...@yahoo.com wrote: Not a 100% sure for MySql but I would think it is. What happens first is the connection to the server is made in this case '$database:localhost:3306' and then internally the username and password are sent. If someone can 'sniff' the connection between the perl prog

Are MySql passwords sent in the clear?

2010-07-06 Thread andrew732
When connecting to a MySql server with DBI->connect: $dsn = "dbi:mysql:$database:localhost:3306"; $dbh = DBI->connect($dsn, $username, $password) is the password sent in the clear? If so, how can this be dealt with? I actually don't care about hiding the plaintext password in the perl source fi

Re: cruddy and smartcruddy : anyone using a different DBI Oracle Port?

2010-07-06 Thread Derrin Morton
Thanks to anyone who read this - I found a O'Reilly had some alternatives My environment required the following for DBI_DSN SetEnv DBI_DSN dbi:Oracle:sid=mydb;database=mydb;host=myhost;port=1524 Thanks Derrin -- Original Message -- Received: 08:42 PM CEST, 07/02/2010 From: "Derrin Mor

Re: how to create database without any handle

2010-07-06 Thread Martin J. Evans
Sumit Sharma wrote: > Hello Martin, > thanks for your reply. Since, I am new to perl i would need your help in > resolving my project problem that I am facing.. > Basically , I am using activePerl 5.8.8 along with mysql. I have a perl > script which reads from txt file the name of a mysql database.