sorry if it's a stupid question, but just to cover the basics, you
remembered to flush privileges after adding it right?
-- James
On Jul 11, 2006, at 9:31 AM, John Doolan wrote:
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However, the con
Never mind.
I'll just go RTFM and quit bugging you guys on list with stuff
answered plain as day in
http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
Sorry. I'll go caffeinate myself before asking more stupid questions.
-- James
On Jun 14, 2006, at 11:55 AM, James Barros w
Hey guys, I'm running mysql 5.1.9 and I've got a user who's
mysql.user host is set to "%" and can log in from any domain except
localhost. if I change to localhost, and flush privileges they can
log in.
Is this intended behavior, or should % be inclusive of localhost?
--
MySQL General Ma
omendation and verify that the hash
produced matches the password field in user exactly.
-- Aron L.
James Barros wrote:
Well, for starters don't worry about ports being open. If you
werent able to connect, it would give you a different error message.
select password('yourpasswor
Well, for starters don't worry about ports being open. If you werent
able to connect, it would give you a different error message.
select password('yourpassword'); and verify that the hash produced
matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy
Hello,
I've got 5.1.9 running on FreeBSD and I'm trying to do some backups,
but mysqldump is locking up on me.
when I run:
mysqldump -uroot --opt mysql
(and yes, it's a test box, so there is no root password. I can
duplicate this behavior with other accounts with sufficient priv's
specify
