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. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]