---------- Forwarded Message ----------
Subject: I cannot get mysql to run.
Date: Thu, 15 Aug 2002 11:02:08 +0100
From: Barry Schofield <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [I have tried rpm's and 4.0 version and your
3.23.51-pc-linux-gnu-i686.tar.gz and I cannot get anything to run. I am even
following the instructions in appendix A of isbn 0-672-31784-2 SAMS php and
mysql web development.
]
>Description:
<[root@localhost mysql]# ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[root@localhost mysql]#
I have checked this and the socks in this directory says 0 bytes.
>How-To-Repeat:
<./bin/mysqladmin version>
>Fix:
<unable to get round the problem>
>Submitter-Id: <submitter ID>
>Originator: root on Redhat 7.3 [EMAIL PROTECTED]
>Organization:
<Barry Schofield Lion Communications>
>MySQL support: [ email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ critical ]>
>Priority: <[ high ]>
>Category: mysql
>Class: <[ support ] >
>Release: mysql-3.23.51 (Source distribution)
>
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc'
CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Aug 5 18:03 /lib/libc.so.6 ->
libc-2.2.5.so
-rwxr-xr-x 1 root root 1260480 Apr 15 14:44 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 Apr 15 15:02 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 15 14:55 /usr/lib/libc.so
Configure command: ./configure --enable-assembler
--with-other-libc=/usr/local/mysql 'CFLAGS=-O2 -mcpu=pentiumpro'
'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static
Overall:
I have tried rpm's and 4.0 version and your 3.23.51-pc-linux-gnu-i686.tar.gz
and I cannot get anything to run. I am even following the instructions in
appendix A of isbn 0-672-31784-2 SAMS php and mysql web development.
[root@localhost mysql]# ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[root@localhost mysql]#
I have checked this and the socks in this directory says 0 bytes.
report from : localhost localdomain.err
020815 10:29:46 mysqld started
020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't create/write to file
'/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13)
020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020815 10:29:46 /usr/local/mysql/bin/mysqld: Error on delete of
'/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13)
020815 10:29:46 mysqld ended
mysql-3.23.51-pc-linux-gnu-i686/configure
[root@localhost local]# cd mysql
[root@localhost mysql]# ./configure --prefix=/usr/local/mysql
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
020815 10:29:46 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root -p password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; run-all-tests
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@localhost mysql]# Starting mysqld daemon with databases from
/usr/local/mysql/data
020815 10:29:46 mysqld ended
[root@localhost mysql]# ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[root@localhost mysql]#
-------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
