Category Archives: Linux Ubuntu

Linux Ubuntu

enable sql_mode=only_full_group_by

root# nano /etc/mysql/my.cnf

 

# The MySQL database server configuration file.
#
# You can copy this to one of:
# – “/etc/mysql/my.cnf” to set global options,
# – “~/.my.cnf” to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with –help to get a list of available options and with
# –print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with ‘.cnf’, otherwise they’ll be ignored.
#
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
# … other stuff will probably be here
sql_mode = “STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION”
group_concat_max_len=2000000

——————————————

root#/etc/init.d/mysql restart

OK work

How To Install MySQL on Ubuntu 20.04

Introduction

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data.

This tutorial will go over how to install MySQL version 8.0 on an Ubuntu 20.04 server. By completing it, you will have a working relational database that you can use to build your next website or application.

Prerequisites

To follow this tutorial, you will need:

Step 1 — Installing MySQL

Continue reading →

Ubuntu How to uninstall or remove bind9 

$ sudo apt-get remove bind9

Uninstall bind9 including dependent package

If you would like to remove bind9 and it’s dependent packages which are no longer needed from Ubuntu,

$ sudo apt-get remove --auto-remove bind9
Use Purging bind9

If you use with purge options to bind9 package all the configuration and dependent packages will be removed.

$ sudo apt-get purge bind9

If you use purge options along with auto remove, will be removed everything regarding the package, It’s really useful when you want to reinstall again.

$ sudo apt-get purge --auto-remove bind9

linux Uninstall/Remove Webmin Software

How do I uninstall or remove Webmin software under Linux / UNIX operating system?

Remove Webmin RPM (RHEL / Centos / Fedora )

If you have installed it via rpm, type the following command to remove the same:
# rpm -ev webmin

Uninstall Webmin Source Installation

Just run the command /etc/webmin/uninstall.sh if you’ve install it from source:
# /etc/webmin/uninstall.sh
Sample Output: Continue reading →

เครื่องมือ Open Source สำหรับ Monitor ระดับเทพ

1. Cacti

Cacti เป็นเครื่องมือสำหรับแสดงผลประสิทธิภาพและแนวโน้มในรูปแบบของกราฟ ซึ่งสามารถใช้ติดตามการใช้งานต่างๆตั้งแต่ Disk Utilization ไปจนถึงความเร็วการหมุนของพัดลมในแหล่งจ่ายไฟ (ถ้าสามารถดูได้ Cacti ก็สามารถติดตามการใช้ได้เช่นกัน)

monitoring_tool_1

2. Nagios

Continue reading →

How to Allow MySQL remote connections in Ubuntu Server 18.04

This tutorial explains how to allow remote connections to the MySQL/MariaDB server on Ubuntu 18.04. The default behavior of the Ubuntu MySQL Server blocks all remote connections. Which prevent us from accessing the database server from the outside.

Note that to allow mysql remote connections we need to edit the MySQL main configuration file. If you are using MariaDB Database server, configuration file going to be “nano /etc/mysql/mysql.conf.d/mysqld.cnf”, If you have installed MySQL Database server configuration file is: “nano /etc/mysql/mysql.conf.d/mysqld.cnf”.

Open the nano /etc/mysql/mysql.conf.d/mysqld.cnf file (or /etc/mysql/mysql.conf.d/mysqld.cnf). Continue reading →