mySQL host

Results 1 to 7 of 7
  1. #1
    Member nonase is offline
    MemberRank
    Jun 2006 Join Date
    inside a small roomLocation
    39Posts

    mySQL host

    i need help. once i change database ip in navicat to my lan ip so i can play with my bro.. it says that

    [ 1130 - Host 'NONASE' is not allowed to connect to this MySQL server ]

    when i change ip in the config.ini for the server and run the server.. same thing happen.. how to disable this???

    thx for adv..


  2. #2
    Newbie Jappie is offline
    MemberRank
    Sep 2006 Join Date
    3Posts
    I got the same problem, someone has an answer for this?

  3. #3
    Elite Member andy733 is offline
    Member +Rank
    Jul 2006 Join Date
    EnglandLocation
    182Posts
    u have to port foward it

  4. #4
    Quote Originally Posted by nonase View Post
    i need help. once i change database ip in navicat to my lan ip so i can play with my bro.. it says that

    [ 1130 - Host 'NONASE' is not allowed to connect to this MySQL server ]

    when i change ip in the config.ini for the server and run the server.. same thing happen.. how to disable this???

    thx for adv..
    open your config file delete old text and place this

    [SETUP]
    mysqlip=127.0.0.1
    username=root
    password=
    database=roseon_beta
    [LOGINSERVER]
    servername=eRose
    totalchannel=1 ;max 3 channels
    channel1=Channel1
    channel2=Channel2
    channel3=Channel3
    channel1ip=192.168.0.1
    channel2ip=5.41.158.99
    channel3ip=5.41.158.99
    [CHARSERVER]
    worldip=192.168.0.1
    [WORLDSERVER]
    welcomemsg=Welcome to the eROSE alpha server.
    droptype=0 ;0=random 1=drop based on database drops table (list_mobs)
    exprate=10 ;experiece rate. max 100

  5. #5
    Member nonase is offline
    MemberRank
    Jun 2006 Join Date
    inside a small roomLocation
    39Posts
    i think this for NA client.. i using server for hosting evo client...

  6. #6
    Meh Matt is offline
    Grand MasterRank
    Aug 2006 Join Date
    Ontario, CanadaLocation
    1,745Posts
    omfg.. You have the host in the username spot
    Your host isnt called NONASE, Is that your MySQL User? If NONASE is your comp name, you cant use that.

  7. #7
    Member nonase is offline
    MemberRank
    Jun 2006 Join Date
    inside a small roomLocation
    39Posts
    this what i mean by it



    ps: i've change my connection name



Advertisement