MySql on Mac OSX 2

Can't get it started

[Montbazin]

I have installed MySql on my G4 Mac.
The installation went fine. But when I open the MySql System Preference it tells me that Mysql is not running.
If I click on "Start" it asks for a password.

I was never asked to enter a passwor during the installation process.
How can I start MySql and get it to work properly together with PHP which is working fine.

Thanx for your help

[Russ49Checkmate]

Sounds like something I did recently.

Frankly I don't remember any MySQL System Preference. I definately don't click any kind of "start" button to run MySQL.

It's been a while since I installed it, but I seem to remember typing into Terminal the commands found in the MySQL Reference Manual section 2.2.3 - Installing MySQL on Mac OS X. From there I never bothered with any graphic interface, the command line was suitable and simple enough for my small needs.

[dcrombie]

I suggest you follow the instructions here [entropy.ch] ;)

[timster]

Frankly I don't remember any MySQL System Preference.

I didn't either, but when I downloaded MySQL yesterday, there was something new: the MySQL.prefpane file.

MySQL AB hasn't made much fanfare about this handy little tool, maybe because it doesn't work so well yet. Some other folks have reported it not working with OS X 10.2. Seems to work OK in 10.4.1, though.

[bugs.mysql.com ]

[entropy.ch ]

Added: I should say it works fine in Tiger besides for a button sometimes saying "Start MySQL Server" (instead of "Stop") when it's already running.

[Montbazin]

Yes I have installed the "MySQL.prefpane" file and it is there wher I cant create a password

(I cant uptate to higher than OSX 2 since higer versions do not recognize my video card for my 2nd screen... but that is another topic)

[timster]

Yes I have installed the "MySQL.prefpane" file and it is there wher I cant create a password

Yes, that is a little confusing. You can't set your MySQL password there. The pref pane confronts you for your Mac OS X administrator password, not your MySQL password.

After you get MySQL running, you can run the MySQL Administrator to set things up. It will also prompt you for a password. This will be your MySQL password, but if you don't have a password set up yet, just leave it blank to connect to the server.

After that, click on the "Accounts" button to set up your passwords.

[lZakl]

This could be settled in about 1 minute using terminal. Is there a reason you haven't tried starting MySql and changing the password from a command line? Remember, the command line is your biggest asset when the GUI's fail to give you what you're looking for!

-- Zak

[Russ49Checkmate]

GUI problems ...

I think Montbazin needs to NOT be messing with these GUI's. I speak as a fellow novice to matters server-side scripting.

I use the Terminal program exclusively when dealing with MySQL, since I have to know what the command line entry is in order to know what to tell the PHP script to say.

Unless Montbazin wants to send the GUI commands, he should be hot on Terminal learning (as I am) what to tell MySQL at that level.

/usr/local/mysql/bin/mysql -u [User]