Hi everyone. So i got the problem with setting mysql server on bt3. Here is the konsole error output:

Code:
bt ~ # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

bt local # /usr/local/bin/mysqld_safe &
[2] 3815
bt local # 080319 17:10:29 mysqld_safe Logging to '/usr/local/var/bt.err'.
080319 17:10:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
080319 17:10:29 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended

bt ~ # /usr/local/bin/mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
Enter current password for root (enter for none):

bt mysql-test # perl mysql-test-run.pl
Logging: mysql-test-run.pl
080319 17:11:04 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

080319 17:11:04 [ERROR] Aborting

mysql-test-run: *** ERROR: Could not find version of MySQL
Output from error log file:

Code:
080317 03:10:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
080317  3:10:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
080317  3:10:57 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
080317  3:10:57 [ERROR] Can't start server: can't create PID file: Permission denied
080317 03:10:57 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
080319 02:50:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
080319  2:50:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
080319  2:50:55 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
080319  2:50:55 [ERROR] Can't start server: can't create PID file: Permission denied
080319 02:50:55 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
080319 17:10:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
080319 17:10:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
080319 17:10:29 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
080319 17:10:29 [ERROR] Can't start server: can't create PID file: Permission denied
080319 17:10:29 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
Another from konsole:

Code:
bt ~ # mysql_upgrade
Looking for 'mysql' in: /usr/local/bin/mysql
Looking for 'mysqlcheck' in: /usr/local/bin/mysqlcheck
Running 'mysqlcheck'...
/usr/local/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
FATAL ERROR: Upgrade failed


bt ~ # mysqladmin --socket=/tmp/mysql.sock 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! ( yeah, it exists ;/ )
i was trying all stuff from mysql official site, setting chmods, chown, editing socket path in my.cnf and i am outta ideas now how to set it to work
Can anyone tell me what is wrong with it?
Btw, i'm totaly new to setting mysql server, never done it before...