Install mySQL

[dcubox1]

What is the easiest way to install mySQl to allow me look at the database tables?

[jimbodude]

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 Expand


mysql -u root


To see the databases:

Code Select Expand


show databases;


To use a database:

Code Select Expand


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 Expand


sudo apt-get install mysql-query-browser


Run it from the KDE desktop or with terminal command"

Code Select Expand


mysql-query-browser


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

[dcubox1]

The other option is MySQL Query browser - a graphical interface.  To get it:

Code Select Expand


sudo apt-get install mysql-query-browser


Run it from the KDE desktop or with terminal command"

Code Select Expand


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.