Find the answer to your Linux question:
Results 1 to 4 of 4
I am using MYSQL 4.1 on my CentOS 4.2 my server is working very fine but i am not able to connect to my mysql database server from remote Computer ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2005
    Location
    INDIA
    Posts
    41

    MYSQL


    I am using MYSQL 4.1 on my CentOS 4.2

    my server is working very fine
    but i am not able to connect to my mysql
    database server from remote Computer

    the following error:-

    Host is not allowed to Connect to This MYSQL server

    error number 1103


    Plz Help me this is urgent

  2. #2
    Just Joined!
    Join Date
    Nov 2005
    Location
    California
    Posts
    36
    You need to enable network access, in your my.cnf file comment out
    Code:
    skip networking
    and ensure you have a line reading
    Code:
    port = 3306 (or whatever port number you are going to use)

  3. #3
    Just Joined!
    Join Date
    Jul 2005
    Location
    INDIA
    Posts
    41

    MYSQL

    This is my.cnf file


    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Guru sarumont's Avatar
    Join Date
    Apr 2003
    Location
    /dev/urandom
    Posts
    3,682
    You will need to enable access from that host (and/or user). Check out the mysql docs on authentication.

    http://dev.mysql.com/doc/refman/5.0/...ge-system.html
    "Time is an illusion. Lunchtime, doubly so."
    ~Douglas Adams, The Hitchhiker's Guide to the Galaxy

Posting Permissions

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