Since -p="" is not valid syntax, it should not work. There is no equal sign after the -p, and no space between the p and the password which needs no quotes. If you have no password leave out the -p option.
Derek Fountain wrote: >Hi, > >I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't >access a database as a local user, but I can as a remote user. That is, on >the local machine I get this: > >>/usr/bin/mysqladmin -u tpdb -p="" create fred >> >/usr/bin/mysqladmin: connect to server at 'localhost' failed >error: 'Access denied for user: 'tpdb@localhost' (Using password: YES)' > >whereas if I access the machine from another Linux box: > >>/usr/bin/mysqladmin -h lowenbrau -u tpdb -p="" create fred >> > >it works. If I do it as the MySQL root user on the local machine that works >OK. I assume something's wrong with my local tpdb user. > >The permissions are set as follows (after a lot of faffing about - I'm not >suggesting these are optimal settings, or the ones I should have): > >localhost root "" <all Ys> >lowenbrau.my.domain root "" <all Ys> >lowenbrau.my.domain tpdb "" <all Ys> >% tpdb "" <all Ys> >localhost tpdb "" <all Ys> > >I've reloaded (and actually restarted) the server, but it won't play. There's >nothing in the db table except a couple of "test" database entries. > >I'm reading up on security issues, but I have someone waiting on this, so if >anyone could give me a pointer as to what I've done wrong, I'd much >appreciate it. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
