[arch-general] Nuking a MySQL Install

[Antonio de la Rosa]

Samuel Baldwin escribió:
> 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!
>
>   
Delete /var/lib/mysql/* and execute mysql_install_db for generate a new
mysql db.