try running the command like this
select * from user where user='root' \G
Capital G is a must.
thanks Doug
Carlos Williams wrote:
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal <carlos.pr...@gmail.com> wrote:
Check how many root rows do you have on the user table (select * from user
where user='root';), some times there are several rows with different grants
and probably you are going through and invalid rule.
I checked and when I ran the command you suggested:
mysql> use mysql;
Database changed
mysql> select * from user where user='root';
I get a bunch of gibberish on the screen but the only thing I can make
out are two entries for root:
| mysql.unixslut.com | root | 6d21bd9609b168e4 | Y | Y | Y
| 127.0.0.1 | root | 6d21bd9609b168e4 | Y | Y
| Y
So what does this mean and how can I resolve this? I am trying this
from the machine locally so I would assume localhost works fine...
--
<http://sfp.central.sun.com/> * Douglas Nelson *
Senior Technical Consultant
*Need Sun JES Help?*
Software Field Practice
Phone +1 877-234-2879/x51438
Mobile 919-259-3719
Email sfp-h...@sun.com
<http://blogs.sfbay/roller/page/sfp>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
