when i try to add users i get the error in the picture
Edit config.php and find the 'dbcollation' line:
$CFG->dboptions = array (
'dbcollation' => 'utf8mb4_bin',
Change the 'dbcollation' to 'utf8_unicode_ci'.
See this reply for more information about this problem and migrating to the recommended settings.
'dbport' => '',
'dbsocket' => '',
'dbcollation' => 'utf8mb4_unicode_ci'
Sorry for the confusion. The 'dbcollation' should still be changed to 'utf8_unicode_ci' because the error indicates the Moodle database character set is utf8.
Collation utf8mb4_unicode_ci should only be used when the database character set utf8mb4.
Please can you direct me to where I can find the config.php to find the dbcollation line so I can make the change?
Do I find this in Moodle or in the cpanel at phpMyAdmin?