I want to use MySQL, but I have never used anything like this before.
I even went out and bought a book called "MySQL Tutorial" (published just
year).
The problem is, I cannot follow along with the HOWTO, nor the free MySQL book at O'Reilly, nor my tutorial book, nor the main MySQL manual at www.mysql.com, because SuSE 9.0 uses YAST to install and configure MySQL; and none of the files are in the right place, and none of the scripts are where they should be (if there are any scripts at all!) And if I try to follow along with the instructions, nothing works out right, because of the YAST problem.
I don't even understand what MySQL is supposed to look like when it is finally up and running. I installed everything I could find in YAST (as per someone's advice); and I also went into YAST's "System - Runlevel Editor" and then Enabled MySQL. However, this didn't work; all I get now, is a message when my machine boots, that says "starting mysql services failed" in red text.
There is a socket error when I try to run any of the beginning commands
OK, let's take it one at the time.
1. Use yast to uninstall mysql then re-install it again (in order to have a
clean install)
2. to start/stop mysql when the system starts, type the command:
chkconfig -s mysql on
3. to start/stop mysql when you need it:
rcmysql start
rcmysql stop
etc
4. the /etc/my.cnf is maybe what you are looking for
5. the script for start/stop etc is located at /etc/init.d/mysql
6. mysql and all its directories lies on /var/lib/mysql
7. you can also use yast to install phpMyAdmin (a nice webinterface for
mysql)
P.S. Why do you need Yast for mysql??? :))
----- Original Message -----
From: "Mark Seven Smith"
they have you run in the book and in the manual (cannot connect to socket / var/mysql/sock" something like that; I lost the message.
I have tried to find the answer on Google, but nobody seems to be using MySQl with SuSE 9.0. Can anyone help? Is there anywhere that SuSE tells how to make MySQl work under SuSE? What is different about the SuSE implementation of MySQL from the "standard installation"?
Thanks,
--Mark Seven Smith pampaluz (at) cox.net
-- "A warrior must love this world, in order for this world that seems so commonplace to open up and show its wonders." -- Don Juan Matus, "The Wheel of Time" by Carlos Castaneda ------ Mark Seven Smith -- pampaluz@cox.net -- AIM & /. == Pampaluz Free Software Foundation (www.gnu.org) Member #1372 Pampaluz Linux Counter #122264 - http://counter.li.org/
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com