running mac os x server version 10.4.9 and trying to get mysql
server installed and running. after hours of getting nowhere and
lots of tries at installing i discovered that i don't have a mysql
user setup (checked using netinfo manager). i tried to create this
user but am getting the error that i can't use that name.
so... my question is this. is there a way to re-install mysql and
the group/user for mysql as was install with the os without doing
a clean install of the os?
several questions:
1. are you SURE the issue is you don't have the user? Run "id
mysql" at the command line and see what you get. The MySQL user is
setup by default so you would have to consciously remove it.
2. What method did you use to install mysql? Where did you get your
distribution? If you're not careful you can get the wrong one (i.e.
one for intel vs. PPC)
3. Check out the contents of /usr/local/mysql/YOURHOSTNAME.err. It
may give you more info.
It may help to know what particular problems you are having.
-Pete-
Hi Pete,
Thank you for your quick reply. I inherited this "project" from
another guy who helps to maintain the server. The mysql user is
definitely gone:
root# id mysql
id: mysql: no such user
I am trying to install mysql using the package downloads from
mysql.com - I have tried quite a few versions but have always been
careful to use the 64 bit PPC version.
My error file is located in /usr/local/mysql/data and contains:
070330 20:54:46 mysqld started
070330 20:54:47 [Warning] Setting lower_case_table_names=2 because
file system for /usr/local/mysql/data/ is case insensitive
070330 20:54:47 [ERROR] Fatal error: Can't change to run as user
'mysql' ; Please check that the user exists!
