Re: mysql dependancy problems.

[Dean Hamstead <dean@bong.com.au>]

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.