- Log into Cpanel - Click Mysql - Enter the user's name in the Username field and the user's password in the Password field - Click on the add user button - Select back - Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list - Click on the Add user to DB button. The user now has permission to use that database and sample connection strings are shown in the mySQL window.