CODEWITHSUNDEEP
mysqlmariadb
Akhil Surapuram
Akhil Surapuram

Reputation: 682

Using MariaDB and mysql 5.7 at same time

I was using MySQL server 5.7 and for another project, I needed to install MariaDB. I have followed official instructions Mariadb official download page

after the install MySQL login in showing me following output

Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 46 Server version: 10.4.6-MariaDB-1:10.4.6+maria~bionic mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit

how do I make both servers running up? maybe by different ports/ any identifier.

Upvotes: 0

Views: 1207

Answers (1)

Rick James
Rick James

Reputation: 142540

Plan A:

  • Be sure they are in separate directories.
  • Be sure to have separate my.cnf config files.
  • Use different port numbers. (Perhaps leave the existing one as 3306, then pick a bigger number for the second install.)

Plan B:

Put the second install in a VM. There are still details to iron out of "hostname" and port. Possibly the hostname of the VM cannot be "localhost", thereby forcing use of TCP/IP.

Upvotes: 1

Related Questions