Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Connecting Mysql Server By Remote User

forums › forums › SQLyog › Using SQLyog › Connecting Mysql Server By Remote User

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 4, 2006 at 12:45 pm #9793
      neel
      Member

      Hi to all,

      i'm new here.

      i want to connecting a mysql database using sqlyog but i can't do that.

      will u pls tell me how can i connect to the other database.

    • August 7, 2006 at 2:08 pm #22092
      peterlaursen
      Participant

      User privileges in MySQL are host specific.

      so you must grant privleges to the remote user. If for isntance root shall be able to log on from everywhere and have same privileges as 'root'@'localhost' has the SQL is

      grant all on *.* to 'root'@'%' with grant option;

      On an example where 'billy' may only select from a single database and connect from a certain group of ip's.

      grant select on *.* to 'billy'@'10.0.0.%';

      http://mysql.com/doc/refman/5.0/en/grant.html

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.