sa-mp pblue/mysql r41 no longer working with mysql versions 8x SA:MP 🐧 #support-forum

sa-mp pblue/mysql r41 no longer working with mysql...

lemon-receptionist-48731

01/18/2023, 10:05 AM

The title says it all but I'll say it regardless. I've tried both docker containers and also installing a local mysql. I just keep getting this: MySQL error: Can't initialize character set unknown (path: compiled_in)

billions-easter-89791

01/18/2023, 5:13 PM

the plugin doesn't support the newer character sets and password hashing, so you have to specifically set older versions by passing in flags to the mysql instance

--default-authentication-plugin=mysql_native_password --character-set-server=utf8 --collation-server=utf8_unicode_ci

billions-easter-89791

01/18/2023, 5:14 PM

ideally the plugin is better suited towards MariaDB and not MySQL DB

billions-easter-89791

01/18/2023, 5:14 PM

so if you have the option, switch to using MariaDB

billions-easter-89791

01/19/2023, 6:13 PM

@lemon-receptionist-48731

Copy code

yaml
  db:
    image: mysql:8.0.31
    command: --default-authentication-plugin=mysql_native_password --character-set-server=utf8 --collation-server=utf8_unicode_ci
    restart: always
    environment:
      MYSQL_USER: dev
      MYSQL_PASSWORD: dev
      MYSQL_ROOT_PASSWORD: dev
      MYSQL_DATABASE: dev
    ports:
      - 127.0.0.1:3306:3306
    volumes:
      - ./data/db:/var/lib/mysql

example of what I use in my devcontainer which works fine

flat-egg-44689

01/19/2023, 6:52 PM

Or compile the plugin yourself with the newest connector. Good luck

billions-easter-89791

01/19/2023, 6:55 PM

haha

lemon-receptionist-48731

01/20/2023, 1:46 PM

Thank you!

5 Views