RE: inquiry

ysql.com/doc/en/Option_files.html If after all that you still have troubles, drop me an email (use addy in my sig below). State what you did and any error messages you received and I'll be glad to help get you on the right road again. -- Loren McDonald [EMAIL PROTECTED] -Original Message- F

RE: inquiry

cedure is to insert a second entry with Host='localhost' and User='some_user', or to remove the entry with Host='localhost' and User=''. See the full documentation: http://www.mysql.com/doc/en/Access_denied.html -- Loren McDonald [EMAIL PROTECTED] -Orig

RE: mySQL newbie confusion

...and your problem is? -- Loren McDonald [EMAIL PROTECTED] -Original Message- From: Fernando Martins [mailto:[EMAIL PROTECTED] Sent: Sunday, March 02, 2003 6:00 PM To: [EMAIL PROTECTED] Subject: mySQL newbie confusion Hi, my experience comes from VB6 with access databases. I&#x

RE: Database Backup Question

That's exactly what I was looking for and the way I hoped it could be done, only I hadn't seen anything about this 'exec' function. Thanks. I should be able to figure it out myself but I will get back with you if I need further help. -- Loren McDonald Gods Of Music Re

Database Backup Question

file itself by using SELECT and so forth. This seems a bit redundant and extravagant a way to go. Any help would be appreciated. -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/ma

RE: Can MySQL work on Windows XP?

p. If you are still stumped there, write again and include the error message and the c:\windows\my.ini and-or c:\my.cnf settings. -- Loren McDonald [EMAIL PROTECTED] -Original Message- From: Marg Brazil [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:31 AM To: MySQL Su

RE: What are the best MySQL and PHP resource books?

Thanks again to everyone who replied! I finally decided on: MySQL - Second Edition Professional PHP Programming - Second Edition After all the responses here and the feedback through the online bookstores, those are what I'm after. -- Loren McDonald [EMAIL PROTECTED] > -Original

What are the best MySQL and PHP resource books?

looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know.   Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED

What are the best MySQL and PHP resource books?

looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know.   Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED

RE: Access XP crashes regularly when linked to MySQL via MyODBC

is MySQL shutting down, for no apparent reason, every so often. I have just installed .55, so I'm waiting to see if it is still a problem. -- Loren McDonald [EMAIL PROTECTED] > -Original Message- > From: M Wells [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003

RE: Is there anything like Query Analyser for MySQl

You're right. Perhaps it had something to do with the massive worm attack yesterday. It was erroring out with a file not found when I tried last night, but today it worked. -- Loren McDonald [EMAIL PROTECTED] -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED]

RE: Is there anything like Query Analyser for MySQl

That seems to be a dead download link. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com > -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 26, 2003 11:42 AM > To: Scott Lewis; [EMA

RE: weird comparison problem

ot;; -> 1 mysql> SELECT BINARY "a" = "A"; -> 0 -- Loren McDonald [EMAIL PROTECTED] > -Original Message- > Am having a bit of a weird problem with a SELECT on my MYSQL > database: > > If i use this: &g

RE: How to speed things up in MySQL ?

running on the server but for the first week or two of testing I hadn't experienced any kind of slow down. Obviously, for me, something in the background WAS getting in the way, but I couldn't figure out what in the short amount of time is was a problem. -- Loren McDonald [EMAIL

RE: Need nulls in my join

and how (exactly) you want to pull the data. -- Loren McDonald [EMAIL PROTECTED] > -Original Message- > From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 25, 2003 3:48 PM > To: [EMAIL PROTECTED] > Subject: RE: Need nulls in my join > >

RE: Need nulls in my join

Oopssorry. That should have been GROUP BY and not GROUP ON That's what I get for answering a post at 2am. :) -- Loren McDonald [EMAIL PROTECTED] > This one is relatively simple: > > Drop the WHERE evtphoto.phtusage = 1. > SELECT it and then GROUP ON it. > &

RE: Need nulls in my join

This one is relatively simple: Drop the WHERE evtphoto.phtusage = 1. SELECT it and then GROUP ON it. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com > -Original Message- > From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]] > Sen

RE: mysql.users read only?

What I have discovered is that, when mysqld Windows service is running, I can't do anything to the user table. If I start it on the command line with the service stopped but set automatic, it works just fine. An interesting bug? that creates a nice security block. -- Loren McDonald Go

RE: Can't connect to MySQL server & Access denied for root

Sounds like the same problem I'm having (for which I'm still stumped and don't know what has caused it): table mysql.user is read only. Test this by logging into mysql and using the GRANT or REVOKE statements. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL

RE: mysql.users read only?

Just tried. Nope... mysql> grant all privileges on mysql.* to ext identified by 'ext1tex2' with grant option; ERROR 1036: Table 'user' is read only -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com > > Does the user

mysql.users read only?

the problem.   -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com   - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com