How to reset MySQL / phpmyadmin root password on Ubuntu 18.04 Linux

1. The simplest approach to reset MySQL database root password is to execute mysql_secure_installation program and when prompted entering your new root MySQL password:

sudo mysql_secure_installation

New password:
Re-enter new password:

2. Let's stop the currently running MySQL database:

sudo service mysql stop

3. create a /var/run/mysqld directory to be used by MySQL process to store and access socket file:

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld 

4. Start manually MySQL with the following linux commands :

sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

5. Confirm that the process is running as expected: 

jobs

6. Access MySQL database without password 

mysql -u root

7. First flush privileges MySQL session

mysql> FLUSH PRIVILEGES;

8. The following commands will reset MySQL root password to "root" 

mysql> USE mysql;
mysql> UPDATE user SET authentication_string=PASSWORD("root") WHERE User='root';
mysql> UPDATE user SET plugin="mysql_native_password" WHERE User='root';

9. Exit MySQL session: 

mysql> exit

10. Terminate current mysqld process 

sudo pkill mysqld

11. Start MYSQL database:

sudo service mysql start

12. If all went well you should now be able to login to your MySQL database with a root password: 

mysql -u root --password=root
mysql> exit

How to Find / Search a file using CMD / Terminal Command Linux Ubuntu

1. Find file from computer using CMD / Terminal Command

sudo find / -name index.php

2. Find file from Specific Directory using CMD / Terminal Command

sudo find /var/www/html/ -name index.php

File Directly Open in NetBeans in Ubuntu / Linux using terminal

 File Directly Open in NetBeans in Ubuntu / Linux using terminal

1. Open terminal and login with sudo su
2. Edit file using nano in terminal (Use following command)

sudo nano /usr/share/applications/netbeans-8.1.desktop 

3. Change

Exec=/bin/sh "/usr/local/netbeans-8.1/bin/netbeans"
to
Exec=/bin/sh "/usr/local/netbeans-8.1/bin/netbeans" %U

Terminal=0
to
Terminal=false

4. Press CTRL+X , than Y and Enter
5. That't IT, Now you can see NetBeans in open with application

Ref by. Nirav Patel

In PHP, Not send email in AWS amazon ubuntu linux server

sudo apt-get install sendmail

How to import database using ubuntu terminal or windwos CMD

For linux ubunto

pv /var/www/html/decorati_main.sql.gz | gunzip | mysql -u root -p root

apt-get install pv
pv /var/www/html/decorati_main.sql.gz | gunzip | mysql -u root -p  decorativeplumb

For Windows

mysql -uroot -ppassword mydb > myfile.sql.gz