XAMPP / MySQL / Not Working

[tomyknoker]

Hi All,

I installed XAMPP on my MAC Powerbook G4, running OS X 10.4. It all installed fine and I can see it in the applications menu. In there is also a script "mamppstart", when I click this I get the following message:

Starting XAMPP for MacOS X 0.5...
XAMPP: Starting Apache with SSL (and PHP4)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for MacOS X started.

I'm assuming that's good and means that everything has installed and running, however I try to locate MySQL in the Terminal and get nowhere. Also when I click my MySQL preference pane it says there is an error...

Any ideas?

Thanks in adavnce!
Tom

[chazzy]

what error??

[tomyknoker]

I open up a Terminal to start using MySQL, (this is what I do yea?) and it can't find it with the paths I've been told...

[chazzy]

k so you can't find it, not that you get an error. unfortunately it looks like the xampp for mac os x is down due to no hardware so hmm...

we have it installed at work (and i now regret the day i recommended it) so..where are you looking exactly? I'll compare it to linux, it should be comparable. you can check for all processes running, right? if so, do you see mysqld?

[tomyknoker]

Ok so I open up a terminal and this is what I see: Last login: Fri Jun 9 11:05:44 on console
Welcome to Darwin!
Tom-Synnotts-Computer:~ tomsynnott$, do I just type in /usr/local/mysql, it says it can't be found...

[chazzy]

no
it's definitely not /usr/local/mysql, that's the default when it's not in lampp. can you run a find / -name mysql and see what shows up, if anything? if not when i get to work a little later i'll check the structure.

[tomyknoker]

ever since I installed XAMPP on my Mac Powerbook, each time I log in there is now an extra user??? Any ideas why??? I can't actually see the user in my preferences... only in my Log In screen...

[NogDog]

Possibly the Apache user?

[tomyknoker]

Oh ok so do I just leave that then?

Also I changed the password for the root user using phpMyAdmin... and now when I go to the page it says: Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO) Is there anything I can do to fix this?

[NogDog]

To start mysql as user "root":

mysql -u root -p

It should then prompt you for the password.

[tomyknoker]

no
it's definitely not /usr/local/mysql, that's the default when it's not in lampp. can you run a find / -name mysql and see what shows up, if anything? if not when i get to work a little later i'll check the structure.ok i tried that and this is what I got... it's lengthy sorry :confused: /Users/tomsynnott/Library/Application Support/Adobe/Bridge/Cache/Metadata/data/mysql
/usr/local/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-i686/data: Permission denied
/usr/local/mysql-standard-5.0.22-osx10.4-powerpc/bin/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-powerpc/data: Permission denied
/usr/local/mysql-standard-5.0.22-osx10.4-powerpc/share/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-powerpc/share/mysql/japanese-sjis: Permission denied
/usr/local/php5/lib/mysql
/usr/local/php5/lib/php/extensions/no-debug-non-zts-20050922/mysql

[tomyknoker]

actually I typed this in:
/usr/local/mysql-standard-5.0.22-osx10.4-powerpc/share/mysql and it opened mySQL but when I take a look at the databases it only show's me the one's which were in MAMP > SQLLite, not the one I created in PHPMyAdmin... Does this mean the machine has different MySQL's running on it?

[tomyknoker]

no
it's definitely not /usr/local/mysql, that's the default when it's not in lampp. can you run a find / -name mysql and see what shows up, if anything? if not when i get to work a little later i'll check the structure.
hi chazzy... i installed mysql but now can't get it to run at all! I tried find again this is what I got, is it in the right spot? Tom-Synnotts-Computer:~ tomsynnott$ find / -name mysql
find: /.Spotlight-V100: Permission denied
find: /.Trashes: Permission denied
/Applications/Adobe Bridge/Bridge.app/Contents/db_support/data/mysql
/Applications/Adobe Bridge/Bridge.app/Contents/db_support/install/share/mysql
/Applications/Adobe Version Cue CS2/data/database/data/mysql
/Applications/Adobe Version Cue CS2/data/database/share/mysql
/Users/tomsynnott/Library/Application Support/Adobe/Bridge/Cache/Metadata/data/mysql
/usr/local/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-i686/data: Permission denied
/usr/local/mysql-standard-5.0.22-osx10.4-powerpc/bin/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-powerpc/data: Permission denied
/usr/local/mysql-standard-5.0.22-osx10.4-powerpc/share/mysql
find: /usr/local/mysql-standard-5.0.22-osx10.4-powerpc/share/mysql/japanese-sjis: Permission denied
/usr/local/php5/lib/mysql
/usr/local/php5/lib/php/extensions/no-debug-non-zts-20050922/mysql
Tom-Synnotts-Computer:~ tomsynnott$

[DragonLotus]

sudo chmod +x /opt/lampp/bin/mysql
/opt/lampp/bin/mysql

That will get you into mysql if you have lampp installed. Goodluck.