Details: When I start mysql service, I got the following error message:
service mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED]
Answer: When getting this error, you need to check the /var/log/mysqld.log.
sudo more /var/log/mysqld.log
You can find the following error message:
2017-07-14 03:32:18 25768 [ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8' 2017-07-14 03:32:18 25768 [ERROR] Aborting
This is because you should use character-set-server = utf8 instead. Update the my.cnf file as follows:
>sudo vi /etc/my.cnf [mysqld] server-id=2 #default-character-set=utf8 character-set-server=utf8 ... >sudo service mysqld start Starting mysqld: [ OK ]
The problem is then resolved.
MySQL was first introduced in 1995 and then became part of Sun Microsystem after the acquisition in February 2008. With Oracle acquired Sun in January 2010, MySQL database now is part of the Oracle products. MySQL database is known to be the database for the Web. Web applications use MySQL database as the back-end database.
MySQL Latest Release