TIPS & TRICKS BLOG

In this article, I will be discussing how you can create a dialog from service. As we all know that service in android does not have any UI and it is intended for long-running background tasks. But sometimes it is required to show some information to the user when your app is running in the background. Today I will show you how you can implement this type of functionality in your application. Before starting the tutorial let me tell you about the special permission that we are going to use. Permission AndroidManifest.xml<uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW"/> This permission allows the app to use the system level window. AndroidManifest.xml <?xml version="1.0" encoding="utf-8"?><manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.app.dialogfromservice"> <uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW"/> <appl

Today , I will show you how easily we can create a root checker app in android. It only takes 10 minutes to create this kind of application. activity_main.xml <?xml version="1.0" encoding="utf-8"?><androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" tools:context=".MainActivity"> <TextView android:id="@+id/textView2" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginTop="60dp" android:text="This app checks the rooting status of your phone" android:textAlignment="center" android:textSize="18sp&q

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