#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    DBI: mysql Error in Connection


    Hello Group.



    *** I am starting my work with Perl and ran in a "Catch-" I try to connect them hum base mysql through the internal network using the ip of the machine and using hum Favorites Looks Different does not root, but with the All access to basic Opaque try to connect, but No Surprise My appears "1045 Access denied for user".

    *** Using own mysql I can access all correctly EVEN remotely, this service CAN Opaque So Strange Case That blocks the access?


    **** I am currently using a strawberry version 5.14.

    Marcio Souza
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Location
    spaceBAR Central
    Posts
    229
    Rep Power
    42
    Try it with 'trace' enabled for DBI so you will get more info about what is happening.

    Example: DBI->trace( 5 );

    DBI trace information can be enabled for all handles using the trace DBI class method. To enable trace information for a specific handle, use the $h->trace method.

    DBI->trace($trace_level)
    DBI->trace($trace_level, $trace_filename)

    Initially trace output is written to STDERR.
    If $trace_filename is specified and can be opened in append mode then all trace output (including that from other handles) is redirected to that file.

    Trace levels are as follows:
    0 - Trace disabled.
    1 - Trace DBI method calls returning with results or errors.
    2 - Trace method entry with parameters and returning with results.
    3 - As above, adding some high-level information from the driver
    and some internal information from the DBI.
    4 - As above, adding more detailed information from the driver.
    5 and above - As above but with more and more obscure information.

    Trace level 1 is best for a simple overview of what is happening.
    Trace level 2 is a good choice for general purpose tracing.
    Levels 3 and above (up to 9) are best reserved for investigating a specific problem, when you need to see "inside" the driver and DBI.

IMN logo majestic logo threadwatch logo seochat tools logo