Perform Database Task Using SQLYog On Ubuntu

Perform Database Task Using SQLYog On Ubuntu

Today I’m gonna teach you, how to perform database tasks using SQLYog. We can perform database tasks using SQLYog. You can change user and create as well as a check table data and copy in SQLYog.

Create Database:

CREATE DATABASE db;

Check Out: ls Useful Command Examples For Beginner On Linux

Click on the refresh icon and see the database created.

how to check mysql version in sqlyog

You can check the user permission on the MySQL server using the below command.

SELECT USER,HOST FROM mysql.user;

how to create new connection in sqlyog

you can also check the permissions of a user on the database.

SHOW GRANTS FOR 'root'@'%';

Check Out: How To Install PostgreSQL Server On Ubuntu 19.10

Alternatives commands.

USE mysql;
SELECT HOST FROM USER WHERE USER = 'root';

Now I have created a user using CREATE USER abc;

if you want to change the user password, just click on the user manager icon and select the user from drop n down.

how to download sqlyog full version

Click on Save.

Now we will give permission to the user on a particular database.

Check Out: How To Create Automatic Backup of Volumes And EC2 On Amazon cloud

Open it again and select the database and user.

Perform Database Task

Click on Save changes and you can perform any task here you want to change without using the command line.

If you want to see the data in a table of a particular database. So simply select the database and expand the table. Choose a particular table then click on Table Data as shown in the figure below.

If you require to change in any table data just double click on it and save.

create user in sqlyog

If you want to copy the data, right-click on the data column → copy
→ copy cell data to the clipboard. In a similar way, you can choose 
an option.

Check Out: How To Create a Clone of Existing Virtual Machine In VMWare

When can also copy tables from the database to another database using it. Select a table from the source database to the target database. Click on a Copy.

create user in sqlyog

Once the tables copied, we can check inside the database.

table copy in sqlyog

You’re done sqlyog change user in create table check data copy

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

Leave a comment