Mark Seven Smith wrote:
When I boot my computer, there is a message in the boot messages:
Starting mysql services failed
You don't have to bother about that. I don't remember the details but I think it has got something to do with the program MySQL Client which isn't started at boot, but MySQL Server and ~ Daemon works.
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.
Hmm, that is another thing. I had the same problem myself a while ago but I don't remember how I fixed it. If I'm not totally mistaken I think I uninstalled MySQL with YaST, erased the folder mysql in /var/lib/ and then installed MySQL with YaST again. /Lars
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