Uninstall Mysql

[theeggman98]

I have an absolute mysql mess and just want to uninstall except I have been unable to find a howto for OSX.

Thanx

E.

[W3iRd0]

If you used Fink, then you use:
%sudo dselect
And find mysql in option (2), press (-) and hit enter, after that chose option (3) to install/uninstall selected packages.

If not, find where mysql was installed and delete it there + all mysql commands fro bin folders (This would take you some time, and it would not be fun, for your sake I hope you used fink.).

[theeggman98]

I did not use fink so I guess I have to do the manual method.

Thanks

[Gwyrrdin]

not really a question for newcomers....but anyway...

you shall have to give more info

what kind of install have you done?
source compile? or binary?

which path did you install to?

etc etc

Gwyrrdin

[DigiScript]

I am having troubles too. I installed the package from http://www.entropy.ch/software/MacOSx/mysql/ which uses the binary format. It installed to /usr/local/mysql. I must have done something wrong because I can not log into MySQL as root, and I dont think I ever did. I basically understand what is going on in the steps given at the URL I downloaded from except for the last one.
After sudo ./bin/safe_mysqld --user=mysql & (that starts mysql under the user mysql and puts it in the background right?) the next step simply says "Use it with mysql test". What the hell is that? After 7 completely clear and specific steps, the 8th and final one is completely vague!
It then goes on to say you should do "mysqladmin -u root password new_password" which is different from the format I have seen elsewhere I think. Nonetheless, I am unable to log in to MySQL as root, meaning all I can do is play with the 'test' db.
I would just like to know how to reset the password, or uninstall MySQL altogether, or whatever I have to do to gain full access.

ANY help will be GREATLY appreciated, but please be as specific as possible. Unix is not my bag, baby.

Thank you,
DigiScript

[W3iRd0]

To reset everything about mysql, including the root password, use the install_db script (mysql_install_db)

mysqladmin -u root password new_password

Is basically

mysqladmin -u root password 'your_pass_here'

to set the root password, otherwise you can login as root without entering any pass i.e.

mysql -u root

Hope this helps.

[lee von]

I tried that, but get an error in Terminal:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

It does not seem to matter what I use for my password. I know what I originally entered when setting up MySQL, but nothing works now.

I am running 10.5.1 server in advances mode on a dual 1GHz G4, MAMP, MySQL tools, stock otherwise. I reinstalled OS X for this Mac to run as a webserver.

[navaho]

You neglected to mention a lot of really important things. Version of MySQL being one of them.

The most important part of that error is the very first line

mysqladmin: connect to server at 'localhost' failed

Your mysqladmin is not connecting to the server. Is it running?

Fix that problem, then if the proble continues read Causes of access denied errors (http://dev.mysql.com/doc/refman/5.0/en/access-denied.html) or how to reset the root password (http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html)

MySQL has just terrific documentation. I'd encourage you to read through that rather than digging up a topic many years old about a server version that's well out of date and probably doesn't apply to you.

[acme.mail.order]

And did you happen to notice that 6 years passed between the "To reset everything" past and the "Tried that..." reply? Several new software versions have come and gone since 2002 and it is somewhat unlikely that the original advice is less than valid now (although the common causes of mysql login failures haven't changed much).

[lee von]

Thanks for the advice navaho. I am new to SQL and php, but this gives me a very appreciated direction to go.

[whatg]

I'm also suffering....

Intel Mac Mini... I tried Tenon iTools (which has been deleted). But now when I try to re-install mysql - either 4 or 5 - it tells me:

Errors in installing software
Please try installing again

When installing it says that it is upgrading, but I have manually deleted mysql from /usr/local/ and /Library/Receipts.

Please help!

Errors from install log are as follows:

PROGRAM:Install PROJECT:Install-146 DEVELOPER:root BUILT:Jul 28 2007 00:13:44\n
Mar 11 15:06:59 Vigilico-1 : @(#)PROGRAM:Installer PROJECT:Installer-104 DEVELOPER:root BUILT:Aug 22 2007 10:34:38\n
Mar 11 15:06:59 Vigilico-1 : Hardware: Macmini1,1 @ 1660 MHz (x2), 1024 MB
Mar 11 15:06:59 Vigilico-1 : Running OS Build: 8S2167
Mar 11 15:06:59 Vigilico-1 : MySQL 4.1.22-max for Mac OS X Installation Log
Mar 11 15:06:59 Vigilico-1 : Opened from: /Volumes/mysql-max-4.1.22-apple-darwin8.5.1-i686/mysql-max-4.1.22-apple-darwin8.5.1-i686.pkg
Mar 11 15:06:59 Vigilico-1 : It took 0.194689 seconds to finish launching.
Mar 11 15:07:00 Vigilico-1 : Distribution: MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:00 Vigilico-1 : Installation checks completed successfully.
Mar 11 15:07:15 Vigilico-1 : admin auth received to install
Mar 11 15:07:15 Vigilico-1 : ================================================================================
Mar 11 15:07:15 Vigilico-1 : User picked Easy Install
Mar 11 15:07:15 Vigilico-1 : Choices selected for installation:
Mar 11 15:07:15 Vigilico-1 : Upgrade: "MySQL 4.1.22-max for Mac OS X"
Mar 11 15:07:15 Vigilico-1 : mysql-max-4.1.22-apple-darwin8.5.1-i686.pkg : com.mysql.mysql : 4.1.22.4.0
Mar 11 15:07:15 Vigilico-1 : ================================================================================
Mar 11 15:07:15 Vigilico-1 : It took 0.000606 seconds to summarize the package selections.
Mar 11 15:07:16 Vigilico-1 : Starting installation:
Mar 11 15:07:16 Vigilico-1 : Preparing volume "Macintosh HD" for installation
Mar 11 15:07:16 Vigilico-1 : Configuring volume "Macintosh HD"
Mar 11 15:07:17 Vigilico-1 : Preparing local booted disk
Mar 11 15:07:17 Vigilico-1 : Create temporary directory "/private/tmp/mysql-max-4.1.22-apple-darwin8.5.1-i686.pkg.553gujJck"
Mar 11 15:07:17 Vigilico-1 : run preflight script for MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:17 Vigilico-1 : Processing MySQL 4.1.22-max for Mac OS X:
Mar 11 15:07:17 Vigilico-1 : Initialize patching
Mar 11 15:07:17 Vigilico-1 : Determining files to install
Mar 11 15:07:17 Vigilico-1 : Evaluating versions of bundles
Mar 11 15:07:17 Vigilico-1 : Evaluating custom file version checking
Mar 11 15:07:17 Vigilico-1 : Configuring deferred files
Mar 11 15:07:17 Vigilico-1 : Determing obsolete files
Mar 11 15:07:17 Vigilico-1 : Assembling temporary receipt
Mar 11 15:07:17 Vigilico-1 : Performing pre-extraction actions
Mar 11 15:07:17 Vigilico-1 : ==== It took 0.016145 seconds to check for prebinding
Mar 11 15:07:17 Vigilico-1 : Removing obsoleted files
Mar 11 15:07:17 Vigilico-1 : Creating destination path
Mar 11 15:07:17 Vigilico-1 : Extracting files
Mar 11 15:07:21 Vigilico-1 : 1403 files looked up in 0.01 seconds. 1403 files written in 3.81 seconds.
Mar 11 15:07:21 Vigilico-1 : 102818 kilobytes installed.
Mar 11 15:07:21 Vigilico-1 : Performing post-extraction actions
Mar 11 15:07:21 Vigilico-1 : Assembling receipt
Mar 11 15:07:21 Vigilico-1 : run postflight script for MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:21 Vigilico-1 : postflight[561]: chown: mysql: Invalid argument
Mar 11 15:07:21 Vigilico-1 : postflight[561]:
Mar 11 15:07:21 Vigilico-1 : Install failed: The following install step failed: run postflight script for MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:21 Vigilico-1 : Private/Total = (4.6MB, 63.9MB), Heap/Total = (2.1MB, 17.5MB), Regions(malloc, private) = (29, 27)
Mar 11 15:07:21 Vigilico-1 : It took 5.415864 seconds to unsuccessfully install "MySQL 4.1.22-max for Mac OS X" (1 pkg(s))
Mar 11 15:07:21 Vigilico-1 : It took 1.004347 seconds to Configuring volume "Macintosh HD" (dm prepare*disk)
Mar 11 15:07:21 Vigilico-1 : It took 4.368893 seconds to Install MySQL 4.1.22-max for Mac OS X: 22 elements
Mar 11 15:07:21 Vigilico-1 : It took 4.366751 seconds to unsuccessfully Install package MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:21 Vigilico-1 : It took 0.332613 seconds to Build install plan (& redirected paths)
Mar 11 15:07:21 Vigilico-1 : It took 0.027958 seconds to Determing obsolete files
Mar 11 15:07:21 Vigilico-1 : It took 0.064144 seconds to Assembling temporary receipt
Mar 11 15:07:21 Vigilico-1 : It took 0.051404 seconds to Collect path info (ATS, Sec Equiv, Kext, Pref Panes)
Mar 11 15:07:21 Vigilico-1 : It took 3.836044 seconds to Write files
Mar 11 15:07:21 Vigilico-1 : It took 0.050271 seconds to Assembling receipt
Mar 11 15:07:21 Vigilico-1 : Mar 11 15:07:21 Vigilico-1 : Summary Information
Mar 11 15:07:21 Vigilico-1 : Type Elapsed time (sec)
Mar 11 15:07:21 Vigilico-1 : patch 0.000036
Mar 11 15:07:21 Vigilico-1 : script 0.038239
Mar 11 15:07:21 Vigilico-1 : zero 0.004562
Mar 11 15:07:21 Vigilico-1 : extract 3.836044
Mar 11 15:07:21 Vigilico-1 : config 0.416069
Mar 11 15:07:21 Vigilico-1 : receipt 0.114415
Mar 11 15:07:21 Vigilico-1 : disk 1.004357
Mar 11 15:07:21 Vigilico-1 : install 4.368893
Mar 11 15:07:21 Vigilico-1 :


Can anyone shed some light?

[navaho]

Mar 11 15:07:21 Vigilico-1 : run postflight script for MySQL 4.1.22-max for Mac OS X
Mar 11 15:07:21 Vigilico-1 : postflight[561]: chown: mysql: Invalid argument
Mar 11 15:07:21 Vigilico-1 : postflight[561]:


Is this installer running as the right user with the right privileges?

[navaho]

oh, yes, further up I see that it did assume admin privs.

[navaho]

Are you on Leopard? Because that is an invalid argument on Leopard. The user on Leopard is _mysql. Are you using a 10.5 installer on 10.4 or a 10.4 installer on 10.5?

[whatg]

Thanks, Navaho

It is Tiger 10.4.11 if that helps

[whatg]

and I used the i686 installer for 10.4

[whatg]

I managed to fix the error.

For some reason, the install pkg could not add the user mysql to the system (tried both the pkg and manual install).

So I added mysql user in netinfo, and then re-installed mysql.

All works ok.

If anyone can post an update for the reasons for this on 10.4 I'm sure that would help other users with this problem.