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.