hello everyone, this time I want to share a way to replace strings in all files on Linux. Not long ago I had a case to change a word (in string form) which I have to do in all php files in my office project. It must be difficult if Read more…
What is INFORMATION SCHEMA database? INFORMATION_SCHEMA is a database contained in MySQL / MariaDB where it has provided access to the metadata database, all information about the MySQL / MariaDB Server such as database names, tables, columns, data types, access rights and so on are contained therein. INFORMATION_SCHEMA is very Read more…
Hello everyone, I want to share some tips regarding MySQL / MariaDB user privileges settings. If you have read my post about Tips for Creating MySQL / MariaDB Database Users, there I have explained a little about the importance of managing database user privileges. Why is privilege setting important? because Read more…
In this post I will give a few tips to create a good mysql or mariadb database user. For a developer, of course, you need a user to access the database on the server. So, as a SysAdmin, my job is to make user database access for developers. In order Read more…
Hello everyone, I want to share tips in the form of ways to find files that contain certain words on linux. For myself, I sometimes want to edit a file but I forget the location of the file, all I remember is the part of the word I want to Read more…
Hello everyone, I want to share information on how to check the size of data file / folder on linux. Usually a SysAdmin has a schedule to do a clean cleaning on the server he is holding, now to make it easier to clean the server, we must know the Read more…
Hi everyone, this time I want to share information about the rules on CronJob. For some developers, SysAdmin or DevOps may already know what Cronjob is. Cronjob is a software that runs a process or program that has a predetermined execution time. So in this cronjob we can set up Read more…
Hello everyone, For those of you who often do file editing with the Vim editor, and often have to replace word in vim editor, especially in a series of code / configuration / sentences with very long lines, of course it will be difficult if you have to find and Read more…
Hello, in this post I want to share tips for Linux users who often use the VIM editor. the tips are how to copy and paste in vim editor. There are 2 ways that I give: The first, using the keyboard buttons CTRL+SHIFT+C and CTRL+SHIFT+V . The trick, when we Read more…