Re: [PLUG] Help needed with MySql database

[tom panzarella <tpanzarella@acm.org>]

I am not familiar with the RPM version of MySQL (or really where the
rpm version puts things) but 2 things that come to mind that you could 
check are:

1- Did you run the 'mysql_install_db' script after you installed the
server? This script creates the MySQL 'mysql' database as well as the
'test' database as well as creates the 'root' user.  Maybe MySQL is
not starting for you because those databases (well really just the
'mysql' db) is not there.  You can check if the db is there manually
by looking at your filesystem.  Below you indicate that the RPM has
set up your system to install the databases in /var/lib/mysql ... so
if the mysql db is installed you should have a directory called
'mysql' in that dir (so /var/lib/mysql/mysql).

2- Check the mysql config file (wherever it is located with the RPM
version).  What user is mysql supposed to start as?  Typically (at
least in my experience) people run mysqld as 'mysql'.  Did you create
the 'mysql' user and group?   You can override what mysqld runs as by
adding the --user=<some user on your system> flag to the safe_mysqld script.

Maybe that will help. Good luck.

t.

On Thu, 7 Jun 2001, John Beck wrote:

> 
> 
> > Hi.
> >
> > I'm not running RH7.1 but see if this helps:
> >
> > if there is a file called /etc/rc.d/init.d/mysqld
> >
> > try: /etc/rc.d/init.d/mysql start
> >
> 
> Yes, there is that file, however when I run the command you suggest, I just
> get a command not found error...  Any other suggestions would be great!
> 
> Here is where I stand so far...
> 
> When typing service mysql start I get the message:
> bash: service: command not found
> 
> When trying to start the mysql daemon from the /usr/bin/safe_mysqld &
> command, as the manual indicates, I get a message saying:
> Starting mysqld daemon with databases from /var/lib/mysql
> 010607 15:12:08 mysqld ended
> 
> This is where I get hung up, with the cursor just sitting after the 'mysqld
> ended' message. It will sit here for hours, unless I intervene. If I just
> press the enter key once, I get the following message:
> [1]+ Done      /user/bin/safe_mysqld
> 
> Then, if I start the mysqladmin tool, and use the 'ping' parameter, which
> according to the manual will tell that mysql is alive, I get:
> mysqladmin: connect to server at localhost failed
> error: 'Can't connect to local MySql server through socket
> '/var/lib/mysql/mysql.sock' (111)'
> Check that mysqld is running, and that the socket:
> '/var/lib/mysql/mysql.sock' exists!
> 
> If I look in the /var/lib/mysql/ directory, there is in fact a file named
> mysql.sock, so I don't think that's the problem. For some reason, nothing I
> try will get the server started...
> 
> I checked the documentation again, and can't find this problem listed at
> all, so again I am asking for help!
> 
> 
> 
> ______________________________________________________________________
> Philadelphia Linux Users Group       -      http://www.phillylinux.org
> Announcements-http://lists.phillylinux.org/mail/listinfo/plug-announce
> General Discussion  -  http://lists.phillylinux.org/mail/listinfo/plug
> 



______________________________________________________________________
Philadelphia Linux Users Group       -      http://www.phillylinux.org
Announcements-http://lists.phillylinux.org/mail/listinfo/plug-announce
General Discussion  -  http://lists.phillylinux.org/mail/listinfo/plug