MySQL my.cnf file – Found option without preceding group

by

Missing config header

Just add [mysqld] as first line in the /etc/mysql/my.cnf file.

Example

[mysqld]
default-time-zone = "+08:00"

Afterwards, remember to restart your MySQL Service.

sudo mysqld stop
sudo mysqld start

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. Compare two MySQL databases [closed]
  4. MySQL – Trigger for updating same table after insert
  5. How do I get the current time zone of MySQL?
  6. Storing image in database directly or as base64 data?
  7. How to get the difference in years from two different dates?
  8. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  9. MySQL grant all privileges to database except one table
  10. Writing optional parameters within stored procedures in MySQL? [duplicate]
  11. How to get all columns’ names for all the tables in MySQL?
  12. How do I get MySQL to use an INDEX for view query?
  13. mysql stored procedure that calls itself recursively
  14. Restore the mysql database from .frm files
  15. When to use NULL in MySQL tables
  16. Mysql insert random datetime in a given datetime range
  17. How to get number of rows affected, while executing MySQL query from bash?
  18. insert data from one table to another in mysql
  19. MySQL UPDATE syntax with multiple tables using WHERE clause
  20. How does MySQL Auto Increment work?
  21. MySQL load data infile – acceleration?
  22. where does MySQL store database files?
  23. MySQL: How to retrieve a random row or multiple random rows?
  24. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  25. Incorrect key file for table ‘/tmp/#sql_3c51_0.MYI’; try to repair it [duplicate]
  26. group by range in mysql
  27. Display all tables. Describe-like functionality
  28. Escape line breaks in MySQL output
  29. MySQL Relationships
  30. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance

Leave a Comment