Annoyingly thorough and detailed inquiry re implementing mySQL (from someone who has no idea what he's doing):

Have been doing a lot of homework trying to get mySQL going.  Have been pouring over the following set of instructions:

http://www.debuntu.org/how-to-create-a- ... -to-a-user

I have copied all the commands so that I can simply paste them into the terminal, one at a time, of course. (yes, it took me a while to figure out that I can paste into the terminal using shift-ctrl-v.)

I would be really grateful if someone could take a look at these commands, maybe answer a few queries, to make sure that I am getting everything right.... thanks!

database name: amarokdb2
username: will
password: tirinrocks

(since I already may have created a database named "amarokdb" which may be all screwed up, should I call this new database "amarokdb2" or something like that?)

(I know we're not supposed to put an actual password on a forum - but the only time this particular password is used is internally, as a means of connecting Amarok to mySQL - so it really does no harm to post it here, I would imagine...)

$ ./configure --enable-mysql

$ mysql -u root

$ mysql -u root -p
Enter password:

Question: I actually enter the password (tirinrocks) at this point? & hit return, right?

mysql> create database amarokdb2;
Query OK, 1 row affected (0.00 sec)

mysql> grant usage on *.* to amarokuser@localhost identified by 'amarokpasswd';
Query OK, 0 rows affected (0.00 sec)

question: I leave "*.*" like it is - I don't put in the name of the database (amarokdb2) ?
also - do I change amarokuser@localhost to my actual name (will).
and do I change 'amarokpasswd'  to the actual password itself.

mysql> grant all privileges on amarokdb.* to amarokuser@localhost ;
Query OK, 0 rows affected (0.00 sec)

redundant question - as above, should amarokuser@localhost be my actual name (will) in this case?

and this is the last set of commands... same questions apply, but hopefully by now I will know the answers...

$ mysql -u amarokuser -p'amarokpasswd' amarokdb
Your MySQL connection id is 12
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

according to the debuntu.org page, that should be it!  It should only be so simple.

thanks!

willfriedwald