472,353 Members | 972 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

How do I start MySQL?

I am a relative newbie to MySQL. I had a Postfix+Courier+MySQL mail
server running for several months. It took me a week or so to get it up
and running in September. Now, I did a clean upgrade to Mandrake 9.2
and am reinstalling everything. This thing is kicking my ass and I
can't seem to get past it. I could really use some help if anybody has any.

Just for reference, this was my primary source for information on
installation and setup, though I've been scouring Google for help:

Of course, there's also the MySQL manual:

I am trying to get MySQL to start automatically at boot. Initially it
did start, but it was a runaway process -- mysqld_safe and mysql process
apperared in the process table, died and respawned quickly soaking up
100% of my CPU processor cycles (see below). I'm not sure what caused
it to stop initializing on boot, but there was a lot of configuration
done with Postfix and Courier-IMAP.

I've copied mysql.server to the /etc/rc.d/init.d directory. It didn't
help. I have worked with "chkconfig" and it hasn't helped. As you can
see from this fragment of "chkconfig --list", it is in the list to run
under inits 2-5, but it just doesn't start.

[root@adamsmdk courier]# chkconfig --list
httpd 0:off 1:off 2:off 3:on 4:on 5:on 6:off
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
sendmail 0:off 1:off 2:on 3:on 4:on 5:on 6:off
postfix 0:off 1:off 2:on 3:on 4:on 5:on 6:off
courier-imap 0:off 1:off 2:on 3:on 4:on 5:on 6:off

If I start the MySQL server through Webmin or at the command line
(/etc/rc.d/init.d/mysql start), the process runs away just as it did
when it used to start at boot. -- I get a series of instances of mysqld
and mysqld_safe in the process tables that take turns spawning and
dying, and constantly soak up processor cycles thrashing around. It's
very hard to kill this process. I have to execute "/usr/sbin/mysqld
stop" repeatedly and rapidly at the command line as root to shut it down.

If I start the server at the command line as root with "mysqld_safe
--skip-grant-tables &" I get a polite set of 3 instances of mysql and
one mysqld_safe. They appear to function normally, but webmin reports
that mysql server is not running and can't start it -- reports no error,
just that it isn't running and database list can not be retrieved. I
assume that for whatever reason, Webmin can't see the process running.

Stopping this server is also next to impossible. When I issue "mysqld
stop" at the command line (root or user) I get:

[madams@adamsmdk init.d]$ /usr/sbin/mysqld stop
040101 22:22:41 Can't start server: Bind on TCP/IP port: Address
already in use
040101 22:22:41 Do you already have another mysqld server running on
port: 3306 ?
040101 22:22:41 Aborting

040101 22:22:41 /usr/sbin/mysqld: Shutdown Complete

This does not alter the process in the proc. table:

[madams@adamsmdk init.d]$ ps -aux|grep mysql
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 24677 0.0 0.2 2456 1256 pts/4 S 22:13 0:00 /bin/sh
/usr/bin/mysqld_safe --skip-grant-tables
mysql 24693 0.0 0.5 13600 2624 pts/4 S 22:13 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/adamsmdk.pid --skip-locking --skip-grant-tables
mysql 24694 0.0 0.5 13600 2624 pts/4 S 22:13 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/adamsmdk.pid --skip-locking --skip-grant-tables
mysql 24695 0.0 0.5 13600 2624 pts/4 S 22:13 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/adamsmdk.pid --skip-locking --skip-grant-tables
madams 24823 0.0 0.1 1828 608 pts/0 R 22:25 0:00 grep mysql

"Killing" the process as root also has no effect. I have to use the
command line buffer to stuff "mysqld stop" from 3 to 30 times in rapid
succession or sometimes this works:

[root@adamsmdk madams]# mysqld_safe stop
Starting mysqld daemon with databases from /var/lib/mysql
040102 12:56:47 mysqld ended

[root@adamsmdk madams]# mysqld_safe stop
Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe: line 1: 25790 Killed nohup
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/adamsmdk.pid --skip-locking stop
/var/lib/mysql/adamsmdk.err 2>&1

040102 12:56:52 mysqld ended

Notice that I had to send that command twice.

I tried mysql_fix_privilege_tables --password=root_password and thought
that fixed it. But it did not. I uninstalled and reinstalled all the
MySQL elements it -- no change.

How can I start this thing so that it runs properly and how can I get it
to do so automatically at boot?



Jul 19 '05 #1
0 5758

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Mark Adams | last post by:
I am a relative newbie to MySQL. I had a Postfix+Courier+MySQL mail server running for several months. It took me a week or so to get it up and...
by: Massimiliano Marcon | last post by:
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I...
by: Derek | last post by:
Hello Sorry if this has been asked before but here we go any way. I am running Mandrake Linux 9 with MYSQL 3.23.52 ( I know not the latest but...
by: KC | last post by:
Hello I installed MySQL ver 4.0.20d on a Windows XP Professional PC. I created a user and database that I would like to delete, and at this point...
by: sandwich_eater | last post by:
I installed and started MySQL on Mandriva 10.x and get an "Error" on screen after a series of "." appears. Where to look for the log?
by: Chris Song | last post by:
Hello, I'v installed mysql 5.0 (MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4. When I start mysql through command line (i.e....
by: Bob | last post by:
Hi, I would like to periodically start and stop mysql on a schedule using something like the Windows scheduler. Does anyone know a good way to do...
by: rabbit | last post by:
Hello, I am really stuck with the following problem and I have tried almost all options I could find on Google to no avail. I recently installed...
by: TechnoAtif | last post by:
Could not start the mysql service on localcomputer Error 1067:The process terminated unexpectedly....
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.