Install phpmyadmin

$    sudo apt install phpmyadmin

$    mysql -u root -p

mysql> show databases;

mysql> create database database1;     "write any name instead of database1"

mysql> select user,host,plugin from mysql.user;

mysql> create user 'xxxx'@'localhost' identified by '*******(passwordkey)'

if you forgot to put password then use

ALTER USER xxx@localhost identified by '****';

mysql> grant all privileges on *.* to 'xxxx'@'localhost';

mysql> update user set plugin="auth_socket" where User='xxxx';

mysql> flush privileges;

mysql>exit

Install Microsoft fonts on Linuxmint, Ubuntu

 When ever you use windows releated product on linuxmint it ask for Microsoft fonts. Like when you use Microsoft office, Adobe Photoshop, Page maker etc. It prompts that microsoft font is not installed on system. On some cases Without installation of These fonts software does not function properly.

To rectify this error it follows fews steps which are very easy.

just open the terminal by pressing Ctrl+Alt+T or open it how you wish, Type following Commands

$    sudo apt update

$    sudo apt install ttf-mscorefonts-installer

then press <Yes>

Snapd not installing

 When ever you have to install snap or snapd then sometime linuxmint doesnot give proper support. This is not any big issue. If you are facing the same problem like this.

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package snapd is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
E: Package 'snapd' has no installation candidate

Then you need to follow following steps:

1. sudo rm /etc/apt/preferences.d/nosnap.pref

2. sudo apt update

3. sudo apt install -y snapd

4. snap version

Now You are ready to use snap.

Kernel Panic !

Linux mint is the Best choice among all the Linux distro and Personally i prefer everyone to use it. The User Interface of Linux mint is much similar to Windows 7 and it is highly can be customize as per our preference. It is based on Debian and much advanced than Ubuntu. I am using Linux mint from last 6
year and i had tried almost every possible tweaks on it. If your Laptop contain the best support then you can change its Desktop Environment to Plasma to get best of the best experiences. But sometime using Linux mint shows a small problem while shutting down.  If you check the log then you will find something Kernel panic. I am not pretty sure why it appears but with my research on this topic i found the best solution for this. Some time It is solved with one Technique and sometime it doesn't.  On the Forum of Ubuntu you will fine there a slight modification on GRUB and update but on my case i tried it. Actually when i use my laptop full day then it shows the freezing problem during shutdown. If you ever faced this problem then you can try the following step. 

First of all open the terminal (Ctrl+Alt+T) and Type;

$ sudo nano /etc/default/grub

When you will type this command then,

# If you change this file, run 'update-grub' afterwards to update
# /boot/grub/grub.cfg.
# For full documentation of the options in this file, see:
#   info -f grub -n 'Simple configuration'

GRUB_DEFAULT=0
GRUB_TIMEOUT=0
GRUB_DISTRIBUTOR=`lsb_release -i -s 2> /dev/null || echo Debian`

GRUB_CMDLINE_LINUX_DEFAULT="quiet splash" <----(HINT: It's this one!)

GRUB_CMDLINE_LINUX=""

# Uncomment to enable BadRAM filtering, modify to suit your needs
# This works with Linux (no patch required) and with any kernel that obtains
# the memory map information from GRUB (GNU Mach, kernel of FreeBSD ...)
#GRUB_BADRAM="0x01234567,0xfefefefe,0x89abcdef,0xefefefef"

# Uncomment to disable graphical terminal (grub-pc only)
#GRUB_TERMINAL=console

# The resolution used on graphical terminal
# note that you can use only modes which your graphic card supports via VBE
# you can see them in real GRUB with the command `vbeinfo'
#GRUB_GFXMODE=640x480

# Uncomment if you don't want GRUB to pass "root=UUID=xxx" parameter to Linux

#GRUB_DISABLE_LINUX_UUID=true

# Uncomment to disable generation of recovery mode menu entries
#GRUB_DISABLE_RECOVERY="true"

# Uncomment to get a beep at grub start
#GRUB_INIT_TUNE="480 440 1"

You will be getting this Screen and You need to add the line ="quiet splash" Manually.

as you do it. Just update the GRUB typing the command

$ sudo update-grub

Next

After that you need to make a slight change on another place for that you type following command.

$ sudo nano /etc/systemd/system.conf.d/50_linuxmint.conf

then you will find 

# To override these values, create your own file in /etc/systemd/systemd.conf.d>

# Reload configuration with "sudo systemctl daemon-reload"

# Test with "systemctl show"

[Manager]

# Reduce shutdown timeout from 90s to 10s.

# If you rely on important tasks to successfully finish during the shutdown seq>

DefaultTimeoutStopSec=100s   <-- By default it will be 10s

# Rationale:

# This is done for the following reasons:

# - 90s is too long for users to wait (they think it's hanging indefinitely, an>

# - Cups, minidlna have made this a buggy mess for years now and there's no sig>

# - This is a workaround many people have used in Mint, Ubuntu, Arch, Fedora an>

# timeout is known to possibly affect the journal, no adverse effects were repo>

# - For our audience (desktop users), this makes a lot of sense. It would be di>

# scripts to perform important tasks, but for most people this fixes a very imp>

You can see the DefaultTimeoutStopSec=10s and you need to change it to 100s.

and save it pressing Ctrl+X and press enter. You will get your Problem solved

Install Linux!

May be you already heard much more about Linux and probably if you hadn't used it before then do not misunderstood it as a command line interface only or something boring shit. Let me tell you something about Linux. Linux is actually a kernel.  People misunderstood it as a Operating System itself. Rather than that it lets understand it in such way, Kernel is the essential core of an operating System which create the bridge relation between the applications and the hardware. The operating System which are working on the Linux kernel are called Linux operating system. Alike Linux, other operating system do have their own Kernel. i.e  Windows have it's own kernel.

Using Linux is really cool on itself. Simply it's a switching process into the freedom. Linux Operating system is an opensource OS. Opensource Software are those types of software which provide free of cost software and Its License provide us the modification permission on our favor. Let me tell you some interesting reason why we need to switch to Linux.

• Linux is Opensource.
• Linux software are free and advanced, It bear the potential to work efficiently as a commercial software.
• Linux is a freedom; Financial freedom, Technically freedom and You can modify it as your flavor. 
• Linux is universal and It is Most secure OS regarding the Windows. 
• Several Penetration Testing is done with the help of Linux and The best part of it is Computer virus do not affect it. It doesn't required the Antivirus
• Most of all popular website like Google, amazon etc are using the Linux for their Server. Mostly Servers are handled by Linux Os.  

Lets have a overview on How to switch on Linux. First you decide which disto of Linux you want to install on your PC. You can click the DOWNLOAD link here.

If you are not pretty sure on the choice you can move to Linux mint. Linux mint is one of the best experience on the Linux. It's GUI is much more similar to the windows but customization of its is far more than Windows. You can follow the following step to install the Linux mint.

1. Download the .ISO file from any website which you would like to install.
2. Make a pen drive ready and format it. 
3. Download any tool like RUFUS or POWERISO to make pendrive bootable.
4. Once the tool is ready just make the Pendrive bootable and boot it from Laptop recovery and install the Linux. 
5. Calculation of Partition.
   Suppose if Your PC have the storage of 1TB then you can partition it as follows
   
   SWAP memory: RAM SIZE *2
   (if your PC have 4 GB RAM then 4*2=8GB i.e 8000MB)
   
   ROOT / : 50 GB
   (50GB~ 50000MB)
   
   BOOT/ : 2 GB
   
   EFI : 1GB
   (1GB~1000MB)
   
   /home: 600 GB
   (It depends on you how much you want to set for c: in Windows. i.e 600000MB)
   
   Rest you can Format for Your Storage Partition as D:/
   On this Table Starting from LHS;
   
   
   
   
   

Partition 1: Swap Memory

Partition 2:  /Boot

Partition 3: /home

Partition 4: /tmp (optional)

Partition 5: /efi
Partition 6: / (root)

Partional 7 & 8: Local disks storage Partition

This configuration is best for me. Generally Partition can be done as per our requirement but this calculation i had found with several recommendation. Till now i had already tasted most of all flavor of Linux and for this purpose i had my backup on Local disk and rest were destroyed on C:, As a conclusion i got LINUX MINT as the best among the best. 

You can try it own and if you faced any problem then let me know. Since my Chat is on your right corner feel free to talk. Happy Learning.