MySQL User Creation Error:
#1805 – Column count of mysql.user is wrong. Expected 43, found 42. The table is probably corrupted
Cause:
The data structure was not upgraded using mysql_upgrade after updating MySQL.
Solution:
find / -name "mysql_upgrade" # Find the directory where mysql_upgrade is located
/usr/local/mysql/bin/mysql_upgrade -uroot -p 123456 # This uses the location of my mysql_upgrade as an example; change the password to your own