I have installed mysql on Mac OSX 10.3 Server. However the installation only appears to be partly successful. I am able to connect to mysql via php using the default localhost root and no password. However it only displays the 'test' database and I have no rights to create tables, databases etc.
When I try to issue any commands in mysqladmin in the bin directory I get the error: unable to connect to mysql.sock in tmp. I have done a search and there is no such file anywhere on the system.
I then looked at the mysql documentation and followed their instructions for installing mysql.sock if it is lost or damaged to no avail.
Can anyone explain how I can reinstall mysql.sock on my system?
I am also unable to locate a copy of my.cnf anywhere on the system. I have run the installer several times but both of these files are still missing.
Help!!