MySQL administrator - (newbie)

Discussion in 'Web Design and Development' started by digitaldean, May 9, 2006.

  1. digitaldean macrumors member

    Feb 13, 2006
    First time in MySQL administrator (1.1). Running Mac OS 10.4.6. Already MySQL 5 installed and connected.

    Trying to set up a developer environment so I can learn more about MySQL and how to integrate it with ColdFusion, PHP, etc.

    Tried to set up a new account, entered in the username and password. Tried to save changes and got a message stating that I had to set up a host. So, I clicked on the "add a host" button to add a new host for the new account I am setting up.

    Then I get another error message stating that there are changes that need to be saved or discarded for this acct. When I try click on "Save changes" I get the initial message about "adding a host". Only way I get out of this idiocy is by discarding changes, which is starting all over again.

    What am I doing wrong? :confused:
  2. thejadedmonkey macrumors 604


    May 28, 2005
    No idea...I use phpmyadmin, but adding a host sounds like somewhere you need to configure it to use localhost as the host. just a thought...
  3. xelterran macrumors 6502

    Dec 28, 2001
    If you already set up a root user then just log into the localhost server with:

    Server Hostname: (localhost)
    Username: root
    Password: (password)

    When I installed the package from I set up a new root user with the following command in the terminal:

    /usr/local/mysql/bin/mysqladmin -u root password new_password_here

    When you have logged in you will want to set up another account for your web apps to use (its just more secure like that rather than using the root account).

    Some links:

Share This Page