How to setup mysql database in Ubuntu/Mint

[Lino]

Hey guys, I am busy setting up my Minted Ubuntu System. Anyway I want to setup a mysql database for Amarok. However since I am capped:confused::confused: at the moment how on earth do I do it?

[Moederloos]

ubuntu repos are local.

sudo apt-get install [mysql]

where [mysql] is the various packages starting with "mysql".

[Lino]

ubuntu repos are local.

sudo apt-get install [mysql]

where [mysql] is the various packages starting with "mysql".

Thanks man, any idea on how to configure it and create a new database?

[Moederloos]

Thanks man, any idea on how to configure it and create a new database?

Amarok should do it for you.
You *may* need to remove amarok and reinstall after installing mysql

sudo apt-get remove amarok
sudo apt-get install amarok

no idea though.

[Lino]

Amarok should do it for you.
You *may* need to remove amarok and reinstall after installing mysql

sudo apt-get remove amarok
sudo apt-get install amarok

no idea though.

Nope Amarok sets up a SQlite by default. I always setup a mysql database and then enter the settings into Amarok. Of cause for the life of me can't remember how to setup a mysql database:eek:

[.Froot.]

go to Synaptic or adept and install phpmyadmin. This is a graphical mysql frontend that you run off localhost (or any server for that matter, depending on where your mysql database is) and you can create databases the easy way.

[Moederloos]

"Setting up a database" is such a broad subject though.

I use mysql-admin for "complex" database stuff, and mysql command line for the "simple" stuff. (With "complex" and "simple" being purely subjective!)

[Lino]

go to Synaptic or adept and install phpmyadmin. This is a graphical mysql frontend that you run off localhost (or any server for that matter, depending on where your mysql database is) and you can create databases the easy way.

I did that, time for dumb question of the year! How do I access it, cause when I type in 10.0.2 I get my routers config:eek:

[Tux]

Localhost = 127.0.0.1

[Lino]

Localhost = 127.0.0.1

Thanks

Now I get a big sign that says " It works!" WTF do I do now~

[.Froot.]

I did that, time for dumb question of the year! How do I access it, cause when I type in 10.0.2 I get my routers config:eek:

No worries. phpmyadmin is a "php site" hosted in your "localhost", so here is the address:
http://localhost/phpmyadmin/index.php

No need to feel stupid either, if no one told me (or didn't read the instructions, etc), I wouldn't know either.

Remember to set up if not done yet, or to type in your mysql username and password when asked to at phpmyadmin. Don't forget it either. I did it once and was a really really big mess to clean up. :)

[Lino]

Froot thank you so much, I managed to setup a database for Amarok. So now everything works correctly. (Although I must admit took me a while to figure out that the username was root)..

Thanks to everyone for their help!

[.Froot.]

Lol. If you don't know, ask. With a large music collection mysql allows Amarok to go a lot faster. Just make backups of your database every now and then.

[Lino]

Thats true, will do thanks again

[ghoti]

https://help.ubuntu.com/community/ApacheMySQLPHP

[Lino]

https://help.ubuntu.com/community/ApacheMySQLPHP

Thanks bro, will look at it once I have cap again. ;)

[ghoti]

temp local mirror for you:
http://www.newz.co.za/ApacheMySQLPHP.html

[Lino]

temp local mirror for you:
http://www.newz.co.za/ApacheMySQLPHP.html

Thank you:)

Happy to report Amarok is working nicely now running on Mysql