openSUSE Forums > Applications » How to completely remove MySQL including users etc

Go Back   openSUSE Forums > Applications
Forums FAQ Members List Search Today's Posts Mark Forums Read


Applications Questions about desktops (KDE, Gnome, XFCE, etc.), software applications (configuration, usage, bugs, documentation)

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-Nov-2009, 08:24
Axeia's Avatar
Parent Penguin
 
Join Date: Jul 2008
Location: Netherlands
Posts: 988
Axeia 's reputation will be famous soon enoughAxeia 's reputation will be famous soon enoughAxeia 's reputation will be famous soon enough
Default How to completely remove MySQL including users etc

How do I completely remove mysql, telling YaST software management to uninstall it and doing a sudo rm -R /var/lib/mysql/
doesn't seem to be sufficient.

After rebooting my router (which is most likely unrelated) I wanted to resume my work.. but the PHP software informed me it couldn't contact the database, next step was phpMyAdmin which wouldn work either.
So I thought I'd rerun /usr/bin mysql_secure_installation, but I get stuck at the first step. It wont recognize my password.

So I tried to reset the password with the following
Code:
pkill mysqld   
mysqld_safe --skip-grant-tables &
mysql -u root mysql
UPDATE user SET password=PASSWORD("ualue=42") WHERE user="root";
      FLUSH PRIVILEGES;
Which got me the result
Code:
Query OK, 0 rows affected (0.01 sec)                                                           
Rows matched: 0  Changed: 0  Warnings: 0                                                       

Query OK, 0 rows affected (0.02 sec)
matched 0? Seems like I'm missing the entire root user, I don't care much for having to start over with a fresh mysql install.. but it doesn't seem to let me. /usr/bin mysql_secure_installation always gets me stuck on the first step (triedd both the password it should be and leaving it blank)
__________________
Special effects <- KDE 4.2 Showing off
More KDE -> PINK KDE
Reply With Quote
  #2 (permalink)  
Old 03-Nov-2009, 09:34
hcvv's Avatar
Wise Penguin
 
Join Date: Jun 2008
Location: Netherlands
Posts: 1,913
hcvv 's reputation will be famous soon enoughhcvv 's reputation will be famous soon enoughhcvv 's reputation will be famous soon enough
Default Re: How to completely remove MySQL including users etc

When I read this I would summarize:

. uninstalled through YaST softeare management every package that started with mysql;
. removed all of the database data (inclusing administration;
. some software (PHP) that uses MySQL is appently still running and complains (not amazing to me);
. you run mysql_secure_installation, which is provided by the mysql package which you just deinstalled!

From this point on I am flabbergasted.
__________________
Henk van Velden
Reply With Quote
  #3 (permalink)  
Old 03-Nov-2009, 14:10
Axeia's Avatar
Parent Penguin
 
Join Date: Jul 2008
Location: Netherlands
Posts: 988
Axeia 's reputation will be famous soon enoughAxeia 's reputation will be famous soon enoughAxeia 's reputation will be famous soon enough
Default Re: How to completely remove MySQL including users etc

More like
Error
Double check with another app, still an error
Rerun /usr/bin mysql_secure_installation (password error)
Uninstall everything I can find, try /usr/bin mysql_secure_installation again (password error)
Try to alter the user rights table via query.. user doesn't exist

Wondering why the hell it didn't exist trying to run /usr/bin mysql_secure_installation again.. still password error.
__________________
Special effects <- KDE 4.2 Showing off
More KDE -> PINK KDE
Reply With Quote
Reply

Bookmarks


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




 

Search Engine Friendly URLs by vBSEO 3.3.0 RC2