Re: mysql dependancy problems.

[Chris Wakefield <c_wakefield@shaw.ca>]

Hi Dean.
Ok, I tried mysql -u root -p, but I'm getting kicked out:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
NO)
I don't want to delete my databases, as I have a lot of data in there.
not sure what to do next, but any ideas would be helpful.
Thanks,
Chris W.

On Thursday 23 March 2006 10:13, Dean Hamstead wrote:
> try
>
> mysql -u root -p
> then hit enter
>
> if that doesnt work, you can just delete the mysql database
> but you will have to recreate it and then all the users there in
>
> you may also be denied access via 127.0.0.1:3306 but allowed
> access via /tmp/mysql.sock (or wherever your mysql socket
> may be)
>
> your mysql databases are most likely in
>
> /var/db/mysql or /usr/local/var/db/mysql
>
> possibly /usr/local/mysql
>
> each database is actually a directory, each directory has
> files within it for each table. just rm -rf the 'mysql'
> directories within the top mysql dir
>
> so like /var/db/mysql/mysql
>
>
> then use the mysql_create_... or mysql_install...
> whatever. lets just say that 'tab' is my friend. but i do
> know what i am doing =)
>
> Dean
>
> Chris Wakefield wrote:
> > Greetings all.
> >
> > I've managed to re-install mysql-server-5.0, mysql-client-5.0 and the
> > support libraries, etc.  What is happening now is what prompted me to
> > uninstall 2 days ago, which is I mistakenly had phpmyadmin remove three
> > mysql users: root, a user and the debian system maintainer.  The error
> > I'm getting is:
> >
> >  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> > password: NO)
> >
> > Since I can't log in as root, how can I recreate these users?
> >
> > Thanks for any ideas,
> > Chris W.
> >
> > On Tuesday 21 March 2006 20:29, Chris Wakefield wrote:
> >> Hi all.
> >>
> >> Well dang, I managed to unintentially mess up my mysql binaries.  So
> >> anyways, I tried to re-install mysql and found that I was froze out due
> >> to dependancy problems.
> >>
> >> When I try to install mysql-client-5.0, apt wants libmysqlclient15off
> >> installed ... when I install libmysqlclient15off, libdbd-mysql-perl has
> >> to be removed.  When I try to install mysql-client-5.0 again, apt wants
> >> libdbd-mysql-perl.  So there seems to be a direct conflict between
> >> libmysqlclient15off & libdbd-mysql-perl.
> >>
> >> Other than waiting for I'm not sure how long for the dependancies to be
> >> balanced, is there another temporary solution?
> >>
> >> Thanks for any ideas,
> >> Chris W.