Slackware 10.1 & mysql problem!!!!!

[evix]

Heres what I get:

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

Any ideas?!?!

Thanks,
Evan

P.S. Im a newbie to the whole server thing... sorry.

[kode]

Is mysql server started?

ps -A | grep mysql

[deek]

Yeah, that would be my guess too. I was just messing around with mysql last night, so I was very familiar with that error.

Make sure you start your server. I was using:

> mysqld_safe --user='user-name' &

That started it up and then I would do:

> mysql -u 'user-name' -p

To get into it. After you do that you should get the mysql> prompt.

And just like code said, you can check your processes to see if you see the server running. When I would do a ps, I would see about 8-10 mysql processes.

[evix]

bash-3.00# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/r
ql/mysql.sock' (2)
bash-3.00#

bash-3.00# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/EviX.pid
050331 14:08:47 mysqld ended

bash-3.00#
I even get this message after I boot, before I login...

Thanks,
Evan

[deek]

Try this:

bash-3.00# mysqld_safe --user=root &

This should start the server. Then you can do:

bash-3.00# ps

You should see several mysql processes.

Then you can use the mysql command to login to the server.

[evix]

bash-3.00# mysqld_safe --user=root &
[1] 7170
bash-3.00# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/EviX.pid
050331 14:32:59 mysqld ended


[1]+ Done mysqld_safe --user=root
bash-3.00# ps
PID TTY TIME CMD
7045 pts/1 00:00:00 bash
7202 pts/1 00:00:00 ps
bash-3.00#

[daikatana_]

I guess I know what your problem is...

First you have to install database... It's easy:

su mysql
mysql_install_db