Dev {Tricks}

You are here: Home / Archives for ubuntu

by

Import export database | Linux

Import database

mysql -u DB_USERNAME -p DB_NAME < /PATH/OF/DB/softsql.sql

Export database

mysqldump -u DB_USERNAME -p DB_NAME > /PATH/TO/DB/softsql.sql

Dump error

  • Error Access denied need PROCESS privilege [MySQL]
  • mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

Solusion

Add ‘–no-tablespaces‘ option to the command as shown below:

mysqldump -u DB_USERNAME -p DB_NAME --no-tablespaces > /PATH/TO/DB/softsql.sql

 

by

Xauthority does not exist

  • /usr/bin/xauth: file /root/.Xauthority does not exist

Solution

Go into the sshd_config file

vi /etc/ssh/sshd_config

Search and remove the # sign at the beginning of the 3 lines

X11Forwarding yes
X11DisplayOffset 10
X11UseLocalhost yes

Then restart sshd

systemctl restart sshd

Exit and login again. You will not get the error.

 

Or

Create n new file: touch ~/.Xauthority

Log out and login in again.

by

How to change the root password

  • Resetting the Root Password
  • How to Change a Password in Linux
  • How to Reset or Change the Root Password in Linux
  • How to change root password in Ubuntu Linux
  • How to Reset the root Password

1. Login to your server using existing root password.

2. After login you can change the root password with below command.

passwd root

That’s aLL!

by

How to change the SSH port 22

How to change the SSH port

  • Log in to your server using the current SSH port (default 22).
    Note that you should not close this SSH connection until you have verified that you can access SSH on the new port number.
  • Open / etc/ssh/sshd_config
vi /etc/ssh/sshd_config
  • Set your Port. For example 1234
Port 1234
  • Restart SSHD
/scripts/restartsrv_sshd

or

sudo systemctl restart ssh.service
  • Configure any firewalls with the new SSH port.
  • Test SSH with new port 1234
ssh USER@HOSTNAME -p1234

Use your USER and HOSTNAME and the password and confirm new port.

If the SSH test on the new port is successful you can close the connection. If it is not successful, this SSH connection should not be closed until the SSH test on the new port is successful. Else revert the port to previous state and restart.

find / -name “sshd_config” -print

/usr/share/openssh/sshd_config
/etc/ssh/sshd_config

find / -name “sshd_config” 2>/dev/null

vi /usr/share/openssh/sshd_config

vi /etc/nftables.conf

ufw allow 1234/tcp

vi /etc/services

systemctl restart ssh

service ssh restart

systemctl restart ssh.service

ssh root@server_ip -p NEW_PORT
ssh root@123.512.11.6 -p 1234