Find the answer to your Linux question:
Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    Connecting remotely to a mysql server

    Hi all,
    I'm new to mysql, I hv a machine (gentoo Installed) used as mysql server. i'm able to connect that server remotely, but unable to connect into some other machine remotely, which is in the same network (Fedora core 3 installed). I download mysql server and other components over the internet (same version installed in the Gentoo machine) and installed on the fedora machine.
    when i try to connect Fedora machine it gives,
    MYSQL Error Number 1130
    host '' is not allowed to connect to this MYSQL server.
    I really apreciate if any one of you guys help me out on this.
    jo mike.

  2. #2
    Linux User Allblack's Avatar
    Join Date
    May 2003
    You have to set permissions for (gentoo) on your Fedora box.
    Log onto mysql(fedora) as root and allow connections from

    GRANT ALL PRIVILEGES ON *.* TO 'user'@'' IDENTIFIED BY 'urpassword'

    Read all about it ->
    I am on a journey to mastering Linux and I got a bloody long way to go!!!

  3. #3
    Thank you Allblack.
    problem solved.
    I had to update the user table in the mysql database in mysql server. In there I add an entries so that remote machines get priviladges to connect to this server.
    good luck with u r mastering in Linux thing. I also did some kernel level developmnts (MOdule programming) in linux though i new to mysql.

  4. $spacer_open

Posting Permissions

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