LifeDev - Liferay Development | Development for Life

MySQL 8.0 lower_case_table_names=1 on Linux Overview This article explains how to change the lower_case_table_names setting for MySQL 8.0 on Linux/Ubuntu. Instructions 1. Install MySQL:  sudo apt-get install mysql-server-8.0 2. Clean the /var/lib/mysql directory: root@lifedev:/var/lib/mysql# rm -Rf * 3. Recreate the /var/lib/mysql directory: sudo mkdir /var/lib/mysql sudo chown mysql:mysql /var/lib/mysql sudo chmod 700 /var/lib/mysql 4. Edit the file: /etc/mysql/mysql.conf.d/mysqld.cnf and add lower_case_table_names=1 to [mysqld] section: 5. Re-initialize MySQL with --lower_case_table_names=1 option: sudo mysqld --defaults-file /etc/mysql/my.cnf --initialize --lower_case_table_names=1 --user=mysql --console 6. Start MySQL: sudo service mysql start 7. Retrieve the new generated password for MySQL user root: sudo grep 'temporary password' /var/log/mysql/error.log 8. Update MySQL root password See how to change MySQL root password here . 8. Verify result: SHOW

  MySQL Change Root Password Overview This article explains how to change the password for the root user of MySQL. Instructions 1. Run MySQL as super-administrator: sudo mysql 2. Change the password to ‘root’ user: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1'; (here ‘1’ is set as a password, you can set any one). 3. Login as root: Enjoy 😏

   SSLHandshakeException Fix for MySQL Connection Problem The following exception is thrown when Liferay tries to connect to MySQL: SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate) Fix Add enabledTLSProtocols=TLSv1.2 parameter to MySQL connection string: jdbc.default.driverClassName = com.mysql.cj.jdbc.Driver jdbc.default.url = jdbc:mysql://localhost:3306/mydb?serverTimezone=Europe/Istanbul&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false& enabledTLSProtocols=TLSv1.2 jdbc.default.username = root jdbc.default.password = root Enjoy 😏