MySQL administrator - (newbie)

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

  1. digitaldean macrumors member

    Joined:
    Feb 13, 2006
    #1
    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

    thejadedmonkey

    Joined:
    May 28, 2005
    Location:
    Pa
    #2
    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

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

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


    When I installed the package from entropy.ch 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:
    http://www.entropy.ch/software/macosx/mysql/
    http://dev.mysql.com/doc/refman/5.0/en/grant.html
     

Share This Page