B
B
BonBon Slick2018-06-05 13:25:15
MySQL
BonBon Slick, 2018-06-05 13:25:15

Why does it say Mysql is MariaDB?

I need to use Mysql specifically in the project because MariaDB gives errors:

Migration 20160704155442 failed during Execution. Error An exception occurred while executing 'ALTER TABLE user RENAME INDEX fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734':

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734' at line 1

In AbstractMySQLDriver.php line 98:
                                                                                                                                                                                                         
  An exception occurred while executing 'ALTER TABLE user RENAME INDEX fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734':                                                                                     
                                                                                                                                                                                                         
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDE  
  X fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734' at line 1                                                                                                                                               
                                                                                                                                                                                                         

In PDOConnection.php line 109:
                                                                                                                                                                                                         
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDE  
  X fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734' at line 1                                                                                                                                               
                                                                                                                                                                                                         

In PDOConnection.php line 107:
                                                                                                                                                                                                         
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDE  
  X fk_8d93d6492b19a734 TO IDX_8D93D6492B19A734' at line 1

When you try to install Mysql, it says that it's already installed, connect? MariaDB again.
How can I install Mysql and use MariaDB instead?

Debian 9

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AVKor, 2018-06-05
@BonBonSlick

apt purge mariadb-server
apt install mysql-server

S
Sanovskiy, 2018-06-05
@Sanovskiy

There is a suspicion that the problem is not in Mary, but in the code.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question