sa-mp pblue/mysql r41 no longer working with mysql...
# support-forum
l
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)
b
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
ideally the plugin is better suited towards MariaDB and not MySQL DB
so if you have the option, switch to using MariaDB
@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
f
Or compile the plugin yourself with the newest connector. Good luck
b
haha
l
Thank you!
5 Views