Mysql problems
 

I am new to mysql, but not to Slack. I am running Slack 8 and trying to get the default install of mysql working. I don't even know where to start as I finally think I have it working and then something else screws up. I will post the error messages I get below and hopefully someone can make sense of them and point me in the right direction.

Thanks

When I start the server I get:

# /usr/share/mysql/mysql.server start
Starting mysqld daemon with databases from /usr/local/mysql/var

It appears to be working and port 3306 is open. Then I try to log in and get this:

ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)

Note. mysql.sock is 0 bytes. Is this normal?

When I try to add a user I get this:

/usr# ./bin/mysqladmin -u root -p password
Enter password:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/run/mysql/mysql.sock' exists!

Mysql is running on port 3306 and the file does exist.

usr# ./bin/mysqladmin -u root -h myuser -p password
Enter password:
./bin/mysqladmin: connect to server at 'myuser' failed
error: 'Host 'myuser.mybox.com' is not allowed to connect to this MySQL server'

Note: user.pid does not exist, which I believe is needed. How do I get this file?

Permissions on the directory
 

>ERROR 2002: Can't connect to local MySQL server
>through socket '/var/run/mysql/mysql.sock' (111)

Mysql needs executable permissions on the /var/run/mysql directory. If this seems unsafe to you then another solution is to link the socket in (for example) the /tmp dir. Keep in mind that every local user would be able to contact the socket in both cases. A good setup for the mysql privileges would be needed.

Regards,

Hans

I had the same problems with slak,I just uninstalled mysql and got the latest version off of mysql.com and followed their install exactly and it worked fine.