$ sudo apt update
$ sudo apt install openssh-server
$ sudo systemctl start ssh
$ sudo systemctl status ssh
$ sudo systemctl enable ssh
$ sudo systemctl restart ssh
$ sudo ufw enable
$ sudo ufw allow 22/tcp
Author Archives: administrator
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:
- One Ubuntu 20.04 server with a non-root administrative user and a firewall configured with UFW. To set this up, follow our initial server setup guide for Ubuntu 20.04.
Step 1 — Installing MySQL
phpmyadmin connet MySQL 8.0
- MySQL Commands Login# mysql -u root -p
- Create User # CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘12345678’;
- Add Privileges # GRANT ALL PRIVILEGES ON . TO ‘user’@’localhost’;
- Change Password# ALTER USER ‘user’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘12345678’;
download phpmyadmin https://www.phpmyadmin.net/downloads/
save file config.inc.php in phpmyadmin folder
code :
<?php
/**
* Generated configuration file
* Generated by: phpMyAdmin 5.2.0 setup script
* Date: Tue, 10 Jan 2023 07:41:49 +0000
*/
/* Servers configuration */
$i = 0;
/* Server: 127.0.0.1 [1] */
$i++;
$cfg[‘Servers’][$i][‘verbose’] = ”;
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘user’] = ‘user’;
$cfg[‘Servers’][$i][‘password’] = ‘12345678’;
/* End of servers configuration */
$cfg[‘blowfish_secret’] = ‘VZP.$U_vB#G\\;>q-r]qY=9<&6(\\GB1S1’;
$cfg[‘DefaultLang’] = ‘en’;
$cfg[‘ServerDefault’] = 1;
$cfg[‘UploadDir’] = ”;
$cfg[‘SaveDir’] = ”;
รายชื่อผู้มีสิทธิ์สอบข้อเขียน นักศึกษา ภาคปกติ รอบโควตาพิเศษเรียนดี คณะพยาบาลศาสตร์ เพื่อเข้าศึกษาต่อมหาวิทยาลัยราชภัฏร้อยเอ็ด ประจำปีการศึกษา 2566
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 Unzipping gz File cli
Unzipping gz File
On Linux and macOS, you can decompress a .gz file using the gzip utility. The syntax is as follows:
gzip -d file.gzThe command will restore the compressed file to its original state and remove the .gz file.
To keep the compressed file pass the -k option to the command:
gzip -dk file.gzCode ตัวอย่าง PHP จํากัดตัวอักษรในการแสดงผล ด้วยคำสั่ง mb_strimwidth
ตัวอย่าง PHP จํากัดตัวอักษรในการแสดงผล ด้วย mb_strimwidth
<?php
$string = "PHP จํากัดตัวอักษรในการแสดงผล ด้วย mb_strimwidth";
echo mb_strimwidth( $string, 0, 20, "..." );
?>ผลลัพธ์
PHP จํากัดตัวอักษ...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
