I installed mysql with slackware while it was going in but since then i have not been able to use it. it would appear that hte server is starting when the computer boots but when i try to connect to it i get an error about not being able to connect through mysql.sock . i have looked in the directory it says but there is no mysql.sock in there. Does anyone know the problem and how to fix. (i have since then tried installing mysql from binarys and jave also compiled the source for it.) Cheers Dfhaii
I never could get mySQL to work more than once either - it's an old version they throw in anyway so my advice is to: 1) use pkgtool to remove mysql 2) explain what went wrong when you tried to use a binary set / compile from src ...and i'll tell you where you're going wrong
It's probably a problem with permissions on the directory it's trying to create the mysql.sock file in. If I recall correctly it uses a couple of directories in /var (run/ and spool/ perhaps?). Try finding the relevant mysql directories in there and do a recursive chmod/chown (with 'mysql' as user and group). I agree with RTT though, it would be a good idea to update to the latest version while you're messing around with stuff.
i have used the pkgtool thing to get rid of the mysql installed with slackware. now i have the one i compiled in /usr/local/mysql/ none of the apps are useable unless i go to the /usr/local/mysql/bin/ and ./appname When this is done and i have run mysqld_safe to start the server if i try to check the version of it it says Code: root@boris:/usr/local/mysql/bin# mysqladmin version -bash: mysqladmin: command not found root@boris:/usr/local/mysql/bin# ./mysqladmin version ./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! i dunno what i have done wrong . Cheers Col
First, the reason why you're having to stick './' on the front of the command is because its not in your $PATH. When you try to run a binary bash looks for it in all the dirs listed in your $PATH * (echo $PATH to see all the dirs) - this is why you can run, for example, 'tar' no matter what directory you are working in. Where as ./ tells bash that the binary you wish to run is not in your path and is in the current directory. Add '/usr/local/mysql/bin' to your $PATH in /etc/profile and then you'll not have to use ./ anymore. Anyway... did you run the install scripts? run mysql from /etc/rc.d/mysql.server rather than doing it manually, and see if it still acts up. *actually it uses tables to store the locations of commonly used bins for much quicker operation...
If you carefully read the install instructions that come with the mysql source, they tell you the exact steps to get it up and running....