How to setup mysql database in Ubuntu/Mint

Lino

Lino

I am back
Joined
Jan 26, 2008
Messages
13,785
Reaction score
56
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?
 
ubuntu repos are local.

sudo apt-get install [mysql]

where [mysql] is the various packages starting with "mysql".
 
Moederloos said:
ubuntu repos are local.

sudo apt-get install [mysql]

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

Thanks man, any idea on how to configure it and create a new database?
 
Linoman said:
Thanks man, any idea on how to configure it and create a new database?
Click to expand...

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.
 
Moederloos said:
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.
Click to expand...

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:
 
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.
 
"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!)
 
froot said:
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.
Click to expand...

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:
 
Linoman said:
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:
Click to expand...

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. :)
 
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!
 
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.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X