Curtis Seyfried 2 wrote:
Yes, Linux RH9 2.4.08 When I run the /opt/lampp/lampp start command, Apache starts, SSL, starts and another service, mysql seems to start. But when I try to connect to mysql with admin or cc or other tools, so I can setup databases and tables, it tells me mysql is not running.
That is suppposed to do it. I assume by "mysql seems to start" that no error is given. The Xampp docs <http://www.apachefriends.org/en/xampp-linux.html> say that normal output is
Starting XAMPP 1.4.5... LAMPP: Starting Apache... LAMPP: Starting MySQL... LAMPP started.
Is that what you got?
Then I issue /opt/lampp/bin/mysql start to get mysql to start and this is when I get the can not connect to mysql.sock
/opt/lampp/bin/mysql is the mysql client. This command tells the client to connect to the server and work in the database named start. The server doesn't seem to be running, so you get this error. If the server were running, I'd expect to see the error
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'start'
because there is no db named "start".
Michael, OK, what you said makes sense, but I thought I WAS starting the
mysql SERVER. I did not realize I was inadvertently starting the client. I have never had to manually start mysql before. In win2k pro it is
installed as a Service, which I can set to manual and start when I
want. So I was starting Apache, then mysql as services.
So now I ran /opt/lampp/bin/mysqld
The /opt/lampp/lampp script takes other commands besides start. To just start mysql, you use `/opt/lampp/lampp startmysql`.
Got NO file or directory. Went into bin directory and found there is NO mysqld, but there is a mysql.server, so I ran /opt/lampp/bin/mysql.server and then I get this error message.
.Starting mysqld daemon with databases from /opt/lampp/var/mysql 040614 14:57:40 mysqld ended
OK, so mysqld started and then immediately stopped. This is usually a problem with either permissions or configuration. Assuming you haven't changed the configuration supplied by Xampp, I'd guess permissions. The data directory, /opt/lampp/var/mysql, has to be owned by the user running mysqld. This is usually user mysql, but it looks like Xampp uses user nobody.
Look in /opt/lampp/var/mysql for a file named hostname.err, where "hostname" is the name of your machine. It should contain the error message associated with mysqld quitting.
That was after I tried it and got the following because I had created a directory called /mysql.sock thinking before it needed this directory. then I got this error, so I REMOVED the directory.
.Starting mysqld daemon with databases from /opt/lampp/var/mysql rm: cannot remove `/opt/lampp/var/mysql/mysql.sock': Is a directory 040614 14:56:50 mysqld ended
mysql.sock is a unix socket file created by mysqld while it is running. It is a special file which enables localhost connections to the server (via unix socket rather than tcp/ip). You cannot create it by hand. It will be there if mysqld is running, and should dissappear when mysqld is not. In this case, you put a directory where the socket should go, so mysqld couldn't create it.
So, HOW does Xampp Normally start mysql, when I issue the /opt/lampp/lampp start command ?
I've never worked with Xampp, so I can't be sure, but I expect it calls another script, possibly the /opt/lampp/bin/mysql.server script you found.
Since it isn't HOW do I Start mysql so I can finally get it to work.
I think you are starting mysql correctly by using `lampp start`, but something is keeping mysql server from starting. Take a look at hostname.err and see what it says. Post the contents here if they aren't clear to you.
My O/S is Linux RH9 2.4.08 complete custom install with ALL packages and features.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
