Ok, using Navicat I'm still running into a problem. I created a new user using the example above. However, when I try to edit the user under that Advanced Tab I can't change the "Max User Connections" to 1. I keep getting the following error: "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 'USER 'mycreatedname' @ 'localhost' WITH MAX_USER_CONNECTIONS 1' at line 1"
Rick
|