MySQL Connector/J 5.1.5 Has Been Released!

2007-10-09 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.1.5, the first production release of the 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.5 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0,

how to restore mysql database after Crash

2007-10-09 Thread David Winslow
Hey, Environment: Windows 2003 server Mysql 5.0 server Problem: Our server crashed and the c drive was formatted. Unfortunately we did not have a backup of the mysql databases which we were using. We can hopefully retrieve the file structure through a file system recovery utility.

MySQL Connector/J 5.0.8 Has Been Released

2007-10-09 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.0.8 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. This is a bug fix release for the current production branch of Connector/J. We're releasing version 5.1.5 as a GA today as well, so this is

Unbiased opinion needed on access control procedure

2007-10-09 Thread Matt Juszczak
Hi all, I'm looking to get an unbiased opinion of two possible methods for controlling access to database servers. Here are the specs: * 6 database servers, all firewalled off to the outside world, but accessible to each other on port 3306 unrestricted * 10 web servers total, but only half

secure host and user name for non static ip address

2007-10-09 Thread Stephen Sunderlin
QUESTION: What are the most secure permissions settings for administrator access to connect to my server without using a static IP address? MY ISP changes my DSL ip address almost daily so when I log on to MySQL Administrator with 'myusername'@'currentipaddress' using password 'mypassword' I

Re: secure host and user name for non static ip address

2007-10-09 Thread Gary Josack
Sign up for dyndns.com or some other similiar service. Create permissions to the domain and run a script that updates you IP with dyndns whenever it changes. (such scripts already exist). As far as 'username'@'%' with no password with SELECT, INSERT, UPDATE and DELETE privileges... worst idea

Client does not support authentication protocol requested by server

2007-10-09 Thread John Berman
Hi We have php 4.3.4 and mysql 5 My test script produces this Client does not support authentication protocol requested by server http://www.jewishgen.org/cemetery/connect-test.php Research suggests that I can upgrade php or SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('')

Re: how to restore mysql database after Crash

2007-10-09 Thread B. Keith Murphy
Recover your files first and then you can see where you can go. I suppose you now have backup plans in place now? Keith David Winslow wrote: Hey, Environment: Windows 2003 server Mysql 5.0 server Problem: Our server crashed and the c drive was formatted. Unfortunately we did not