MySQL administrator - (newbie)

digitaldean

macrumors member
Original poster
Feb 13, 2006
47
0
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:
 

xelterran

macrumors 6502
Dec 28, 2001
291
0
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