Install MySQL Server on Ubuntu and Enable Remote Access

 Debian, MySQL, Ubuntu, 資料庫  No Responses »
9 月 202023
  
sudo apt install mysql-server mysql-client

sudo perl -pi.bak -e 's/^bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl restart mysql

sudo mysql

CREATE DATABASE DB_NAME;
CREATE USER 'USER_NAME'@'%' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
GRANT ALL PRIVILEGES ON DB_NAME.* TO 'USER_NAME'@'%';
exit

Install Microsoft Edge on Debian / Ubuntu

 Debian, Linux, Ubuntu  No Responses »
4 月 152023
  
## Setup
curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > microsoft.gpg
sudo install -o root -g root -m 644 microsoft.gpg /usr/share/keyrings/
sudo sh -c 'echo "deb [arch=amd64 signed-by=/usr/share/keyrings/microsoft.gpg] https://packages.microsoft.com/repos/edge stable main" > /etc/apt/sources.list.d/microsoft-edge.list'
sudo rm microsoft.gpg

## Install
sudo apt update
sudo apt install microsoft-edge-stable

How to enable or disable services with Systemd?

 CentOS, Debian, Linux, Ubuntu  No Responses »
8 月 232022
 

Source: How to enable or disable services?

  • sudo systemctl start SERVICE: Use it to start a service. Does not persist after reboot
  • sudo systemctl stop SERVICE: Use it to stop a service. Does not persist after reboot
  • sudo systemctl restart SERVICE: Use it to restart a service
  • sudo systemctl reload SERVICE: If the service supports it, it will reload the config files related to it without interrupting any process that is using the service.
  • systemctl status SERVICE: Shows the status of a service. Tells whether a service is currently running.
  • sudo systemctl enable SERVICE: Turns the service on, on the next reboot or on the next start event. It persists after reboot.
  • sudo systemctl disable SERVICE: Turns the service off on the next reboot or on the next stop event. It persists after reboot.
  • systemctl is-enabled SERVICE: Check if a service is currently configured to start or not on the next reboot.
  • systemctl is-active SERVICE: Check if a service is currently active.
  • systemctl show SERVICE: Show all the information about the service.
  • sudo systemctl mask SERVICE: Completely disable a service by linking it to /dev/null; you cannot start the service manually or enable the service.
  • sudo systemctl unmask SERVICE: Removes the link to /dev/null and restores the ability to enable and or manually start the service.
 Older Entries