In MySQL, how do you allow another user to create other users? In turn, those users should only be able to view some tables.
From MySQL's privileges documentation, the
CREATE USER privilege is the one you want:
GRANT CREATE USER ON *.* TO 'username'@'host'
For other privileges, read MySQL's
Note, I've linked to MySQL 5.0 documentation.
GRANT hasn't changed much over the years, so any newer versions should also use the same syntax.