[arch-general] Nuking a MySQL Install

[Nilesh Govindarajan]

On 02/14/2010 06:17 AM, Samuel Baldwin wrote:
> Howdy.
>
> I fucked up an old mysql install and I want to start completely over,
> but pacman -R mysql (even with --nosave) doesn't remove everything;
> I'm still unable to run '/usr/bin/mysql_secure_installation' after
> reinstalling mysql; it fails setting the new password. Any way to
> completely obliterate all traces of mysql on my machine so I can just
> start over.
>
> This is the output of /usr/bin/mysql_secure_installation which
> includes the error:
>
> arrakis^zedbot# /usr/bin/mysql_secure_installation
>
> NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
>        SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
>
> In order to log into MySQL to secure it, we'll need the current
> password for the root user.  If you've just installed MySQL, and
> you haven't set the root password yet, the password will be blank,
> so you should just press enter here.
>
> Enter current password for root (enter for none):
> OK, successfully used password, moving on...
>
> Setting the root password ensures that nobody can log into the MySQL
> root user without the proper authorisation.
>
> Set root password? [Y/n]
> New password:
> Re-enter new password:
> ERROR 1142 (42000) at line 1: UPDATE command denied to user
> ''@'localhost' for table 'user'
> Password update failed!
>

If you want to keep your data, then do this -

rm -Rf /var/lib/mysql/mysql

Then run mysql_install_db and mysql_secure_installation

-- 
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com