Mysql...?

MikeFoo1 · 04-15-2004, 06:48 PM

Hi, i am trying to get Mysql work but no luck.

Using the default mysql installation that came with salckware 9.0.

get this:

$safe_mysqld

Starting mysqld daemon with databases from /var/lib/mysql
040416 11:44:03 mysqld ended

also, get this

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

Any help would be appreciated .

MikeFoo1 · 04-15-2004, 07:55 PM

Anyone ?Help .

jax8 · 04-15-2004, 08:07 PM

you do not have to mysql server running

go to "system settings" --> "server settings" --> "services"

then find the sqld and start it.

then type

mysql

rylan76 · 04-17-2004, 02:02 PM

Hi

Try this as superuser

chown -R mysql.mysql /directory about which mysql complains it can't use the socket

That should allow you to start mysql no problems. I had exactly the same problem as you and this chown stuff fixed me right up.

Cheers

trickykid · 04-17-2004, 03:20 PM

Actually you should have searched first, I know I've probably explained these steps a dozen times or so and also in the future, don't bump your own threads until after 24 hours has at least passed...

As root:

This creates the inital tables to use:
# mysql_install_db

Change the permissions for mysql:
# chown -R mysql.mysql /var/lib/mysql

This starts the daemon and server:
# mysqld_safe &
If its not mysqld_safe its the other way around, I know the later versions you use the above.

And that should do it.

MikeFoo1 · 04-18-2004, 10:23 PM

Quote:

Originally posted by trickykid
Actually you should have searched first, I know I've probably explained these steps a dozen times or so and also in the future, don't bump your own threads until after 24 hours has at least passed...

As root:

This creates the inital tables to use:
# mysql_install_db

Change the permissions for mysql:
# chown -R mysql.mysql /var/lib/mysql

This starts the daemon and server:
# mysqld_safe &
If its not mysqld_safe its the other way around, I know the later versions you use the above.

And that should do it.

Thanks a lot :-) .