MySQL password issue

2012-10-25 Thread Tim Thorburn
Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Windows Update. I downloaded the Windows Installer version of

Re: MySQL password issue

2012-10-25 Thread Tim Thorburn
: Tim Thorburn [mailto:webmas...@athydro.com] Sent: Thursday, October 25, 2012 12:08 PM To: mysql@lists.mysql.com Subject: MySQL password issue Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running

Re: MySQL refusing to accept passwords

2011-07-22 Thread Tim Thorburn
On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote: On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL

MySQL refusing to accept passwords

2011-07-21 Thread Tim Thorburn
that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point. Thanks in advance, -Tim Thorburn

Re: MySQL loses password?

2011-06-13 Thread Tim Thorburn
: This happens when you use an old client / library. Can you try from command line? Also issue: mysql --version Claudio On Jun 12, 2011 3:09 PM, Tim Thorburn webmas...@athydro.com mailto:webmas...@athydro.com wrote: There's been no upgrade or old pre-upgrade on this machine. I say the same dev

MySQL loses password?

2011-06-12 Thread Tim Thorburn
Hi all, I came across something strange today on my dev machine and thought I'd see if anyone here has run into a similar problem. To begin, my dev machine is Win7 Ultimate 64-bit, running MySQL 5.5.11 (also 64-bit). Today when I tried to log into the server using the old MySQL GUI tools

Re: MySQL loses password?

2011-06-12 Thread Tim Thorburn
There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years, as it is the same password I've used on my dev machines throughout the years. This machine started off as a fresh install of the OS several months ago. The only version of MySQL ever on this

Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
Hello, I just downloaded MySQL 5.5.8 (Win64 version) today and installed it on my dev machine. Previously I had MySQL 5.1.51 installed - as I've always felt it was better to uninstall the old before installing the new with Windows, I uninstalled 5.1.51 by doing the following: - As

Re: Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run

Re: uninstall/reinstall

2010-10-21 Thread Tim Thorburn
On 10/19/2010 12:38 PM, Montgomery, Tammie wrote: I had an old version of mySQL on my computer but never used it. I thought I knew the root password but it wouldn't let me in. I went ahead and uninstalled it thinking I would get a newer version anyway. I used the Windows interface to

MySQL Error 1045

2010-09-20 Thread Tim Thorburn
Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error only occurred when trying to connect to the database as a new user which I found a little odd. After searching Google I discovered that this error is caused by a

Re: MySQL Error 1045

2010-09-20 Thread Tim Thorburn
Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen . On 9/20/2010 10:58 PM, Tim Thorburn wrote: Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error

Importing CSV into MySQL

2009-09-16 Thread Tim Thorburn
Hi, I'm sure I'm missing something quite obvious here, but the caffeine hasn't quite kicked in yet. As the subject says, I'm importing a csv file into MySQL 5.1.36 on WinXP using phpMyAdmin 3.3.2 (Apache 2.2.11 and PHP 5.3.0 should it matter). I've done this many times, however I'm now

selecting DISTINCT and COUNT in MySQL

2003-06-14 Thread Tim Thorburn
Hi, I'm setting up a small tracking program for a site I'm working on - basically it monitors all external web and email links that are clicked from our site and stores them into a MySQL database. Now I'm trying to extract the information from the database and display it on screen with PHP.

Searching a MySQL database

2003-01-16 Thread Tim Thorburn
Hi, I've got a script setup to search two tables in a MySQL database. The first page asks the user to select which table they'd like to search, and then enter in some key words. The second page then determines which table the user selected and performs the search. Right now, I'm going

apostrophe's in PHP MySQL

2002-01-08 Thread Tim Thorburn
Hi, I've been experiencing some sporadic problems with a few web forms written in PHP 3.0.16 and MySQL 3.23.31 with text fields (both single lines and rows). Generally if any of the text in these forms contains an apostrophe - either nothing is entered into the database, or nothing after the

[MySQL] Inserting images into a MySQL DB

2001-08-16 Thread Tim Thorburn
Hi, I'm attempting to store jpg images into a MySQL DB using PHP. I've found a few sample scripts that should do this for me, however, they don't seem to be working. Could someone take a look at this and see if you notice any problems? Thanks -Tim ?php if ($submit) {

Displaying MySQL database with DATE_FORMAT

2001-06-01 Thread Tim Thorburn
Hi, I've developed a simple search engine for a site I'm working on. Its purpose is to display community events based on the users input criteria. The problem is, if I use the DATE_FORMAT command to alter the appearance of the events dates and times - then MySQL begins at the top of the list

[MySQL] DATE_FORMAT

2001-05-29 Thread Tim Thorburn
Hi, I've setup a database to keep track of various events. Now I'm working on displaying these events on the screen through a web browser. I've got all the crucial information displaying - now its time for a little fine tuning. All the dates in my database are ISO format, so -MM-DD, I'd

[MySQL] Reporting time in Greenwich Mean Time

2001-05-26 Thread Tim Thorburn
Hi, I've got a time/date stamp for a database I'm working on which logs the last time and date that any changes were made to the database. What I'd like to be able to do is have the time be set to Greenwich Mean Time rather than the local time of the server. Current I'm using NOW() to enter

MySQL sorting

2001-05-24 Thread Tim Thorburn
Hi, I'm using PHP to pull information out of my MySQL database - although its not entirely working. Here is the line: $result = mysql_query(SELECT * FROM comcal2001 WHERE id=$id and EventMonth='May',$db); What I'd like this to do is select all the fields in my database where the month =

Re: MySQL sorting

2001-05-24 Thread Tim Thorburn
The problem is that this line is not telling MySQL that I want it to select only the fields where the EventMonth = May. Displaying the other fields is not a problem at this time. At 09:54 PM 5/24/2001 -0500, you wrote: At 9:49 PM -0500 5/24/01, Tim Thorburn wrote: Hi, I'm using PHP to pull

Telnet into MySQL

2001-05-21 Thread Tim Thorburn
Hello, Can someone here recommend a good Telnet program (with SSH) that I can use to connect to my servers MySQL database? Preferably something shareware/freeware - but if it must be purchased, I'm not against that. Thank you -Tim

Re: Telnet into MySQL

2001-05-21 Thread Tim Thorburn
Message- FROM: Eric Fitzgerald TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED] DATE: Mon 5/21/01 15:58 SUBJECT: Re: Telnet into MySQL I really prefer SecureCRT from VanDyke software myself. Perfect blend of features and simplicity for my needs. It has a shareware version that does expire

[MySQL] Backwards Compatible?

2001-04-11 Thread Tim Thorburn
Hello, Is MySQL backwards compatible? On my main machine I'm running MySQL 3.23.36 and our hosting company is using MySQL 3.22.32 - the database I've created is a simple listing of local businesses with contact information, so I don't believe there would be any issues of my using features

[MySQL] User name/password

2001-04-10 Thread Tim Thorburn
Hello, After playing around for a few days in between real work, I got my new linux box up and running with RedHat 7.0 and MySQL 3.23.33 (the version the hosting company we use supports). My problem is that I know what password I use for the database as I need to type it in every time I

[MySQL] Backup error

2001-04-09 Thread Tim Thorburn
Hello, I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my databases/tables to CD-ROM last week. When I tried to access them again from the CD-ROM, I noticed that all file names had been altered to be displayed in uppercase and now they will not function in the php

MySQL 3.22.32 and RedHat 7.0

2001-03-20 Thread Tim Thorburn
Hello, I'm a MySQL newbie (hopefully, there's a few others of me around so I won't feel like I stick out so much). I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18, and MySQL 3.22.32 (I know its an older version, but our web hosting service has not upgraded their