LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 01-20-2004, 01:44 PM   #1
bwreath
LQ Newbie
 
Registered: Jul 2003
Posts: 16

Rep: Reputation: 0
Unhappy Starting up MySQL


Hi,

I would appreciate any help on the following. I have searched the mailing list for information But have not come up with a solution for my situation which has been frustrating. I think I need some things need to be clarified.

The OS that is running is RedHat V.9.0 linux. MySQL was installed when RedHat V.9.0 was installed. Here are the packages that that I have installed
Shell> rpm -qa | grep -i mysql
MySQL-server-4.0.15-0
MySQL-shared-4.0.15-0
mod_auth_mysql-1.11-12
perl-DBD-MySQL-2.1021-3
MySQL-shared-compat-4.0.15-0
MySQL-client-4.0.15-0
MySQL-Max-4.0.15-0
php-mysql-4.2.2-17
MySQL-devel-4.0.15-0
MySQL-bench-4.0.15-0

First, I went to the MySQL website to look up the section on Unix Post-installation Procedures. I then tried the following as root and got the following result:
-----------------------------------------------------------------------------------------------------------
Shell> cd /usr/bin
Shell> mysql_install_db
Installing all prepared tables
040120 12:00:51 /usr/sbin/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: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h yourserver.ca password 'new-password' See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command!

You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!


Shell> mysqld_safe --user=mysql &

Starting mysqld-max daemon with databases from /var/lib/mysql mysqld ended
--------------------------------------------------------------------------------------------------------

I get the exact same response if I do su mysql first as well.

The error log mysqld has the following as the most recent entry. 040120 12:01:05 mysqld started 040120 12:01:05 Can't start server: Bind on TCP/IP port: Address already in use 040120 12:01:05 Do you already have another mysqld server running on port: 3306 ? 040120 12:01:05 Aborting

040120 12:01:05 /usr/sbin/mysqld-max: Shutdown Complete

040120 12:01:05 mysqld ended
I have already tried
--------------------------------------------

If I try something like
Shell> service mysqld start
I get
Mysqld: unrecognized service

I have tried things such as:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> chown -R mysql /var/lib/mysql
shell> chgrp -R mysql /var/lib/mysql
shell> chown -R root /usr/local/mysqlcc-0.9.3-linux-glibc23
shell> chgrp -R mysql /usr/local/mysqlcc-0.9.3-linux-glibc23
shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &

I have also typed in
Shell> mysql
I get
Error 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I tried to see is MySQL was running by typing in

Shell> ps -eaf |grep -i mysqld
root 14437 13954 0 Jan19 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --user=mysql
mysql 14463 14437 0 Jan19 pts/0 00:01:13 [mysqld-max]
root 16210 16183 0 14:34 pts/1 00:00:00 grep -i mysqld

I am not sure how to be able to start MySQL running and using it. I have tried a number of things. Thanks very much for your help.
 
Old 01-20-2004, 02:34 PM   #2
andrewlkho
Member
 
Registered: Jul 2003
Location: London
Posts: 548

Rep: Reputation: 30
Hi,
I'm not entirely sure what's going on, but I'll give it my best shot. What you should do is restart your computer, making sure that when it starts up again, it doesn't touch mysql / try and do anything to it. Then, as root, start mysql with the mysql.server script. What happens when you've done that?
 
Old 01-20-2004, 03:20 PM   #3
bwreath
LQ Newbie
 
Registered: Jul 2003
Posts: 16

Original Poster
Rep: Reputation: 0
thanks for your response but I am not exactly sure what you
mean and how to go about doing this.

What is the reason for this approach?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
Starting MySQL... darkarcon2015 Slackware 52 12-28-2005 05:52 AM
Help starting up mysql . rullman Linux - Software 4 05-24-2004 05:00 AM
starting mysql apax Linux - Newbie 4 12-28-2003 07:50 AM
starting mysql studentforever Linux - Software 10 09-18-2003 04:34 PM


All times are GMT -5. The time now is 01:24 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration