Re-install error

acupokey wrote on Wednesday, December 02, 2009:

Hello!

I installed 3.1.0 on my Ubuntu OS, liked it a lot, then made some goofs (long story) & decided to “fix” it by removing it, then re-installing. (Not my most shining moment.)

Anyhoo, I try to re-install (from the 1-click method), but the installer tells me that
“MySQL user ‘openemr’ already exists”
and then it aborts the process.

Please tell me what i need to do to delete the old MySQL user, and whatever else needs to be done so that I can successfully re-install.

Thanks, effusively, in advance…………c

sanjeevyadav wrote on Wednesday, December 02, 2009:

Hello,

At first delete “openemr” table in My SQL database then try to re install .

bradymiller wrote on Wednesday, December 02, 2009:

hey,

Remove the openemr package via commandline:

    sudo dpkg -r openemr

Then say yes to warning message and everything will be removed. Then you can re-install.

-brady

acupokey wrote on Wednesday, December 02, 2009:

Hi there:

A lot of this is new to me. Could you please indulge me by giving me directions on how to:

“At first delete “openemr” table in My SQL database then try to re install .”

Thanks!

bradymiller wrote on Wednesday, December 02, 2009:

hi,

I assumed you installed the ubuntu/debian openemr package. Is this correct? If you did, then you can remove it on commandline with following command:

    sudo dpkg -r openemr

-brady

sanjeevyadav wrote on Thursday, December 03, 2009:

hey,

You  can remove it with following command:

    $ sudo dpkg -r openemr

-sanjeev

acupokey wrote on Thursday, December 03, 2009:

Actually, I *did* delete openEMR successfully (using the dpkg-r command returns theresponse that “ignoring request to remove openemr which isn’t installed”

My problem is that now I want to do a fresh install and when I try to do so, I get the error message that
“Mysql user ‘openemr’ already exists.”

So, I would like to know how to delete this user so that I can proceed. (And, no, i don’t know much about mysql)

Thanks in advance…………….chris

bradymiller wrote on Thursday, December 03, 2009:

hey,

To completely remove openemr do following in commandline (not the rootUserPassword is the password of your root mysql use; many times this is blank):

1) Remove mysql openemr database

    sudo mysqladmin -f -u root -password=“rootUserPassword” drop openemr
   

2) Remove mysql openemr user

    sudo mysql -f -u root -password=“rootUserPassword” -e “DELETE FROM mysql.user WHERE User = ‘openemr’;FLUSH PRIVILEGES;”
   

3) Remove mysql openemr web directory

    sudo rm -fr /var/www/openemr

-brady

acupokey wrote on Thursday, December 03, 2009:

THANK YOU!
That worked!

I really appreciate the knowledgeable & quick assistance!

-chris

ideaman911 wrote on Thursday, December 03, 2009:

FYI - Anybody with this same issue in Windows, simply go to Control Panel - Admin - Services and delete the Apache and MySQL services if they are there, and you should be set to go.

Joe Holzer    Idea Man    315-622-9241     im@holzerent.com
http://www.holzerent.com