×
Night mode
Sign up
Login
Results: 1578
Notes
  • Newest first
  • Oldest first
  • Newest first(All)
  • Oldest first(All)
edit file
Opens 
.env
file with edit mode using command line interface
sudo nano .env
We can specify the file with full address
sudo nano /var/www/csmp.ge/.env
by Valeri Tandilashvili
4 years ago
0
Linux
0
delete file
Deletes specified file
sudo unlink /etc/nginx/sites-enabled/csmp.use.ge
by Valeri Tandilashvili
4 years ago
0
Linux
0
copy file
Duplicates 
.env.example
file, names it 
.env
and places it in the same directory 
sudo cp .env.example .env
by Valeri Tandilashvili
4 years ago
0
Linux
0
clone remote repository
After installing 
Git
on the server, we can clone remote repository
sudo git clone https://tandilashvili@bitbucket.org/tandilashvili/csmp.git
The command clones the remote repository of 
csmp
project
by Valeri Tandilashvili
4 years ago
0
Linux
0
reload nginx
Reloads 
nginx
server to apply changes
sudo systemctl reload nginx
by Valeri Tandilashvili
4 years ago
0
Linux
0
run queries
We can run queries (that are inside 
queries
file) from Linux command line
mysql -u test_user -p test_db < /var/www/queries.sql
The queries inside the file will be run into 
test_db
using 
test_user
user. Note: The above command can be used to restore database, or add some tables, or insert some rows.
by Valeri Tandilashvili
4 years ago
0
Linux
MySQL
Command line
0
MySQL system users
Shows system users
SELECT user, authentication_string, plugin, host FROM mysql.user;
by Valeri Tandilashvili
4 years ago
0
MySQL
1
change password for MySQL root user
Changes password for MySQL 
root
user to 
some password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'some password';
by Valeri Tandilashvili
4 years ago
0
Linux
MySQL
0
set password for MySQL root user
We run the command after installing 
mysql-server
to set password for the 
root
user
sudo mysql_secure_installation
After the command is executed, we enter the password for the MySQL root user
by Valeri Tandilashvili
4 years ago
0
Linux
MySQL
0
ufw allow 'Nginx HTTP'
Allows HTTP for Nginx server
sudo ufw allow 'Nginx HTTP'
by Valeri Tandilashvili
4 years ago
0
Linux
0
Results: 1578