[arch-general] Nuking a MySQL Install
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! -- Samuel Baldwin - logik.li
On Sun, Feb 14, 2010 at 6:17 AM, Samuel Baldwin <recursive.forest@gmail.com>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!
-- Samuel Baldwin - logik.li
Did you try the --debug switch for pacman. See what information it shows.
On Sat, Feb 13, 2010 at 20:50, gt <codered12@gmail.com> wrote:
Did you try the --debug switch for pacman. See what information it shows.
You want pacman -Rscn to "nuke" it. You'll have to manually remove the databases, pacman isn't going to touch your data, nor should it.
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.
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
Worked like a charm, thanks guys. I guess it's a good thing that pacman won't touch my data; not what I was expecting, though, but I much prefer pacman's current behaviour. -- Samuel Baldwin - logik.li
On 02/14/2010 08:12 AM, Samuel Baldwin wrote:
Worked like a charm, thanks guys. I guess it's a good thing that pacman won't touch my data; not what I was expecting, though, but I much prefer pacman's current behaviour.
Its not a guess. Its the design, a feature! Its like saying, "If you don't want to drink the wine, give back the glass" -- Nilesh Govindarajan Site & Server Adminstrator www.itech7.com
participants (5)
-
Antonio de la Rosa
-
Daenyth Blank
-
gt
-
Nilesh Govindarajan
-
Samuel Baldwin