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
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 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 mysql
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
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:
ERROR
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
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 claudio.na...@gmail.com
you probably have the anonymous user account taking over: ''@'localhost'
when you specify
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 the same
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
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
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
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
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 cbr...@bmi.com wrote:
Can someone instruct me on how to sync mysql.user
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
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 will
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,
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
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.
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:
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
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
- Original Message -
From: Baron Schwartz ba...@xaprb.com
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
22 matches
Mail list logo