Can someone help me fix this issue?

[TreeFN]

I am getting a problem using permissionsEx with mysql, I am sure my login details are correct...

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) ~[spigot.jar:git-Spigot-d21162c-82f3b02]
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779) ~[spigot.jar:git-Spigot-d21162c-82f3b02]

The Configuration File

multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: false
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  backend: sql
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backends:
    sql:
      uri: mysql://localhost/perms
      user: root
      pass: *censored*
updater: true
alwaysUpdate: false

 

[UElitez]

Can you paste your PermissionsEx config.yml file via https://pastebin.com please?

 

[TreeFN]

Can you paste your PermissionsEx config.yml file via https://pastebin.com please?

Added it to the thread

 

[1337]

Seems the password for root is incorrect or MySQL isn't setup to allow for connections outside of its container.

 

[Fawks]

Seems the password for root is incorrect or MySQL isn't setup to allow for connections outside of its container.

If he was using a password it would say access denied using password YES not NO

Are you sure you're using a password in your config and put it through a parser?

 

[1337]

Sorry about that, didn't read into it as much as I should've. It seems that you aren't supplying a password whatsoever, could you make sure that that field is indeed filled and the regex matches what's required? (run it through a JSON parser or something similar, for example)

 

[TreeFN]

Sorry about that, didn't read into it as much as I should've. It seems that you aren't supplying a password whatsoever, could you make sure that that field is indeed filled and the regex matches what's required? (run it through a JSON parser or something similar, for example)

The YAML is perfectly fine or else the plugin would had likely rejected the file when it was enabled.

http://yaml-online-parser.appspot.com/
You can see for yourself using this website, remove the asterisk from "*censored*" as asterisk aren't actually in the password.[DOUBLEPOST=1514684255][/DOUBLEPOST]

If he was using a password it would say access denied using password YES not NO

Are you sure you're using a password in your config and put it through a parser?

Yes. I just followed the instructions on the pex configuration wiki for a mysql setup.[DOUBLEPOST=1514684745][/DOUBLEPOST]Anyone else can help me fix this issue?

 

[UElitez]

In your config you have the line for the password beginning with "pass:". It should be "password:".

 

[sergivb01]

permissions:
    backend: sql
    backends:
        sql:
            uri: mysql://localhost/databasename
            user: username
            password: password

https://github.com/PEXPlugins/PermissionsEx/wiki/Plugin-Configuration[DOUBLEPOST=1514686982][/DOUBLEPOST]
It's password not pass.