Mysql: Linux/Mac/Unix/General

Mysql modification code Linux/Mac/Unix/general modification mysql encoding requires the myslq configuration file, which is in/etc/my. cnf, mac users do not have this file by default. You can find any my-*** In the mysql installation directory/support-files -***. copy cnf to/ect! Recently, I modified the default mysql encoding. According to the method found on the internet, adding default-character-set = utf8 under [mysqld] will cause Error 2003! Mysql cannot be started at all. Later, I checked a lot of information and found that the modification should be as follows: add default-character-set = utf8 under [client] And then add the following three lines under [mysqld: default-storage-engine = INNODB character-set-server = utf8 collation-server = utf8_general_ci and restart the service, linux users use the command services mysql restart mac users use/Library/StartupItems/MySQLCOM restart