Tag: mysql

How to find my.cnf MySQL configuration file in Linux?

After installing MySQL and in order to provide configuration to it, we usually want to locate the famous my.cnf configuration file; if you are running a GNU/Linux distribution like Ubuntu, then you can use the following command to know where is the absolute path of this file: find / -name my.cnf The output of this […]

Read More

How to get MySQL time zone?

Under certain circumstances it is relevant to know the timezone in which your date is being stored in a Relational Database System, for example MySQL. One of the easiest ways to know is just by running following command: Step 1. Login to MySQL mysql -u root -p Step 2. Run a “select” query to get […]

Read More