Unanswered: How to change file path locations after installation?
I have been asked to do somework on our company database, which is still in the developmental stages. However, every time I try to access the database I get a connection error. Further investigation has revealed that the MySQL daemon is not running. If I try to run 'mysqld' I get an error saying file not found. If I run 'safe_mysqld' I get an error message (see below).
touch: /usr/local/mysql/var/qube.us-sinosphere.com.err: No such file or directory
chown: /usr/local/mysql/var/qube.us-sinosphere.com.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/bin/safe_mysqld: /usr/local/mysql/var/qube.us-sinosphere.com.err: No such file or directory
I checked, there is no '/usr/local/mysql/var/' directory on our system. So I guess I need to manually configure mysql to look in a different directory when it starts. Only problem is I don't know how to do this. Do I need to recompile MySQL or can I just add some option for 'path name' when starting the daemon?
Two other questions, how can I determine what port mysql is using? and why can't the 'mysqld' file not be found?