Big problem with reinstalling mysql

Discussion in 'Linux VPS/Dedicated - General' started by cassie03, Apr 17, 2014.

  1. cassie03

    cassie03 New Member

    At first the only problem was mySQL password.

    Errors say:

    Enter current password for root (enter for none):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Enter current password for root (enter for none):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    Enter current password for root (enter for none):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Enter current password for root (enter for none):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Enter current password for root (enter for none):
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    --
    root@host [~]# sudo pacman -Rn mysql
    sudo: pacman: command not found
    root@host [~]# yum install pacman
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * base: mirrors.loosefoot.com
    * extras: mirrors.loosefoot.com
    * updates: mirrors.loosefoot.com
    Setting up Install Process
    No package pacman available.
    Error: Nothing to do

    We tried to check for a solution online and followed this one: https://bbs.archlinux.org/viewtopic.php?id=51981. However, another problem arise. Following that guide made all databases removed. Websites under it caused error in establishing connection in database.

    So the next thing we thought to do is to remove mysql and reinstall it. However the error says:

    Removing:
    MySQL55-server x86_64 5.5.36-1.cp1136 installed 66 M

    Transaction Summary
    =============================================================================================
    Remove 1 Package(s)

    Installed size: 66 M
    Is this ok [y/N]: y
    Downloading Packages:
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Error in PREUN scriptlet in rpm package MySQL55-server
    MySQL55-server-5.5.36-1.cp1136.x86_64 was supposed to be removed but is not!
    Verifying : MySQL55-server-5.5.36-1.cp1136.x86_64 1/1

    Failed:
    MySQL55-server.x86_64 0:5.5.36-1.cp1136

    ---

    So we used this guide http://www.linux-pages.com/2012/08/...t-file-was-supposed-to-be-removed-but-is-not/ and used this: yum --setopt=tsflags=noscripts remove MySQL55-server.x86_64. This did remove mysql successfully.

    However, the problem now is that we can't reinstall mysql. The error now says:

    root@host [~]# yum install mysql mysql-devel mysql-server
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * base: mirrors.loosefoot.com
    * extras: mirrors.loosefoot.com
    * updates: mirrors.loosefoot.com
    Setting up Install Process
    No package mysql available.
    No package mysql-devel available.
    No package mysql-server available.
    Error: Nothing to do

    Please help.
     
  2. KH-Jonathan

    KH-Jonathan Director of Managed Services Staff Member

    Manually removing and reinstalling MySQL like this on a cpanel system is a bad idea. I'd definitely recommend letting us take over in the ticket and get things back running for you.

    We're actively replying to all tickets and while we're a tad busier than usual, no responses are currently delayed at all.
     
  3. cassie03

    cassie03 New Member

    Thank you Jonathan. I think we did it via shell. A friend was the one behind this all though.
     
  4. Dan

    Dan Moderator

    Ouch...

    cassie03 if you haven't submitted a ticket yet then you certainly should, it might take some doing but I am sure they will fix you up :)
     
  5. KH-DanielP

    KH-DanielP KH-COO Staff Member

    Yeup, we're working on him now. It's a bit of a mess but we will get it sorted.
     

Share This Page