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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL install problems SAGA -- mysql won't run

Status
Not open for further replies.

dancamp01

Technical User
Mar 7, 2002
4
US
i've reinstalled mysql source code, got through "make", "make

install", "./configure --prefix=/usr/local/mysql", and even this time

"scripts/mysql_install_db" with no problems.
But when I tried to change the permissions in the

/usr/local/mysql/data" directory I'm told that directory does not

exist. So I mkdir the data directory and then chown and chgrp it.
When I then run the "safe-mysqld --user=mysqluser &" it appears that

the mysql daemon fires up:
...........................
[1] 22155
[root@localhost bin]# Starting mysqld daemon with databases from

/usr/local/mysql/var
020308 14:50:56 mysqld ended
[1]+ Done safe_mysqld --user=mysqluser
...............................
then when I run "mysqladmin version" to verify if it is really

running, I get:
..............
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket

'/tmp/mysql.sock' (111)
Check that mysqld is running and that the socket: '/tmp/mysql.sock'

exists!......................
when I check I find a pink mysql.sock file in the /tmp directory.

 
My mysql.sock lives in /var/lib/mysql/mysql.sock and when I recieved the error you report I checked the permissions and found that I needed to chmod 777 the var/lib/mysql directory.
From this I suggest you check the permissions on the /tmp directory or start mysql and specify the directory for the socket - you'll need to check the install and config notes on how to do this. ***************************************
Party on, dudes!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top