MySQL administrator - (newbie)

[digitaldean]

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?

 

[thejadedmonkey]

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...

 

[xelterran]

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