RE: Secure logon from VB.net

If MySQL is running on a unix/Linux server you can use the native ssh that is available on that system and then you don't need anything special in so far as ssh or SSL is concerned with MySQL. You don't have to use MySQL 4.x. The basic idea from VB.net is to create an SSH tunnel to the MySQL host

RE: Secure logon from VB.net

You can connect securly using ssh and perform port forwarding through the tunnel. Paul -Original Message- From: Joe Audette [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 2:32 PM To: [EMAIL PROTECTED] Subject: Re: Secure logon from VB.net Thomas, Are you sure that encrypti

MySQL Secure Connection(e.g. SSL) Question

I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

MySQL from Python Error

I encountered the following error when trying to perform a SQL UPDATE to a MySQL database table from Python. I would apprciate any assistance. In the Python code I have tried integer and decimal format specifiers in addition to the string specifier and nothing worked. Traceback (most recent call

MySQL Timeout Question

I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log in locally as an administrator and issues a command such as "DESCRIBE TABLE some_table;" - everything works fine. If I come back at a later time and run the same command again - it fails because of some type of timeout. If

HOWTO add Primary Key to Existing Table

How can I add an auto-incrementing primary key to an existing table? MySQL version 4.0 Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

My SQL Database Synchronization Question

I have two MySQL databases that are networked together. If changes can be made independently to each of the databases - what is the best way to synchronize them? How can I synchronize them in real time? If the network link goes down, can the synchronizations be placed upon a queue until the connect

Problem Query - Help Please

When I execute the following query I get duplicate product_id's as shown below: SELECT * FROM product, product_category_xref, category WHERE product_parent_id='' AND product.product_id=product_category_xref.product_id AND category.category_id=product_category_xref.category_id AND product.product_p

MySQL comments question

I would like to create a *.sql file that I can later use the SOURCE command with. I would like to place comments along side the SQL statements for documentation purposes. Is this possible and if so - how is it done? I don't want to add comments to a table. Thank You Paul mysql --

Multiple concurrent MySQL question?

I desire to configure MySQL in such a way that it will permit me to have two different PHP/MySQL e-commerce applications running concurrently on my development system. The table names and table structure are the same on both applications(and databases). I have received a SQL backup from the new cl

RE: SQL JOIN Challenge - Help Please

Thank you very much! This was the precise solution I was looking for. Brian - I'm sure your method would also work. Thank you both sooo much. -Original Message- From: Chris Tucker [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 2:18 PM To: Brian Moon Cc: Paul Maine; MySQL

RE: SQL JOIN Challenge - Help Please

ginal email. Thank you Paul sql query -Original Message- From: Brian Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 12:11 AM To: Paul Maine; MySQL MySQL Subject: Re: SQL JOIN Challenge - Help Please If I read right, this is a pretty basic join so I am assuming that you

MySQL Table alteration question

The following table uses order_id as the primary key. My problem is that I need to be able to change order_id so that it is not a primary key. Next, I want to add a new auto incrementing key. What sql commands should I use to first back up the table and then to accomplish this modification. This i

Date comparison assistance please

I have a column defined in a table as type date. I desire to include a date comparison in the WHERE clause of the following statement. The following statement is not working correctly, I suspect that there is a formatting issue. The statement returns true even if USER.elig_date has an earlier date

MySQL Error Logs Question

How can I set up MySQL error logging? Is there any PHP MySQL error log parsers? Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Changing existing column data type question

What SQL command can I use to change an existing column in a table with an integer data type to a varchar data type. This is a production table with about 3,000 records. I don't want to loose any of my current data in this column. Thank You Paul -

PHP/MySQL Search Engine Query Question

I am currently working on a website that is implemented using PHP and MySQL. The site currently has a simple search engine that allows a shopper to type in a search string that is stored in $search. For example, if a shopper types in 1972 Ford Mustang $string ="1972 Ford Mustang" Using the follo

MySQL search question

I am currently working on a website that is implemented using PHP and MySQL. The site currently has a simple search engine that allows a shopper to type in a search string that is stored in $search. For example, if a shopper types in 1972 Ford Mustang $string ="1972 Ford Mustang" Using the follo

RE: Grant question

: Wednesday, July 24, 2002 6:27 PM To: Paul Maine Subject: Re: Grant question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this

MySQL Grant Question

I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - Before posting,