SuSED 9.0, MySQL and YAST
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 this 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 that 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/
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" <pampaluz@cox.net> To: <suse-linux-e@suse.com> Sent: Saturday, April 03, 2004 10:53 AM Subject: [SLE] SuSED 9.0, MySQL and YAST this that
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
Mark Seven Smith wrote:
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 this 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.
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 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. If you want a graphical UI for working with MySQL I think phpMyAdmin is a good choise. /Lars
I don't even understand what MySQL is supposed t
o 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 that 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
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
On Saturday 03 April 2004 04:21 pm, Mark Seven Smith wrote:
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.
Are you running any kind of firewall on your computer? If so, you might need to adjust your firewall's rules so that it doesn't block access to the port that MySQL is trying to use (by default, TCP 3306). If the book you bought has a troubleshooting section, perhaps you should read through that to see if it can help you determine what the problem is. If it doesn't have such a section, try checking out the "Starting and Troubleshooting the MySQL Server" page at mysql.com, http://www.mysql.com/doc/en/Starting_server.html -- Mark McKibben http://www.vision-at-work.org/~manzabar/ "We are bits of stellar matter that got cold by accident, bits of a star gone wrong." - Sir Arthur Eddington
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
participants (4)
-
Lars Norén -
Manzabar -
Mark Seven Smith -
Radu Voicu