VIKHOST Tech Blog
Useful Technical Articles, Notes and Instructions.
How to Find the Largest Files in Linux

How to Find the Largest Files in Linux

How to Find the Largest Files in Linux — The search for large files is especially relevant when the disk runs out of space and you have to look for files to delete. The best way to find all the largest files on a Linux server is to use the command line. You can easily get a list of the largest files using a combination of several simple commands. How to Find the Largest Files in Linux: Sometimes you can search for large files, especially large log files that can quickly fill your server, with the following command you can ...
Read more
MySQL - Create new user | VIKHOST

MySQL Server-Create New User and Grant Permissions

Create New User and Grant Permissions to MySQL database server In this article, we will explain how to create a new user in MySQL, and grant permissions to that user in MySQL. Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. 1. Log in to MySQL To log in to MySQL system uses the following command: mysql -u root –p By executing this command we tell the MySQL client to log us in with the root user and to prompt us for the user’s password. 2. Creating a new ...
Read more
MySQL - Enable Remote Access | VIKHOST

MySQL Server-Enable Remote Access

Enable remote access to MySQL database server If you try to connect to server mysql from remote server, you will get an error. Initially, mysql uses the standard localhost connection (127.0.0.1). It needs to be fixed this in the configuration file my.cnf (usually in Linux the file is located /etc/mysql/my.cnf) In my.cnf we need to find line: bind-address = 127.0.0.1 It needs to be changed to: bind-address = 0.0.0.0 Now after service mysql restart we can connect to mysql from any IP (if the user is created). At the same time, for the root user, remote access remains under the ...
Read more