local mysql server

[stuffradio]

Hey, I am getting an error when I try and start mysql. The error is,

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

I had done something with the tutorial found here:
http://www.howtoforge.com/perfect_setup_ubuntu_5.10

One of those pages I had to move some files and I think that's what's causing the problem. And there are no files in /var/run/mysqld/ please help me.

[jocke1s]

http://www.apachefriends.org/en/xampp-linux.html

[stuffradio]

... that doesn't fix my problem, haha. That just gives me some other piece of software, I need mysql fixed not apache.

[paddyg]

If there is no mysqld.sock, this means the MySQL server is not running.

Just take a look at the socket line in /etc/mysql/my.cnf, which tells you where the socket file must be. Just check out, if there is no socket file the server is not running.

[stuffradio]

is there a way I can make a mysqld.sock file, or should I reinstall mysql

[paddyg]

Just try and start the server, and it should make both mysqld.pid and mysqld.sock in /var/run/mysqld. To do that, just invoke the script mysqld_safe in /usr/bin.
Good luck.

[stuffradio]

That still doesn't fix it :'(

[paddyg]

What do you mean---
1. the server isn't running and you can't start it?
2. the server is running and you can't find mysqld.sock?

As for
1. If /usr/bin/mysqld_safe doesn't start the server, in terminal (a very uncommon method, though) type

sudo mysqld

Or just check out System-->Administration-->Services and tick off the Database server (mysql) entry.

2. What does the [mysqld] section in /ect/mysql/my.cnf read?

[stuffradio]

that's another thing, in that install it doesn't install the gui for like gnome, etc. so I am stuck in command line and when i type start x it says: "bash: start: command not found and when I type startx it says:
/etc/X11/xinit/xerverrc: line 2: /urs/bin/X11/X: No such file or directory
/etc/X11/xinit/xserverrc: line 2: exec: /urs/bin/X11/X: cannot execute: No such file or directory

Also for mysql there might be a process running on port 3306 but don't know how to find out and kill it.

[paddyg]

You can use the following to learn about processes

ps -A

And you should look for mysqld among them.
If you want to kill a process

sudo kill processPID