How to access the database on the server with SQLyog

How to access the database on the server with SQLyog?. Yes, if we use SQLyog for access database, that is make more easy because SQLyog GUI based. We can access database on the server with SQLyog making database administration easier.

This is the way How to access the database on the server with SQLyog :

1. Access server use terminal, U can access on server or use ssh.

2. Run mysql console on terminal.

$ sudo mysql -u root -p , and then type the password of your mysql.

3. Create user root on your mysql

mysql > create user 'root'@'%';

mysql> set password for 'root'@'%'=old_password('yourpasswordforuserroot');

mysql> grant all previleges on *.* to 'root'@'%';

mysql> flush privileges;

OK, you can check user root on your mysql,

mysql> use mysql;

mysql> select * from user;

you can check on list user.

exit from nysql console , use exit or quit

4. Edit file my.cnf

You must commen bind 127.0.0.1 on file my.cnf

$ sudo nano /etc/mysql/my.cnf

save and exit.

5. Restart mysql service

$sudo /etc/init.d/mysql restart

Ok, now test use SQLyog. Open SQLyog and access use root user :

And then click connect, you will open SQLyog.

Ok that is way How to access the database on the server with SQLyog.

Source