Alpha Video Training
Results 1 to 5 of 5

Thread: mySQL connection error

  1. #1
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default mySQL connection error

    failed to connect to a mySQL database locally installed on developers machine.
    when i click test connection button, that error appears
    any ideas?

    regards
    Last edited by fddizon; 03-26-2008 at 07:45 PM. Reason: forgot to attach screen shot
    Francis

  2. #2
    Member
    Real Name
    Jack DeBoer
    Join Date
    Oct 2006
    Location
    Houston, TX
    Posts
    457

    Default Re: mySQL connection error

    Can you connect to the data base from you computer with one of Mysql tools?

    Got the correct name of the database?

  3. #3
    Member
    Real Name
    Jim Coltz
    Join Date
    Oct 2005
    Location
    Western Pennsylvania
    Posts
    600

    Default Re: mySQL connection error

    Quote Originally Posted by fddizon View Post
    failed to connect to a mySQL database locally installed on developers machine.
    when i click test connection button, that error appears
    any ideas?

    regards
    Try replacing MySql with localhost as the hostname.

  4. #4
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,070

    Default Re: mySQL connection error

    Seconding Jim's suggestion, local databases (local anything) need to be referenced as localhost...

  5. #5
    Member
    Real Name
    Mark Liermann
    Join Date
    Jun 2000
    Location
    Wisconsin
    Posts
    141

    Default Re: mySQL connection error

    Quote Originally Posted by NoeticCC View Post
    Seconding Jim's suggestion, local databases (local anything) need to be referenced as localhost...
    On a local connection, use localhost as suggested or you can also designate the ip address, which for local is 127.0.0.1


    Be advised, however, in MySQL, if you try to access a remote MySQL server via IP and the user name is not designated as remote connection capable within MySQL, it will not allow the login to succeed.

Similar Threads

  1. MySQL Connection
    By Walter in forum Application Server Version 8
    Replies: 2
    Last Post: 09-04-2007, 03:49 PM
  2. Secure connection to mySQL database
    By Paul H in forum Alpha Five Version 8
    Replies: 8
    Last Post: 08-01-2007, 07:06 PM
  3. MYSQL connection via ODBC
    By RQCD in forum Alpha Five Version 7
    Replies: 7
    Last Post: 09-05-2006, 05:52 PM

Bookmarks

Posting Permissions

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