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

Reply via email to