bjoernvold.com

Posted: **21 Mar 2010, 20:51**

I'm wondering if anyone knows a simple way to create a music db in MySQL? This would be for Amarok2, which at this point is crashing all over the place on me anyway... sigh.

Thanks.

Posted: **21 Mar 2010, 21:50**

Not being mysql-literate, I am wondering what i'm doing wrong:

Code: Select all

# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password for root@localhost = password xxxxxxx
    -> flush privileges;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxx
flush privileges' at line 1
mysql> quit;
Bye
[root@dedanna dedanna]# mysql -p -u root
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Thanks.

Posted: **21 Mar 2010, 22:21**

Ah You have trouble with speaking with Mysql if I read this right. It should be no problem to create a music.db You might want to use phpmyadmin for that.

You want to set the root user for mysql (It has nothing to do with your Linux root). Here is a way to do it:

Code: Select all

/usr/bin/mysql_secure_installation

Since you have installed a lot already it might be a good idea to remove the old config files

Code: Select all

rm -f /var/lib/mysql/mysql/*

And install mysql from scratch. That way you do not drag old configs that you do not remember anymore with you.

Posted: **22 Mar 2010, 01:26**

I will certainly save that for future use, thank you.

Ah, but isn't that for an rpm-based distribution?

I say future use, because the drive that I installed Arch to just died on me.

I have another drive that I can use to reinstall, but all my time's been taken this weekend; need to get ready to go back to work tomorrow. :\

Posted: **22 Mar 2010, 02:01**

Computer life can be frustrating.

And yes those are rpm commands. Just the habit I guess (I have edited it). :oops:

Remove the config files before reinstalling is my point.

Posted: **22 Mar 2010, 03:17**

Okay, got it. Thanks!

bjoernvold.com

MySQL music db

MySQL music db

Re: MySQL music db

Re: MySQL music db

Re: MySQL music db

Re: MySQL music db

Re: MySQL music db