Making local connection to MySQL using OS X

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Making local connection to MySQL using OS X

    I am using OS X and Dreamweaver MX. I am trying to make a connection to the
    MySQL Sever from within Dreamweaver using the Applications panel and clikcing
    on the "+". A window opens asking for:
    Connection Name: Apress
    MySQL Server: localhost
    User Name: apress
    Password: xxxxxx
    Database (Select):
    When I click select so the Dreamweaver can browse to the databases in MySQL
    the connection is not being made because Dreamweaver cannot find the MySQL
    Server. I think that "localhost" is wrong even though I am using a book that
    tells me to use localhost. MySQL and PHP are on my local machine. I am NOT
    using a remote machine. I used phpMyAdmin to create the databases. Any
    suggestions?

    Gregory

    itisgregory Guest

  2. Similar Questions and Discussions

    1. #40741 [NEW]: when --with-mysql used, it also takes the lib/includes from /usr/local/mysql ..
      From: d dot huijbers at apollo-ict dot nl Operating system: FreeBSD PHP version: 5.2.1 PHP Bug Type: *Compile Issues Bug...
    2. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
      When i try to start my mysql server, i get this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'...
    3. Making ASMX Test available to non-local computers
      Hi, I would like to make the ASMX test page available to potential consumers of the service. However the test page says “The test form is only...
    4. Seen this message? Can't connect to local MySQL server through socket '/tmp/mysql.sock'
      Seen this message? Can't connect to local MySQL server through socket '/tmp/mysql.sock' I got this trying to install DBI and DBD for mysql from...
    5. Seen this message? Can't connect to local MySQL server throughsocket '/tmp/mysql.sock'
      Allen Marshall wrote: I just saw it in another newsgroup. Don't multi-post! -- Gunnar Hjalmarsson Email:...
  3. #2

    Default Re: Making local connection to MySQL using OS X

    Assuming that everyone is working fine with your PHP, APACHE and MySQL you
    might try this:

    In your site definition you can't use localhost for your testing URL prefix,
    as you probably were isntructed to do. You need to use this:

    [url]http://127.0.0.1/[/url]

    There are a few other alternates prefixes like machine name, etc. But this is
    working great for me, so give it a try.:light;

    ticasticus Guest

  4. #3

    Default Re: Making local connection to MySQL using OS X

    ticasticus wrote:
    > In your site definition you can't use localhost for your testing URL prefix,
    > as you probably were isntructed to do.
    Not true. I was one of the authors of the book clearly being referred
    to, and Dreamweaver 7.0.1 on Mac OS X 10.3 accepts localhost.

    You need to use this:
    >
    > [url]http://127.0.0.1/[/url]
    You don't *need* to use it if you have the 7.0.1 updater installed, but
    it's certainly a good idea to try it. I have added a number of other
    suggestions in my reply to the original poster's duplicate post in the
    Dreamweaver forum.

    --
    David Powers
    Author, "Foundation PHP 5 for Flash" (friends of ED)
    Co-author "PHP Web Development with DW MX 2004" (Apress)
    [url]http://computerbookshelf.com[/url]
    David Powers Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139