Author Topic: Install mySQL  (Read 2659 times)

dcubox1

  • Veteran
  • ***
  • Posts: 130
    • View Profile
Install mySQL
« on: April 14, 2010, 03:03:53 pm »
What is the easiest way to install mySQl to allow me look at the database tables?

jimbodude

  • Guru
  • ****
  • Posts: 372
    • View Profile
Re: Install mySQL
« Reply #1 on: April 14, 2010, 04:20:52 pm »
DO NOT DIRECTLY EDIT THE DATABASES UNLESS YOU KNOW WHAT YOU ARE DOING!

Look all you want, just don't touch.

...I'm assuming you've already installed LinuxMCE?  If that's the case, you already have one option.

To log in, execute:
Code: [Select]
mysql -u root

To see the databases:
Code: [Select]
show databases;

To use a database:
Code: [Select]
use {database name here}

Then you can do SQL from there.


The other option is MySQL Query browser - a graphical interface.  To get it:
Code: [Select]
sudo apt-get install mysql-query-browser

Run it from the KDE desktop or with terminal command"
Code: [Select]
mysql-query-browser

In both cases, you will probably need to collect some knowledge about how SQL databases work.

dcubox1

  • Veteran
  • ***
  • Posts: 130
    • View Profile
Re: Install mySQL
« Reply #2 on: April 14, 2010, 05:11:37 pm »
The other option is MySQL Query browser - a graphical interface.  To get it:
Code: [Select]
sudo apt-get install mysql-query-browser

Run it from the KDE desktop or with terminal command"
Code: [Select]
mysql-query-browser

In both cases, you will probably need to collect some knowledge about how SQL databases work.

Thanks for this, I work with SQL databases every day, I know the implications of messing around with them. Cheers for the info.