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

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

Post by Victoria Reznichen » Thu, 25 Mar 2004 02:04:23




> 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?

Look into MySQL data dir and check if privilege tables exist. If no, run mysql_install_db script.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko

/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com

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

 
 
 

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

Post by Odom, Duwayn » Thu, 25 Mar 2004 06:34:33


You need to install the default databases.
-----Original Message-----

Sent: Tuesday, March 23, 2004 11:32 AM


Subject: Re: Can't Start Deamon - Installed MySQL 4.0.15 using YaST (
SuSE 9.0 Pro)

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.host' 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

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =

The information contained in this e-mail message may be privileged, =
confidential, and protected from disclosure.  If you are not the =
intended recipient, any further disclosure, use, dissemination, =
distribution, or copying of this message or any attachment is strictly =
prohibited.  Unauthorized interception or disclosure of this e-mail =
violates federal criminal law.  If you think that you have received this =
e-mail message in error, please delete it and notify the sender =
immediately.

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



 
 
 

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

Ye That Know,

Short:  Does YaST really install MySQL 'all-the-way', or do I now need to =
run 'make' and/or 'make install', or other similar commands?

Long:

Previously <last week> I had installed MySQL using rpm as detailed in a =
SAMS book http://tinyurl.com/2pq27

It installed fine and worked ok - I connected, made a few tiny test DBs, =
etc

=97----------

I was having trouble with PHP and decided to reinstall everything using =
YaST

I installed the latest versions of:
flex
mysql
apache
php

In that order.
=97--

Now when I type 'mysql' I get: "ERROR 2002: Can't connect to local MySQL =
server through socket '/var/lib/mysql/mysql.sock"

When I type 'mysqld' I get: "Fatal Error: Please read "Security" section =
of the manual to find out how to run mysql as root!"

(I'm root)

I did look at the manual but didn't see specific root instructions.  I =
also logged in as a non-root user and retried. It said the command was not =
found, which is odd because it is in /usr/sbin and is executable.

=97-

Above I asked if YaST installs MySQL all-the-way because the directory =
'mysql' is missing from /usr/local.

Perhaps that is simply an install location difference between rpm and =
YaST.

---=20

What do you guys think?  I'm considering uninstalling MySQL with YaST and =
reinstalling with rpm.

TIA,

   -:>Kevin

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

2. European CADJOBS.nl launches pilot version for USA: CADJOBS.us

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

4. dns active directory needs to be periodically restarted.......

5. DISREGARD - MySQL 4.0.15 on SuSE 9.0 Pro - how do I uninstall ?

6. PF474 chips and variant lists

7. MySQL 4.0.15 on SuSE 9.0 Pro - how do I uninstall ?

8. acl lists-deny streaming

9. MySQL installation with SuSE Linux 9.0 and YaST

10. Configuring SuSE Pro 9.0, MySQL 4.0.18 with ssl

11. Installation issue on SuSE 9.0 Pro box

12. FW: Installation issue on SuSE 9.0 Pro box

13. Can't install Mysql 4.0.15 on Redhat AS Beta 2