Hi everyone
Im a novice user of linux, I just installed ubuntu 7.4 on my PC and everyone told me to use Amarok. They also told me that using SQLite  will very slow and that i should go with the MYSQL option. I found the following instructions in a web page but can't seem to follow them since it is my first time using a terminal. Can anyone help:

    sudo apt-get install mysql-server mysql-client  (I did this part with no problem)


now this (replace PASSWORD with your password)

    mysqladmin -u root password PASSWORD

( This part does not work, i get the following >
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!  )

then this (Is this supposed to go in the terminal as one line or were or how???)

    mysql -p -u root
    CREATE DATABASE amarok;
    USE mysql;
    GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY 'PASSWORD_CHANGE_ME';
    FLUSH PRIVILEGES;


In Amarok, go to settings> configure Amarok
Click Collection

Select MySQL.

Use the following settings:

    Hostname: 127.0.0.1
    Database: amarok
    Port: 3306
    Username: amarok
    Password: Your Password

You're done! Enjoy the speediness!

whoever told you sqlite was significantly slower than mysql may well have been pushing a personal agenda

unless you have a LOT of tracks (like over 30k) there's nothing wrong with sqlite at all. You might as well save yourself the hassle unless you *really* want to learn more.
Your main problem is probably that mysqld (the resident mysql daemon) is not running. Check your distro's docs for how to launch the daemon using init scripts.

have you tired doing:

sudo /etc/init.d/mysql start

to start your svr?