How To Create Database And User In SQLyog On Windows
We have already installed SQLyog on the windows machine and MariaDB server installed on CentOS 7. Let’s see, how to create, access database and user using SQLyog community software for windows. We can also manage MySQL in SQLyog.
We can use this software to manage SQL all queries and it’s like we’re managing a server with GUI mode. This is also available in the paid version but if you want to manage only servers, you can use freely without paying.
Open the SQLyog and click on New…
put the information about login credentials.
Click on Test Connection.
I have connected with the root user to log in to the server using SQLyog.
Now I will create a database and grant permission to the user. create database testing;
Grant permission on the user using the below command and this command will automatically create the user. you have to select the database only.
grant all privileges on testing.* to ‘curious’@’%’ identified by ‘viral’;
you can also check permission on the database using the below command.
show grants for ‘curious’@’%’;
Check Out: How To Delete Backup AMI EC2 On Amazon Cloud
So, you can simply manage MySQL using GUI in SQLyog.
You’re done manage mysql in sqlyog sqlyog community for windows access database in sqlyog sqlyog create database