How to Completely uninstall MySQL to correct a scr*wed install?
I have made a complete mess of my MySQL installation under Ubuntu Breezy! :confused:
Ubuntu 5.10 comes with MySQL 4.1 preinstalled and running and I set up a localhost client/server with mysql-administrator (new user and privilidges) - connected OK but using mysql-query-browser had a problem (can't connect to socket .... ) and password / host issues.
My dumb butt removed my user and root accounts, removed MySQL 4.1 and installed 5.0 via RPM's with alien and ran mysql_install_db, but now MySQL thinks that root has a password (I figure it should be null) and it is not anything that I can access from the previous setting, and wont let me set up the client/server. Just removing via synaptic and re-installing makes no difference!
How can I kill everything, including settings so I can start again?
I tried to use installation instruciton you recommended but failed
I tried to use instrucitons as you recommended at
MySQL for Linux
for mysql 5.0.
Everything went pretty well. I unpacked archive, make directories and managed to start mysqld as instructed. However when I tried to make clean up I received strange message saying
./bin/mysql_secure_installation: 230: mysql: not found
Indeed, it is installed in directory /usr/local/mysql/bin and it is there.
I tried to call mysql directly. Result was the same. I have no idea of what to do by now. Could you help? Thanks in advance.