- Original Message -
> From: "Baron Schwartz"
>
> 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql
> -hmysql-inst2 mysql
And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't dri
On 3/16/2012 2:41 PM, Clemens Eisserer wrote:
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already wi
Hi Clemens,
my pleasure!
I forgot, you had to use also -P3306, so using both -h and -P which deny
the lookup for users at localhost,
forcing TCP-IP. and so IPs.
this is also good when the socket file is not in the standard location, you
will have the same problem logging in locally,
using -h and
I was trying to get a confirmation too.
In any event, Charles, I'd try these three steps below and see what happens. I
assume that information_schema is populated "on the fly".
David.
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Friday, March 16, 2012 2:59 PM
To
Hello David,
Precisely, that's what my problem is. The users found in mysqlinst1 are not in
mysqlinst2. There are about 30 users defined in inst1 and only 4 in inst2. I
would like to sync these tables. How do you do it in short of creating 26
accounts in mysqlinst2 one at a time - too tedious.
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already with MySQL-5.1 a few
years ago. I've worked with o
As a follow up question, will it be ok to do the following:
1. mysqldump -hmysql-inst2 mysql
2. Backup mysql-inst1 and use the backup to restore to mysql-inst2
3. mysql -hmysql-inst2 mysql
This way I hope to be able to refresh a DEV instance from a PROD database, but
preserve the permissions, us
Hi Claudio,
> you probably have the anonymous user account taking over: ''@'localhost'
> login as root and:
> mysql> drop user ''@'localhost';
Thanks a lot, that solved the problem (and saved my day :) !).
> when you specify the host with -h you are actually forcing MySQL to use
> TCP/IP so it
Simon,
It's likely that when you specify the times as integer literals they
are being converted to something you don't expect. You can use EXPLAIN
EXTENDED followed by SHOW WARNINGS to see what's happening; it might
be interesting and educational. I would specify the times you want as
datetime lit
Charles,
1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql -hmysql-inst2 mysql
2. With pt-table-sync from Percona Toolkit if you need something more
sophisticated.
On Fri, Mar 16, 2012 at 1:27 PM, Brown, Charles wrote:
> Can someone instruct me on how to sync mysql.user table between to t
Hi,
I have a table that holds two datetime columns. I am trying to find values
from this table that fall into specific time ranges, but am getting some
strange results. For example, if I try to find rows where the difference
between the two column is between 47 and 48 weeks, I get back a result
Can someone instruct me on how to sync mysql.user table between to two mysql
instances.
In other words, I wouild like to copy mysql.user from mysql-inst1 to
mysql-inst2 +
Thanks
This message is intended only for the use of the Addressee and
may con
For those who want to thank Andrew for his spam by putting his SMPT server in
your firewall and/or blackhole list:
# dig mx porcelainbrt.com
porcelainbrt.com. 3600IN MX 0 smtp.asia.secureserver.net.
# dig smtp.asia.secureserver.net
smtp.asia.secureserver.net. 684 IN A
On 3/16/2012 7:00 AM, Clemens Eisserer wrote:
Hi Rik,
Hm, is the mysql-client library the same as the mysql-server?
Yes.
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really strang
> > Hm, is the mysql-client library the same as the mysql-server?
>
> Yes.
Aight...
> > And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's
> > actual IP-address, forcing the TCP/IP connect instead of possible
> > sockets) ?
>
> This is really strange - with -h127.0.0.1 I get
If you want to verify it is very easy:
$ mysql --user=someone somedb (without -p)
mysql> select user(); select current_user();
cheers
Claudio
2012/3/16 Claudio Nanni
> you probably have the anonymous user account taking over: ''@'localhost'
>
> when you specify the host with -h you
you probably have the anonymous user account taking over: ''@'localhost'
when you specify the host with -h you are actually forcing MySQL to use
TCP/IP so it will authenticate you using your ip address (127.0.0.1)
login as root and:
mysql> drop user ''@'localhost';
and try again
Cheers
Claud
Hi Rik,
> Hm, is the mysql-client library the same as the mysql-server?
Yes.
> And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
> IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really strange - with -h127.0.0.1 I get the same error:
ERR
Hi,
1. FLUSH PRIVILEGES is not needed, the SQL commands to manage user and
grants reload automatically the grant tables,
that was used in the very past when people use to tinker directly the grant
tables.
2. you did not specify the @ part of the 'someone' : GRANT ALL ON
somedb.* TO 'someone
> Hi Rik,
>
> > Have you tried the _full_ user-identification (which is with host)?
> >
> > GRANT ALL ON somedb.* TO 'someone'@'%';
>
> Yes I had (and just tried to verify) but it didn't help.
Oops, didn't use reply-to-list instead of reply-to-author, my apologies...
> Could it be Fedora's mys
Hi Rik,
> Have you tried the _full_ user-identification (which is with host)?
>
> GRANT ALL ON somedb.* TO 'someone'@'%';
Yes I had (and just tried to verify) but it didn't help.
Could it be Fedora's mysql packages are special somehow?
Re-installing mysql after deletig its data-directory didn't
Hi,
All I would like to do is the create a small database with a non-root
user which is allowed to access the db, however after hours of trying
I gave up.
I am using MySQL-5.5.20 on Fedora16 .
CREATE USER 'someone'@'%' IDENTIFIED BY 'somepass';
CREATE DATABASE somedb;
GRANT ALL ON somedb.* TO 'so
22 matches
Mail list logo
