On Saturday 03 April 2004 06:25, Lars Norén typed:
Mark Seven Smith wrote:
I want to use MySQL, but I have never used anything like this before.
[SNIP]
If MySQL is installed it ought to be enough just starting MySQL in 'YaST - System - Editor for runlevels', then you can follow chapter 3 in the main MySQL manual and start working with MySQL instead of installing it:
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html
When I boot my computer, there is a message in the boot messages: Starting mysql services failed The above is in RED text. Also, I get a socket problem: "cannot connect to sock <something I forget>" and then it bombs--no console monitor for MySQL.
I myself try to learn something about MySQL + PHP, primarily for fun and interest, but also for being able to build a database driven website (or making an ordinary, static, website database driven to some extent), and I think chapter 3 in the main MySQL manual gives you a very good start, with references to other things in the manual important to know. Follow it, chapter 3, step by step. It's a very good start.
It does sound like it will be OK once I figure out what's up with that socket problem, and why the "FAILED" error when the system boots. I did go into YAST and enable the MySQL in the Runlevel area of "System" in YAST.
If you want a graphical UI for working with MySQL I think phpMyAdmin is a good choise.
I will probably go with the PDF document that shows you how to interface MySQL with OpenOffice.org; but thanks for pointing out phpMyAdmin because I had never heard of it before. Also: how does ODBC fit into the MySQL picture? In the Tutorial book that I bought, and in the HOWTO for setting up MySQL for setting up a database system in OpenOffice.org, they all recommend that I remove previous installations of MySQL, and download the latest sources from www.mysql.com and install MySQl "the standard way", so that when the Tutorial talks about the directories and scripts, everything will be where it should be. In SuSE 9.0, NOTHING is where it should be for MySQL! Very weird arrangement; I don't know if even half of the scripts mentioned at MySQL site's manual are available in the SuSE 9.0 installation--I tried to find them, and I tried to "locate <file>", and yet I couldn't find any of them (if they're there, they have been renamed). Anyway, thanks... --Mark Seven Smith pampaluz (at) cox.net