Re: mysql dependancy problems.
Ok, I tried mysql -u root -p, but I'm getting kicked out:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
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.
On Thursday 23 March 2006 10:13, Dean Hamstead wrote:
> 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 =)
> 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.