Agreed with your point Rick, right now i am maintaining my datadir &
logging in my EBS volumes so if any of the instance goes down ,we will
launch new instance & use the existing EBS volumes and start replication
again.
I think it will start automatically from the point where it goes down and
star
If you have a mixture of encodings, you are in deep doodoo.
This page describes some debugging techniques and some issues:
http://mysql.rjweb.org/doc.php/charcoll
That apostrophe might be MicroSquish's "smart quote".
Can you provide SELECT HEX(the_field) FROM... ? We (or the above page) migh
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web page,
and the content was cut and pasted from other sources. I am finding that
there are some non utf-8 characters in these three text columns. I would
like to
Thanks for the update, Shawn. I'll check it out right now.
On Mon, Sep 24, 2012 at 4:40 PM, Shawn Green wrote:
> Hello Arthur,
>
>
> On 9/24/2012 4:25 PM, Arthur Fuller wrote:
>
>> On this note, one thing that really bugs me about MySQL passwords is the
>> inability to use special characters. In
friends, i figure that i had to give password in quotes. i was then able to
login. thank you all for your help and time.
From: Rajeev Prasad
To: Rick James ; mysql list
Sent: Monday, September 24, 2012 4:11 PM
Subject: Re: user not able to login from localh
mysql> SELECT * FROM mysql.user WHERE user ='myuser';
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+---
this is what i see:
| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD
'*829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925' |
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `mydatabase`.* TO
'myuser'@'localhost' |
+-
Hello Arthur,
On 9/24/2012 4:25 PM, Arthur Fuller wrote:
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or sequ
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or sequence of words.
It must contain at least one numeric digit.
I
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localhost IDENTFIED BY '.
Don't use circular replication with more than 2 servers. If one of your 3
crashes and cannot be recovered, you will have a nightmare on your hands to fix
the broken replication.
> -Original Message-
> From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
> Sent: Monday, Septembe
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad wrote:
> i have given select/insert/update/delete rights to a user on a specific
> database, from localhost. when i try to login to mysql using the uid, i get
> error:
>
>
>
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?
If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';
> -Original Me
I stand corrected and apologize. Numerous multi-master setup descriptions I've
read have said to set this (including the one linked in the original question).
However, as you said, the entry in the manual clearly says it defaults to 0.
Learn something new every day. Thanks Shawn.
On Sep 24, 2
Hello Benjamin,
On 9/24/2012 10:52 AM, Stillman, Benjamin wrote:
replicate-same-server-id = 0 keeps MySQL from replicating binary log entries
from itself. For instance, here's a rough overview:
You write to Server A.
Server A writes that to its binary log.
Server B reads Server A's binary log
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
what other privilege do i need to give this user?
SET foo (...)
Maybe:
SELECT BIT_COUNT(foo) ...
> -Original Message-
> From: Morning Star [mailto:morning.star.c...@gmail.com]
> Sent: Monday, September 24, 2012 7:02 AM
> To: mysql@lists.mysql.com
> Subject: [ask] count items in the SET(value1,value2,value3)
>
> Hi guys,
> i created a ta
Even if you could block them, they would be easy to get around:
SELECT * FROM tbl WHERE 1;
If you have long running queries, you should investigate the reasons (other
than lack of WHERE).
* MyISAM locks the table for any writes. This prevents a SELECT from starting
or a select can prevent th
Parallel Universe* is now available as part of Linux OS images at
www.GoGrid.com.
GoGrid.com is a dedicated/cloud server hosing site.
--
*Parallel Universe is a new extension to My
replicate-same-server-id = 0 keeps MySQL from replicating binary log entries
from itself. For instance, here's a rough overview:
You write to Server A.
Server A writes that to its binary log.
Server B reads Server A's binary log and completes the same thing.
Because log-slave-updates is enabled,
- Original Message -
> From: "Rajeev Prasad"
>
> I am considering using cryptic username for accessing and working on
> a database on my MySQL installation. can anyone with experience
> provide some suggestion pl?
Why would you make your life hard by using cryptic usernames? Have the u
Sounds like you're missing the following in your my.cnf on server B (probably
all of them):
replicate-same-server-id = 0
log-slave-updates
While you're checking, might as well as make sure your auto-increment settings
are in there and correct also.
-Original Message-
From: Adarsh Sh
I am considering using cryptic username for accessing and working on a database
on my MySQL installation. can anyone with experience provide some suggestion pl?
in documentation, i only see that it can be 16 char long. how complex it can
be? any side effects/bugs of username complexity? can I us
Hi all,
Today i set up a circular replication between three nodes A,B & C
successfully.
I expect whatever writes on A will propagated to B & then Propagated to C
because the structure is like below :-
A -> B - > C -> A
I created a sample table stag in test database in A and insert few records
th
Hi guys,
i created a table, one of column named categories contain SET as its
data type. let's say there are N-value in that column.
i inserted a row to that column which contain only 5 values.
INSERT INTO table SET categories ='value1, value2, value3, value4, value5' ;
the question is: how can i c
25 matches
Mail list logo
