Can't run the mysql deamon on linux

Can't run the mysql deamon on linux

Post by apprenticeJ.. » Wed, 29 Aug 2001 14:37:40



Quote:>Description:

   Can't run the mysql deamon at all. When I try running safe_mysqld (with root permission) i get the following message

Starting mysqld daemon with databases from /var/lib/mysql
010828 15:18:22  mysqld ended

When I attempt this as not the root user, I get permission problems.

The /var/log/mysql.log has the following line added:

010828 15:18:22  mysqld started
010828 15:18:22  /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
010828 15:18:22  mysqld ended

I am using Redhat linux. I freshly installed it (I've installed *nothing* else). I got the same problem when I initialized the partition, and installed debian, and installed mysql from the source code.

I have tried different versions and distributions of Linux. Different kernals. Different mysqls. There is no HOWTO page with this error -- how does anybody else get the thing to go?

Quote:>How-To-Repeat:

        Install RedHat 7.1, with MySQL installed. Type:
                su root
                'password'
                mysql_install_db
                safe_mysqld &

If you think it has something to do with RedHat... Initialize the hardisk. Install Debian (potato), with mysql
        Get the mysql tar.gz file and type (as root):
        gunzip mysql.tar.gz
        tar xf mysql.tar
        cd into the directory
        ./configure --prefix=/path/to/installation
        make
        make install
        locate mysql_install_db and run ./mysql_install_db
        safe_mysqld

and... SAME PROBLEM!!!

Quote:>Fix:

        blah

Quote:>Submitter-Id:       <submitter ID>
>Originator: Aaron Michaux
>Organization:

 University of Queensland

Quote:>MySQL support: none
>Synopsis:   Can't get it to go... problem with installation
>Severity:   critical
>Priority:   more your problem
>Category:   mysql
>Class:              doc-bug
>Release:    mysql-3.23.36 (Source distribution)
>Environment:

        Pentium 933, 256Mb RAM 80Gb Hard disk
        Redhat Linux 7.1

System: Linux tea933 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 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.1 2.96-81)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686'  CXX='c++'  CXXFLAGS='-O2 -march=i386 -mcpu=i686'  LDFLAGS=''
LIBC:
lrwxrwxrwx    1 root     root           13 Aug  9 06:12 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x    2 root     root      1236396 Apr  7 07:58 /lib/libc-2.2.2.so
-rw-r--r--    1 root     root     26350254 Apr  7 05:27 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 Apr  7 05:27 /usr/lib/libc.so
lrwxrwxrwx    1 root     root           10 Aug  9 06:33 /usr/lib/libc-client.a -> c-client.a
Configure command: ./configure  i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-berkeley-db

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

Can't run the mysql deamon on linux

Post by Neil Zanel » Wed, 29 Aug 2001 14:49:09


RedHat 7.1 users:

The command used to start mysqld on this platform is simply (as root):

# /etc/init.d/mysqld start

This is _all_ that is required.

Once that works you can set
the mysql root user's password
with mysqladmin if you are
concerned about security
on your intranet.

Neil

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

Can't run the mysql deamon on linux

Post by Grigory Bakun » Wed, 29 Aug 2001 15:53:41


Date |Tue, 28 Aug 2001 03:16:59 -0230 (NDT)

Hello!

NZ> RedHat 7.1 users:

NZ> The command used to start mysqld on this platform is simply (as root):

NZ> # /etc/init.d/mysqld start

NZ> This is _all_ that is required.

NZ> Once that works you can set
NZ> the mysql root user's password
NZ> with mysqladmin if you are
NZ> concerned about security
NZ> on your intranet.

NZ> Neil
You can also read more about post-installation procedures here:

http://www.mysql.com/doc/P/o/Post-installation.html

___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___     ___ ____  __

 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

1. Can't Start Deamon - Installed MySQL 4.0.15 using YaST (

James,

I try to start it at the command line using - mysql, mysqld, mysqld_safe - =
I've tried it as root and non-root.

Yes, I get errors - they were listed in my origional post - I don't have =
then handy now.

-----------------

I tired mysqld_safe, as you suggested, it bombed but the good thing is it =
wrote to the mysqld.log.

Here's what it said:

040323 11:14:34  mysqld started
040323 11:14:37  InnoDB: Started
040323 11:14:37  Fatal error: Can't open privilege tables: Table 'mysql.hos=
t' doesn't exist
040323 11:14:37  Aborting

040323 11:14:37  InnoDB: Starting shutdown...
040323 11:14:40  InnoDB: Shutdown completed
040323 11:14:40  /usr/sbin/mysqld-max: Shutdown Complete

040323 11:14:40  mysqld ended

---------------

What do you think?

   -:>Kevin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

2. hal 2000

3. Can't Start Deamon - Installed MySQL 4.0.15 using YaST ( SuSE 9.0 Pro)

4. Max Memory and Available Memory

5. Can't Start Deamon - Installed MySQL 4.0.15 using YaST (SuSE

6. DCFORMAT v.2.21

7. MySQL + PHP : 'Commands out of sync; You can't run this command now'

8. Removing events from input queue

9. running mysql 3.23 and mysql 4.0 on same linux/suse box

10. 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux

11. MySQL Client on Linux won't connect to MySQL Server on XP

12. Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server