TIPS & TRICKS BLOG

Today, In this article we are going to learn how to “ Reset MySQL Root Password “. It is a good option to use this method only for resetting the password but it is highly insecure. So make sure after resetting the password, you also revert the changes from my.cnf file. Note: For Centos and Fedora Based OS sudo service mysqld stop sudo service mysqld start For Debian and Ubuntu OS sudo service mysql stop sudo service mysql start Steps Here i am using amazon linux 2 OS (based on centos) Stop mysql service – sudo service mysqld stop Open /etc/my.cnf file – sudo nano /etc/my.cnf Add skip-grant-tables under [mysqld] section Start MySql Service – sudo service mysqld start Open terminal and type mysql and type following query and press enter UPDATE mysql.user SET authentication_string=PASSWORD(‘Your new password’) WHERE User=’root’; Then write FLUSH PRIVILEGES; and press enter Now type – exit; Stop mysql service again – sudo service mysqld stop Open my.cnf file – sudo nano /etc/my.cnf

Today in this article “ Restore MySQL Database Without SQL Dump ” we will discuss how you can restore your database when you don’t have SQL dump file. This happens when your MYSQL gets corrupted. In that case, if you want to make a back up of your database you can simply copy following files and then restore them after a fresh installation Let’s Start Generally MySQL gets installed on following location /var/lib/mysql On this location it create folders of your databases. For instance, if you have databases like test, test1, test2 Then on this location /var/lib/mysql – You will have three folders test, test1, test2. And each of these folders will contain database files for the MyISAM database. It will have three main files with the following extensions frm myi myd And another three files which will be inside in /var/lib/mysql. These files are for INNO DB database. ibdata1 ib_logfile0 ib_logfile1 Steps: Stop Mysql Service using – sudo service mysqld stop Copy folder to /var/lib/mysql

Hi GuyZ, Today, I am going to show you , how to play PS3 Games on PC using RPCS3 Emulator. It is very easy to setup and play PS3 Games. I got to know about this emulator some time ago and i thought i should give it a try . Initially i was not sure that whether it would work or not. But at last it worked. I found it very to easy to setup and play  PS3 games . Although this emulator is still in development stage so you may encounter with some errors. I haven’t got any errors. In this tutorial, I am using PS3 PKG file. This emulator also supports dumping ps3 disc and ISO Images. Prerequisites: RPCS3 Emulator PS3 Update File Microsoft Visual C++ 2019 Redistributable PS3 .pkg and Rap File Important Tip Before downloading any game make sure it comes under the playable section of rpcs3 compatibility. To check which game you can play using RPCS3  click HERE . Games which are showing in Playable Section are actually the games which are in running state and can be playe

1. version –   Version is the first attribute which your specify in your docker compose file. At the time of writing this post the latest version was 3.7 and which was introduced with docker engine  18.06.0+ version. If you will not specify the version you will probably get the error when you will try to run docker-compose up.   Example – version: ‘3.7’ 2. services  – This is the second attribute which we specify after version in our docker-compose.yaml file. It is also a mandatory attribute otherwise you will encounter an error. Under services attribute we specify our docker containers . You can specify any no. of docker containers inside this.  3. Service Name  – As we discussed under services attribute we specify our services name. For example myql: followed by colon(mandatory). Then inside our service we further add our different service attributes like container_name, networks, depends_on, volumes etc.  Example1 – mysql: Example 2 – spring: Example 3 – tomcat: 4. container

Recently one of my friend came to me with a problem. He is looking out for new job but he feels quite boring to update  his profile on daily basis. As some people says updating profile in the morning gives you more calls as it keeps the newly updated profile on top (Although i don’t know whether naukri works this way or not 😀 ). As i was more interested to solve his problem.  After listening his problem i came to solution that instead of updating it manually lets make this job automatic. And it is quite interesting how we can automate our daily boring task with automation. Another day i came with the solution . And the solution was to make it automatic using selenium (Those who are not aware about selenium do check this link) In short, Selenium is a Testing automation Framework. And it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should) also be automated as well. Then i started figu

Hello Guys, In this tutorial, I will discuss the color map in OpenCV. Color Map is used to show different color temperatures. And this can also be used to generate some cool image filters.  OpenCV comes with thirteen built-in color maps. So in this tutorial, I will show you how to use color maps.  Let’s get started List of Color Maps COLORMAP_AUTUMN COLORMAP_BONE COLORMAP_JET COLORMAP_WINTER COLORMAP_RAINBOW COLORMAP_OCEAN COLORMAP_SUMMER COLORMAP_SPRING COLORMAP_COOL COLORMAP_HSV COLORMAP_PINK COLORMAP_HOT COLORMAP_PARULA To apply color map first we need to convert an image to grayscale. So I will use  img = cv.imread("nature.jpg",cv.IMREAD_GRAYSCALE) If you are not aware of this function then please check my previous tutorial  http://techievaibhav.in/2019/01/10/reading-an-image-using-opencv/ To apply color maps, OpenCV comes with a function called applyColorMap() . This function takes two parameters. Gray Scale image Color Map Autumn Bone Cool Hot HSV Jet Ocean Parula Pink

In this tutorial, I will show you how to draw a circle in OpenCV. OpenCV comes with lots of built-in functions that make our life easier especially when we are working on image processing .  And there is a function called circle in OpenCV which is used to draw a circle. This function takes following parameters: 1. Image : Takes an image object 2. Center : Center point coordinates 3. Radius : Radius of the circle 4. Color : Takes color in BGR format 5. Thickness : By default set to 1 (optional) 6. Line Type : By default set to 8-connected.It can also be  LINE_AA  or  4-connected  (Optional) 7. Shift:  Shifts fractional bits in the point coordinates of center and radius (Optional) Especially when we are creating closed shapes. Thickness plays an important role. Here if the negative thickness is passed in this function or any other function which creates a closed shape(rectangle, polygon, etc). Then it creates a filled shape (filled with color). Negative Thickness Filled Circle Positive