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 db;
Click on the refresh icon and see the database created.
You can check the user permission on the MySQL server using the below command.
SELECT USER,HOST FROM mysql.user;
you can also check the permissions of a user on the database.
SHOW GRANTS FOR 'root'@'%';
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.
Click on Save.
Now we will give permission to the user on a particular database.
Open it again and select the database and user.
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.
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.
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.
Once the tables copied, we can check inside the database.
You’re done sqlyog change user in create table check data copy