Okay it appears my mysql database is simply screwed up.
I am attempting to rebuild the root account and privileges and now I
cant do anything. How do I rebuild the root account with proper
privileges and the grant option.
I am thinking:
mysql -u root
use mysql;
GRANT ALL PRIVILEG
Anyone know of a way to do a query within MySQL kind of like a relevance but
without the Full Text index?
I am searching on country, region and city. Now, that's easy enough but what
if I need to sort by full match down to partial and no matches but always
get something like always a found set of
You can easily get around that behaviour by specifying 127.0.0.1, though :-)
On Tue, Aug 11, 2009 at 8:56 PM, Gavin Towey wrote:
> Andrew,
>
> Yes it's true, because when you specify localhost, you're using the local
> socket file. The port only has meaning for TCP connections.
>
> Regards,
> G
Hi Imran,
Have a look at MySQL MMM for Multi-Master Replication failover. The project
is currently in refurbishment when ti comes to having a home, but you can
start by looking at : http://mysql-mmm.org for information.
This project is made for exactly what you want to achieve: Having multiple
ma
I want to fix a replication issue with a 2-node cluster (one active,
one passive) that is using Heartbeat for failover. The nodes are in
Master-Master configuration (that is, each is the slave and master of
the other).
I have several other hosts that are replication slaves from the active
node. Th
