My SQL and Keyboard | Ubuntu

1. Install MY SQL in Ubuntu

    

 

Terminal Code

 

Step 1:

 

 sudo apt update

 

 

Step 2:

 

pass=eastern@labadmin

 

Step 3:

 

sudo apt install mysql-server

 

Step 4:

 

press :y

 

Step 5:

 

mysql --version

 

Step 6:

  

sudo mysql_secure_installation

 

Step 7:

 

press:y

 

Step 8:

 

press:0

 

Step 9:

 

password

 

Step 10:

 

password

 

Step 11:

 

 press:y

 

Step 12:

 

press:y

 

Step 13:

 

press:n

 

Step 14:

 

press:n

 

Step 15:

 

press:y

 

Step 16:

 

clear

 

Step 17:

 

sudo mysql

 

or

 

mysql -u root -p 

 

Step 18:

 

select user authentication_string, plugin from mysql.user;

 

Step 19:

 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'password'; 

 

Step 20:

select user authentication_string, plugin from mysql.user;

 

Step 21:

 

FLUSH PRIVILEGES; 

 

 Step 22:

select user authentication_string, plugin from mysql.user;

 

 Step 23:

exit

Step 24:

clear

Step 25:

 

sudo mysql

 

Step 26:

 

password

 

Step 27:

 

show databases; 

Step 28:

 

Open Ubuntu Software

 

Step 29:

 

Search

 

mysql workbench

Step 30:

Press install button

 

Step 31:

 

eastern@labadmin

 

Step 32:

 

After Install

Close Ubuntu Software

 

Step 33:

 

Go to:-

Show Application > Open My SQL Server

 

Step 34:

 

Click

mysql Connection +

 

Step 35:

 

connection name

 

 LOCAL_MYSQL

 

Step 36:

 

password

> Store in KeyChain

 

password

 

> ok

  

Step 37:

 

> Test Connection 

> OK

 

 

 

 

 

 

 

 

 

 

2. Un Install MY SQL in Ubuntu [# If any Error Occur]

                  

 

Terminal Code

 

Step 1:

 

 sudo apt-get purge mysql*

 

Step 2:

sudo apt-get autoremove

Step3:

 

   sudo apt-get autoclean

  

3. Disable Internal Key Log Time Press in Ubuntu

    

 

Terminal Code

 

step 1:

 

 xev

 

step 2:

 

Wait for 30 second

and

Close the Mini White Screen

 

Step 3:

xmodmap -e 'keycode 20=NoSymbol'

 

Step 4:

 

clear

 

Step 5:

 

exit

 4. Install Spyder Python in Ubuntu

Step 1:

 

sudo apt-get install spyder

 

Step 2:

 

python -m pip install spyder

 

Step 3:

 

 python -m spyder