You can login to mysql via the terminal but cant do the same using phpmyadmin? Okay, as Tony noted, that indicates MySQL is ok. Now, to confirm that it is/is not phpmyadmin, download and drop into your webroot sqlbuddy (http://www.sqlbuddy.com/), its a web based thingy which does the same work as phpmyadmin.

If that works fine, then you know the probz is with phpmyadmin. If it doesnt work also, it means something else e.g. your browser, your web server etc.

Run the query SELECT host, user FROM mysql.`user`; to confirm where the user accounts are allowed access from.

On Wed, Jun 17, 2009 at 3:23 PM, Tony White <tony.mzungu@gmail.com> wrote:
Hi Collins,

You say it's ubuntu 8.04 - but that's only been out for just over a
year - so had you 'upgraded' from a previous version?

You might try removing, and purging phpmyadmin (sudo aptitude purge
phpmyadmin) - then reinstall it (sudo aptitude install phpmyadmin)

You may wish to make sure the system it up-to-date first (sudo
aptitude update - followed by: sudo aptitude upgrade) - or (and i love
this ;) ) using the aptitude 'curses' interface - ugg

The purge will completely remove the phpmyadmin - so a new install
will result in a new download from the repository - and hopefully,
freshly configure it to work.

If mysql works fine from the command line, then I don't think the
problem is on the mysql side of things.

hth,
Tony

2009/6/17 Areba Collins <arebacollins@gmail.com>:
> Ive never encountered this, and my box has been faithfully running DNS,
> Samba and LAMP server for two years non stop. Was using sugar CRM and
> administering using phpmyadmin.
>
> Im running Ubuntu 8.0.4
>
>
>
>
>
> Here is my dilemma: suddenly,
>
> I cant log into mysql from phpmyadmin with any user.
>
> I can log in from the terminal and create a superadmin user and grant
> permissions but when i try logging via phpmyadmin, hamna kitu
>
> I cant log into any instance of my local script (sugar) , with any of the
> users.
>
> I dont get errors except the occassional ¨you have to enable cookies beyond
> here¨ on phpmyadmin.
>
> Anyone with any idea where to begin?
>
> strangely, webmin tool can access the db ok.
>
>
> Regards,
> Areba.
>
>
>
> --
> If you have an apple and I have an apple and we exchange these apples then
> you and I will still each have one apple. But if you have an idea and I have
> an idea and we exchange these ideas, then each of us will have two ideas.
>
> George Bernard Shaw
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> Other services @ http://my.co.ke
> Other lists
> -------------
> Skunkworks announce:
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
> Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
> kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
>
>



--
Tony White
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general