+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: MySQL / MariaDB Password Restrictions (/showthread.php?tid=970)
MySQL / MariaDB Password Restrictions - Chewza - 02-03-2015
Hey everyone, I just wanted to congratulate you all on the release of 1.0.0!
I was literally in the process of installing VestaCP and randomly searched what the status of Zpanel was.
I've got nearly a decade of time with cPanel but wanted to see if there was anything out there without all of the bloat and stumbled upon the new release. So far so good!
Anyway, I wanted to ask why when resetting a password in MySQL / MariaDB we're restricted from using special characters? I'd much prefer to have a multi-dimensional password which includes Uppercase, lowercase, numeric, and special characters for my DB passwords.
Any insight on whether this restriction can be lifted, or if it's just something I'll have to live with would be greatly appreciated.
Thanks again! And let me know how I can help contribute!
Environment - Fresh CentOS 7 install on VPS.
RE: MySQL / MariaDB Password Restrictions - Me.B - 02-03-2015
What kind of special characters? $* ?
RE: MySQL / MariaDB Password Restrictions - CRowen - 02-04-2015
(02-03-2015, 06:16 PM)Me.B Wrote: What kind of special characters? $* ?
excuse my intrusion, I think it refers to any character in this case is supported by MariaDB for passwords and sentona can afford to compatibility and software.
Regards.
RE: MySQL / MariaDB Password Restrictions - Me.B - 02-04-2015
Which is?
As we use the same backend for mysql & mariaDB we should currently stick to the common ground to avoid conflicts:
http://dev.mysql.com/doc/refman/5.6/en/validate-password-plugin.html
But we may check this point.
RE: MySQL / MariaDB Password Restrictions - Chewza - 02-04-2015
Sorry for the late response, I was tied up at the office all day.
My initial password I tried included a !, however I got this error message.
"Your MySQL password is not valid. Valid characters are A-Z, a-z, 0-9."
I know for a fact I've used !'s in passwords with cPanel without issue, and pretty sure I've used $'s too.
I can't find any MySQL or MariaDB documentation outlining restrictions on passwords for users, but I may be overlooking some other system incompatibility that is built into Sentora.
Thanks for taking a look!