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.
