Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Fink?

I just downloaded mysql from fink to my new Tiger OS, I can't seem to get going? After using mysql -u root -p, it gives me this error message.
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I tried to run MYSQL server also,

11:01:37:fvs > mysqld_safe --franksoranno=mysql &
[1] 1306
11:02:34:fvs > touch: /sw/var/mysql/127.0.0.1.err: Permission denied
chown: /sw/var/mysql/127.0.0.1.err: Permission denied
Starting mysqld daemon with databases from /sw/var/mysql
/sw/bin/mysqld_safe: line 302: /sw/var/mysql/127.0.0.1.err: Permission denied
rm: /sw/var/mysql/127.0.0.1.pid: Permission denied
/sw/bin/mysqld_safe: line 1: /sw/var/mysql/127.0.0.1.err: Permission denied
STOPPING server from pid file /sw/var/mysql/127.0.0.1.pid
tee: /sw/var/mysql/127.0.0.1.err: Permission denied
050925 11:02:35 mysqld ended
tee: /sw/var/mysql/127.0.0.1.err: Permission denied

I don't know what to do next?

Posted on Sep 25, 2005 10:58 AM

Reply
3 replies

Sep 26, 2005 3:26 AM in response to freemem

Thanks Peter,
I removed mysql from the /sw/bin with fink remove command and downloaded directly from Mysql site, However I do have a problem with System Preferences Server switch which does not respond to shutting off? Can I shut down and start up from the command line? If so what are the commands? fvs

I used the following commands and no dice,

05:37:04:fvs > mysql.server stop
-bash: mysql.server: command not found
05:37:29:fvs > mysqld.server stop
-bash: mysqld.server: command not found
05:38:42:fvs > mysqladmin shutdown
mysqladmin: shutdown failed; error: 'Access denied; you need the SHUTDOWN privilege for this operation'
05:40:10:fvs > sudo mysqladmin shutdown
Password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
05:41:10:fvs > mysqladmin shutdown -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'franksoranno'@'localhost' (using password: YES)'
05:42:10:fvs >

Sep 26, 2005 4:10 AM in response to FVS

did you set the mysql root password? note that its not your system admin/root password. To set the password use this command once after starting up mysql.

/usr/local/mysql/bin/mysqladmin -u root password new passwordhere


you can shutdown it with the mysqladmin shutdown as you allready tried, might be just the password problem above, hope so 🙂

edit: some good instructions (while distribution package is old and not continued) in Mark Liynage pages

Fink?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.