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,
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
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
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