When I run mysqlbinlog on my binary.log file (I specified that filename),
under some situations I cannot read the file, I get Bad Magic Number error.
/etc/my.cnf
log-bin=/usr/local/mysql/data/binary.log
Results:
- On mysql 3.23.35 on Solaris 7 I have to run "flush master" from the mysql
client to restart the binary log before mysqlbinlog can read it, if I don't
run that and try to read the file I get the bad magic number. (ERROR: Bad
magic number; The file is probably not a MySQL binary log)
- On mysql 3.23.32 on Solaris 7 nothing works
On all versions, if I don't specify the log-bin=<filename> and just do
"log-bin" mysqlbinlog reads the auto created file fine!
Any ideas on why this is happening?
Bill "Elvis" Gibbs
goEbusiness.com - putting e-motion in your business
email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938
-----Original Message-----
From: Chris Wilkinson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 12:53 PM
To: Randy Davis
Cc: '[EMAIL PROTECTED]'
Subject: Re: MyODBC Access Denied Error
In message <1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER>, Randy
Davis <[EMAIL PROTECTED]> writes
>I was wondering if anybody would be able to help me with this. I've got a
>MySQL database set up on my Linux server. I want to be able to access it
>remotely, but all we get when we try to access is the following message:
>
>ODBC - call failed
>[MyODBC] Access denied for user: 'user@hostname' (Using password: YES)
>
>Background:
>user has been set up in the mysql user table, with host = %
>the database has been set up in the mysql host table with host = %
>
>Any clues or information would be extrememely appreciated! Thanks!
>
>Ciao
>Randy
I think I have got past this one. It looks as though the password may
not have been correctly set up. You should get a response message to
say that a line has been entered. Also have you used mysqladmin reload
-p to update the password entries.
In ODBC the user name and password should be that for the mysql database
and not for logon to the domain server.
Hope that helps.
CHRIS
--
Chris Wilkinson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
