ubuntu 13.04 mysql 5.6 clean installation
I installed Mysql 5.5 on Ubuntu and wanted to then make a clean install of
5.6 which became available. Before installing 5.6, I deleted some files
and directories for Mysql assuming that they would be reinstalled when I
did the 5.6 installation. However it appears that that was not the case,
and I had to mess around for hours trying to recreate them, which I have
done, but I still cannot login to mysql other than using "root" IE. "mysql
-u root -p".
Is it possible on Ubuntu 13.04 32-bit to completely remove every last
trace of MySql and then install it? For example, I see that the data is
located in /etc/lib/mysql. is it safe to delete that?
There are various answers to some of these question, but I don't know how
up-to-date they are, and in addition, it appears from my recent experience
that all necessary data is not installed with a new install of 5.6. I've
spent a lot of time on this and used a lot of bandwidth, so I would be
good to get a definitive answer. The latest problem that I have is "error
1045 (28000) : access denied for user 'test3'@'localhost' (using password:
yes)". After creating users and granting privileges etc., I have stopped
the server and restarted it. I don't actually want to solve that problem,
because I want to do a completely fresh installation of 5.6. However,
after a fresh installation, if I have the problem again, I'll need to know
how to fix it. The reason that I want to completely delete everything is
so that I will know that any problems encountered by me are not
attributable to a previous installation.
In addition, there is another instruction I read that says to run the
following after the installation : "sudo mysql_install_db", and "sudo
mysql_secure_installation". I don't know whether that is still valid or
necessary, or what it actually achieves. I did come across what appeared
to be a good answer here, but in light of the problems that I have
encountered, I would like to be sure that what I do will work.
No comments:
Post a Comment