The message just means the shell for the user is not set. The shell can be specified with the -s argument.

[root@justmetal log]# su - mysql
This account is currently not available.
[root@justmetal log]# su - mysql -s /bin/bash