[Klug-general] Round and round, like a windmill in the sky!

[Sharon Kimble]

On Fri, 18 Oct 2013 11:30:34 +0100
Dan Attwood <danattwood at gmail.com> wrote:

> have you thought about not using phpmyadmin and using mysql workbench
> instead?
> That will give you a gui way of managing the Mysql without needing to
> run an other webapp  which would also need to be kept up to date
> 
I didn't know of 'mysql-workbench' until now, thanks for it. I'll
certainly have a go at using it, but atm I'm /completely/ unable to
access the mysql setup at all. Even like this -  
'mysqladmin -u root -p ******** drop 
Enter password: 
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

I've tried my user name, another user name, several different passwords
for root, but I just cant get back in! Its almost as if it dropping any
and all users with passwords! And so far my googling hasn't been very
effective. 

I'm reluctant to install 'mysql-workbench' until I've got access to
mysql properly again. If I could just find where the database is to
delete it, after removing mysql-server and mysql-client, but I just
feel that removing the program will not delete the database. 

Ho hum!

Sharon.

> 
> 
> On 18 October 2013 10:59, Sharon Kimble <boudiccas at talktalk.net>
> wrote:
> 
> > On Fri, 18 Oct 2013 09:44:10 +0100
> > Paul Littlefield <info at paully.co.uk> wrote:
> >
> > > On 18/10/13 09:42, Sharon Kimble wrote:
> > > > I get the login page up from phpmyadmin, and can log in to it
> > > > but cant create a new user. I did create a user for myself and
> > > > deleted 3 out of 4 root accounts, but now can only log in as
> > > > the remaining root user, with my password but not as myself.
> > > > How do I reset the defaults in phpmyadmin please?
> > >
> > > The defaults for phpmyadmin are the system's root user.
> >
> > That must be one of the three that I deleted then, because it
> > doesn’t work now! Sorry, I didn't see this at first.
> > >
> > > What distro is it please?
> > >
> >  I think that I'm going to remove phpmyadmin, clean and purge and
> > then reinstall it and hope to get the defaults back again and all
> > of them too. Because atm its severely broken.
> >
> > Sharon.
> > --
> > A taste of linux = http://www.sharons.org.uk
> > efever = http://www.efever.blogspot.com/
> > efever = http://sharon04.livejournal.com/
> > my git repo = https://github.com/boudiccas/dots
> > Debian 7.2, Fluxbox 1.3.5, LibreOffice 4.1.0.4
> > Registered Linux user 561944
> >
> > _______________________________________________
> > Kent mailing list
> > Kent at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/kent
> >



-- 
A taste of linux = http://www.sharons.org.uk
efever = http://www.efever.blogspot.com/
efever = http://sharon04.livejournal.com/
my git repo = https://github.com/boudiccas/dots
Debian 7.2, Fluxbox 1.3.5, LibreOffice 4.1.0.4
Registered Linux user 561944
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: not available
URL: <http://mailman.lug.org.uk/pipermail/kent/attachments/20131018/85a9949c/attachment-0001.pgp>