MySQL db on Suse 9.2

[TheMagicM]

I guess I'm confused as to where to start.. I want to setup a db on my comp and mess with different things like querying it via C/Java and various other things.  I dont know where to really start other then I know I have a few mysql items on my system installed but not the actual db server itself I dont think.

-Alex

[Waccoon]

Using MySQL is a snap, but setting it up isn't.  I'd check to see if MySQL Control Center is on your computer, and if not, get it here:  http://www.mysql.com/products/mysqlcc/

One nice thing about it is that when you change tables and stuff, it will print out the code needed to create the content, making it a lot easier to learn how the database syntax works.  You can also just cut-and-paste the generated code into your applications.

I use the Win32 version of MySQL, though, which auto-installs it as a service.  I know nothing about initializing if from the command line.

[TheMagicM]

mysqlcc is installed.. .I guess my problem is that when I do 'mysql start'  it starts then exits..otherwise I'd pretty much be able to figure everything else out.

in the meantime I did get SQLite 3 working..  it has C commands to access a database you create with it.. creates a db in a single file.. pretty interesting.

-Alex