Alpha Video Training
Results 1 to 4 of 4

Thread: Cannot connect to mysql

  1. #1
    Member
    Real Name
    Andrew De Beer
    Join Date
    Mar 2018
    Location
    Pretoria, South Africa
    Posts
    14

    Default Cannot connect to mysql

    Hi All

    When trying to connect to an existing MySQL database I get the following message:
    Screenshot 2019-03-11 13.15.42.png

    I could connect previously. Any ideas?

    Best Regards

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,317

    Default Re: Cannot connect to mysql

    It's only a guess, but I think somewhere you have the character set defined as
    utf8mb4 instead of utf8.

    Probably in the table definition.

  3. #3
    Member
    Real Name
    Andrew De Beer
    Join Date
    Mar 2018
    Location
    Pretoria, South Africa
    Posts
    14

    Default Re: Cannot connect to mysql

    Hi Madtowing.

    Thanks for your response. Will look into that.

    Regards

  4. #4
    Member
    Real Name
    Peter Gagiano
    Join Date
    Dec 2004
    Location
    Cape Town South Africa
    Posts
    424

    Default Re: Cannot connect to mysql

    This is what I found - This error usually happens when you try to import an entire database, or single table that was exported from a newer version of PHPMyAdmin. So when you try to import this file into an older version of MySQL that doesn't support the utf8mb4 charset, you will face the exception. The most probably case is that locally you have a major version of MySQL, and on stage/hosted VPS you have MySQL server version less than 5.5.3.

    This was suggested to solve it:
    There's a good chance (depending of the kind of characters stored on your table) that you can solve this issue by simply changing the utf8mb4 with just utf8. According to the MySQL docs, the utf8mb4 charset is a superset of utf8 that uses a maximum of four bytes per character and supports supplementary characters (instead of 3 that uses utf8).

    Alternatively, if you are able to, you can update the version of MySQL installed on your server that supports the utf8mb4 charset.

    Hope this helps.

Similar Threads

  1. Can't connect to MySQL server on '216.3.x.x' (10060)
    By rdecle01 in forum Application Server Version 9 - Web/Browser Applications
    Replies: 1
    Last Post: 06-16-2009, 04:35 PM
  2. Cannot connect to remote MySQL DB
    By Mario Prieto in forum Alpha Five Version 9 - Desktop Applications
    Replies: 1
    Last Post: 04-21-2008, 11:13 PM
  3. Re: Cannot connect to mySQL or import from mySQL database
    By siric in forum Alpha Five Version 7
    Replies: 4
    Last Post: 01-16-2007, 11:22 AM
  4. Do you have to have DSN to connect to MYSQL
    By Tom Mills in forum Alpha Five Version 7
    Replies: 3
    Last Post: 01-14-2007, 12:20 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
  •