Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found.
Trying to use command line produces the error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
The same Access denied for user 'root'@'localhost' (using password: YES)
happens when tryi
You can still login if you want, check skip-grant-tables.
On Jun 13, 2011 11:55 AM, "Tim Thorburn" wrote:
> Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found.
> Trying to use command line produces the error:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (usin
Try starting the server using --skip-grants-table and then resetting the
password for the root account.
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-grant-tables
I've only seen/heard of the problems you're having with legacy system
tables. Did you restore the data
Hello All ~ I attempted to do a mysqldump when I got this message -- see below:
mysqldump: unknown variable 'datadir=/var/lib/mysql'
Please can someone help me.
Thanks
This message is intended only for the use of the Addressee and
may contain in
Check if this is in the [mysqldump] section of your my.cnf file(s). Of
course it might not be a valid option in mysqldump...I haven't checked...
On 13 Jun 2011 17:00, "Brown, Charles" wrote:
> Hello All ~ I attempted to do a mysqldump when I got this message -- see
below:
>
> mysqldump: unknown va
Hello ~ Thanks Andrew - it worked. It worked after I commented it out on
my.cnf file. Any idea what's the purpose of that statement. I inherited this
system.
Thanks all for quick response
[mysqld]
server-id=2
relay-log=naxbmisq04-relay-bin
set-variable=max_connect_error=100
max_allowed_pack
Unfortunately the decision to run 32-bit libs on 64-bit systems is outside
of my control. Given that it *should* work I'm more interested in
diagnosing whether this is a bug of some sort in libmysqlclient or a bug in
my code/build procedure.
Alex
On Sat, Jun 4, 2011 at 10:06 AM, walter harms wr
Am 13.06.2011 18:45, schrieb Alex Gaynor:
> Unfortunately the decision to run 32-bit libs on 64-bit systems is outside
> of my control. Given that it *should* work I'm more interested in
> diagnosing whether this is a bug of some sort in libmysqlclient or a bug in
> my code/build procedure.
Yo
Hi all,
I'm about to set master-master replication and would like to get
recommendations as to the best method for getting my applications to failover
when needed.
Here are my options, so far:
MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy
This seems like the obvious choice, but I've not
- Original Message -
> From: "Mike Diehl"
>
> I'm about to set master-master replication and would like to get
> recommendations as to the best method for getting my applications to
> failover when needed.
I should already be in bed, but as a very brief reply: I find automatic
failove
I received a recommendation to look at MySQL-MMM http://mysql-mmm.org/.
However, my two servers are in different parts of the country, so I can't use
any IP-based fail over solution. I truly need a proxy that listens on
127.0.0.1 and forwards to either the "local" server, of if needed, to anot
Hello All,
I have a 64bit, 5.5.8 master, and this bug appears on both 5.5.11 and 5.5.8
32 and 64-bit slaves (statement based replication).
I'm finding an auto-increment field (part of a compound primary key) updates
correctly using "null" to insert the next value on the master.. but when
this st
Hank,
I can't reproduce it right now,
But it really seems a bug.
Just a shot in the dark, Are you sure you have statement based and not mixed
replication?
I don't even know if that would affect , just an idea.
Claudio
On Jun 14, 2011 3:07 AM, "Hank" wrote:
> Hello All,
>
> I have a 64bit, 5.5.8
Yes, it's basic out-of-the box mysql replication.
This appears to be an instance of this bug:
http://bugs.mysql.com/bug.php?id=45670
But that bug report was closed two years ago. I have no idea if it's the
server sending bad data or the slaves. I think it's the slaves, because on
the slave error
Both my master and slave bin logs look OK (I think)..
master bin log:
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
SET TIMESTAMP=1308012505/*!*/;
SET @@session.pseudo_thread_id=9/*!*/;
SET
You should also have a look at the slave relay log.
But in any case sounds like a bug.
Claudio
On Jun 14, 2011 5:18 AM, "Hank" wrote:
> Both my master and slave bin logs look OK (I think)..
>
> master bin log:
>
> /*!40019 SET @@session.max_insert_delayed_threads=0*/;
> /*!50003 SET @OLD_COMPLET
16 matches
Mail list logo
