Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: mamp (reset)

Mountain Lion Pre-MySQL
+2 Vote Up -0Vote Down

While I try to contain everything about installing MySQL in a single post that I update from time-to-time, Mac OS X, Mountain Lion (10.8.x), requires some pre-steps. You must install XCode, and the Command Line Tools. This post provides the screen shots and step-by-step instructions.

Before you can do any of these steps, you must connect to the Apple Store and download XCode. Dependent on your internet speed this may take some time. Generally, it’s an hour or less.

  • After installing XCode, click the Rocket Spaceship in the Mac Dock to launch a view of your Applications. Launch XCode by clicking on the hammer overlaying the blue background XCode icon shown below.
  •   [Read more...]
    MySQL Workbench Scripts
    +2 Vote Up -0Vote Down

    It’s always interesting when somebody asks why they got an error message, and especially sweet when you’re working on something related that lets you answer the question. They were using MySQL Workbench and wanted to know why they couldn’t open a SQL script file by clicking on the Scripting menu option.

    As I explained to the individual who asked, you should always click the Edit SQL Script link in the SQL Development section of the MySQL Workbench home page to work on SQL scripts. The Scripting menu option supports Python and Lua plug-ins development and scripts.

    They did the following initially, which led down the rabbit warren and left them stumped because they don’t know anything about Python or Lua. This is provided to those who choose to experiment with this advanced feature of MySQL Workbench.

      [Read more...]
    PHP/MySQL Query
    +1 Vote Up -0Vote Down

    Somebody wanted an example of how to handle column values using PHP to query a MySQL database. While I thought there were enough examples out there, they couldn’t find one that was code complete.

    Well, here’s one that works using a static query. If you want to use a prepared statement, check this earlier post.

    <html>
    <header>
    <title>Static Query Object Sample</title>
    <style type="text/css">
      /* HTML element styles. */
      table {background:white;border-style:solid;border-width:3px;border-color:black;border-collapse:collapse;}
      th {text-align:center;font-style:bold;background:lightgray;border:solid 1px gray;}
      td {border:solid 1px gray;}
     
      /* Class tag element styles. */
      .ID {min-width:50px;text-align:right;}
      .Label
      [Read more...]
    Zend CE has a Worm
    +0 Vote Up -1Vote Down

    After updating the AVGFree virus definitions, I was surprised to find that Zend CE (Community Edition) 4.0.6 had a worm in the JavaServer.exe file. There was greater surprise when Zend CE 5.3.9 (5.6.0-SP1) also had the same worm.

    This is the message identifying the worm (click on it to see a full size image), and you can read about this particular worm on the Mcafee site:

    Unless you have the full version of AVG or another security program to try and fix the file, you can only quarantine the file. Quarantine or removal disables Zend CE from working. It begs the questions,

      [Read more...]
    Mac users: MAMP now recommended, not XAMPP
    Employee +0 Vote Up -0Vote Down

    Dear Mac users,

    There have been a number of issues with configuring XAMP on the Mac for use with NetBeans IDE, most significantly that XAMP sets the owners of MySQL databases to "nobody", blocking Apache access. Therefore I have changed the Mac OS setup tutorial to use MAMP instead of XAMP. In my opinion, the MAMP setup is more straightforward than the one for XAMP, anyway.

    Showing entries 1 to 5

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.