Find the answer to your Linux question:
Results 1 to 2 of 2
hi guys! im trying to do a SIMPLE app with C# that connect to mysql but it seems i cant connect from any other computer to my debian mysql-server it ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Sep 2004
    Location
    Montréal
    Posts
    1

    Can't connect to MySQL server


    hi guys!

    im trying to do a SIMPLE app with C# that connect to mysql

    but it seems i cant connect from any other computer to my debian mysql-server

    it tells me : can't connect.Host 'Toronto-HSE-ppp3887529.sympatico.ca' is not allowed to connect to this MySQL server

    the user exist with grant privilege, i have commented skip-networking in my.cnf

    SO ? what should i do? lol
    im pretty confused about that

    thank you
    luke

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    You need to explicitly say where the user is allowed to connect from.

    Take a look at http://dev.mysql.com/doc/mysql/en/Adding_users.html for more info.

    Remember once you have done your GRANT statement you need to run "FLUSH PRIVILEGES" to make the grant statement take effect.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •