I have never set up SQL on my server been working on this for over a week and not luck. I know mysql is running on my server. I can log into mysql using root so user and password not an issue. Just can't find the problem. this is my log error. Also would like correct steps in getting this to work,like if I have to create the database before I run plugin, or does plugin create it ?

http://pastebin.com/EQeR8TrP

Permissions.yml

http://pastebin.com/aM7ptTAe

found issue it was something to do with mysql after clean install of mysql works now. I now need to know how to share the same database with multi servers since I can't seem to get the second one to load the perms, but it connected to the SQL database

Steps I have figured out, Still not working;

MYSQL -u root -p
123Password
CREATE DATABASE PEX;
GRANT ALL ON PEX.* to 'root'@'localhost' identified by 'password123';
FLUSH PRIVILEGES;

multiserver:
use-netevents: true
permissions:
debug: ture
allowOps: false
user-add-groups-last: false
log-players: false
createUserRecords: false
backend: sql
informplayers:
changes: false
basedir: plugins/PermissionsEx
backends:
backend: sql
backends:
sql:
type: sql
uri: mysql://localhost/PEX
user: root
password: password123
updater: true
alwaysUpdate: false