Results 1 to 3 of 3

Thread: Reset MariaDB to Mysql 5.7 with fresh installation, how?

  1. #1
    Join Date
    Jul 2008
    Location
    Maastricht
    Posts
    4,183

    Reset MariaDB to Mysql 5.7 with fresh installation, how?

    I'm running into the same issues every time with a Centos 7 test server when trying to install a fresh mysql.

    Suppose we have a crashed MariaDB of for some other reason I want to just install Mysql 5.7 again.
    What exactly is the correct procedure?
    I did started with setting mysql 5.6 in options.conf and then:
    Code:
    rm -rf /usr/local/directadmin/custombuild/mysql
    rm -rf /var/lib/mysql
    yum remove MariaDB*
    So Myslq 5.6 get's installed but...
    Giving mysqld a few seconds to start up...
    Looking for 'mysql' as: /usr/bin/mysql
    Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    Error: Failed while fetching Server version! Could be due to unauthorized access.
    FATAL ERROR: Upgrade failed
    /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect
    cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
    Restarting MySQL.
    Installation completed.
    Can't get in with either root or da_admin pass.

    So I first had to do this:
    https://help.directadmin.com/item.php?id=563
    then again go back and do a ./build mysql which offers finally the mysql 5.6 but without da_admin access or user.

    I have to login with the root password, create the da_admin user, give it full rights and go from there install roundcube again etc..

    I can't imagine that is no easier method to just do a fresh mysql 5.x installation with less fuzz then this.
    Anybody the correct and fast and easy procedure (if any)?
    Greetings, Richard.

  2. #2
    Join Date
    May 2008
    Location
    Bulgaria
    Posts
    970
    It seems like something is left from the old system when you are building the new one.

    What I would do in FreeBSD is to go to the mariadb subfolder in the /usr/local/directadmin/custombuild/... and do "make deinstall" inside. That should remove all binaries and libs related to MariaDB. Then remove the user dir (/var/lib/mysql in your case). And there should be no trace of MariaDB in the system that way. I see no reason why mysql installation will fail that way.

  3. #3
    Join Date
    Jul 2008
    Location
    Maastricht
    Posts
    4,183
    and do "make deinstall" inside
    We only have a mysql folder, doesn't matter if having mysql or mariadb installed.
    [code]make deinstall
    make: *** No rule to make target `deinstall'. Stop.[/quote]
    I've seen people doing it without a make deinstall.

    So if anybody know how it's done in Centos...
    Greetings, Richard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •