Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

installing mysql in solaris7

Status
Not open for further replies.

tempsup

MIS
Sep 10, 2003
26
0
0
GB
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2
'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!



when trying to start mysql, i keep getting the above error. Please help.
 
If you don't have write access to create a socket file at the default place (in `/tmp') or permission to create temporary files in `/tmp,' you will get an error when running mysql_install_db or when starting or using mysqld.
You can give mysql read/write access or specify a different socket and temporary directory as follows:

shell> TMPDIR=/some_tmp_dir/
shell> MYSQL_UNIX_PORT=/some_tmp_dir/mysqld.sock
shell> export TMPDIR MYSQL_UNIX_PORT

In /etc/smb.conf, change the location of the socket

[client]
socket=path-for-socket-file
[mysqld]
socket=path-for-socket-file

You would want to secure the file to the owner and root so that no one can delete the file and crash the database.
Hope that helps...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top