The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

ODBC or DWCS4, DWCS5 Error 1045, with MySQL.

Discussion in 'Database Discussions' started by Elliot Balanza, Oct 5, 2011.

  1. Elliot Balanza

    Elliot Balanza Registered

    Joined:
    Oct 5, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello:

    I'm having the following problem while trying to use DWCS4 or DWCS5, and now i've noticed also while trying to use a MySQL ODBC connector.

    It seems that if I try to use those things, when trying to connect it always gives me a 1045 error. This can't be solved in ODBC, but in DW, if I just ignore the problem and handcode the program, (i.e. do the query by hand and not using dw tools) then when i upload the same material it works.

    So the main problem is when trying to access remotely the data.

    I know a 1045 is a password problem, but there are no problems, since it works fine.

    My Server, alledgelly is "Localhost", however if I try to use the ip, or the hostname the error changes to a 1043, sever.myserver.com is not allowed to use this database.

    Of Course I've also checked that my remote masks are on, and that the IP I'm trying to connect from is valid. I can even connect using the GUI from MySQL, no problem, but DW and ODBC Drivers refuses to connect.

    Any Idea what is happening? Maybe the port that is used for ODBC changes in Cpanel?

    One last thing this is happening in two different servers by two different providers, but both using Cpanel Accelerated 2.
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,456
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You're trying to connect to a database on your cPanel account with dreamweaver and it will not connect, is that right?
     
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Have you added the computer you are using DreamWeaver on IP to cPanel > Remote MySQL area? If you aren't certain your IP, you could use What Is My IP Address - Shows Your IP Address when using that computer to see the results. If you haven't allowed your computer's IP that has DreamWeaver as an IP in Remote MySQL area, you won't be able to connect to the database from it.
     

Share This Page