473,771 Members | 2,297 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysqld startup problem

I'm using ssh to administer a mysql server, version 3.23.49, which I
just installed.

The problem when starting mysqld: I type "mysqld" at the shell prompt
and hit return, then I get the message "mysqld: ready for
connections". But then it doesn't give me back the shell prompt. I can
type stuff on the screen, but it doesn't do anything. I've tried
Ctrl-C and Ctrl-Z, but that does nothing. Any ideas? Thanks.

Paul
Jul 19 '05 #1
3 5623

"Paul" <pb**@nospam.ne t> wrote in message
news:81******** *************** *******@news.te ranews.com...
I'm using ssh to administer a mysql server, version 3.23.49, which I
just installed.

The problem when starting mysqld: I type "mysqld" at the shell prompt
and hit return, then I get the message "mysqld: ready for
connections". But then it doesn't give me back the shell prompt. I can
type stuff on the screen, but it doesn't do anything. I've tried
Ctrl-C and Ctrl-Z, but that does nothing. Any ideas? Thanks.

Paul


I assume you're using Linux/Unix as opposed to windoze...

Also... mysqld I believe is the daemon - the "engine" as it were, and
"waiting for connections" means its waiting to take requests from a client.
When you start mysqld, you are running the engine in the foreground hence
why its just sitting there doing nothing... its not supposed to echo
anything out to your screen (since its the engine or server part of the db).

Did you install the client utilities or just the server?

On my system, its /usr/bin/mysql that allows me (the client) to talk to the
mysqld (the server).

You should read some of the documents and find out how to start up the
server and how to use the client.

(for your info, there is MySQL Control Center - a windoze graphical
interface that allows you to communicate with a MySQL server, regardless if
the MySQL Server is on another windoze or unix/linux box). It works fine
for my purposes and its simple to use, I suggest you check it out at the
download page of the mysql website.

Lastly - I believe you are not using the latest version 3 of MySQL (I
believe its 3.23.56, not 3.23.49) - I suggest you upgrade.
Jul 19 '05 #2

"Paul" <pb**@nospam.ne t> wrote in message
news:81******** *************** *******@news.te ranews.com...
I'm using ssh to administer a mysql server, version 3.23.49, which I
just installed.

The problem when starting mysqld: I type "mysqld" at the shell prompt
and hit return, then I get the message "mysqld: ready for
connections". But then it doesn't give me back the shell prompt. I can
type stuff on the screen, but it doesn't do anything. I've tried
Ctrl-C and Ctrl-Z, but that does nothing. Any ideas? Thanks.

Paul


I assume you're using Linux/Unix as opposed to windoze...

Also... mysqld I believe is the daemon - the "engine" as it were, and
"waiting for connections" means its waiting to take requests from a client.
When you start mysqld, you are running the engine in the foreground hence
why its just sitting there doing nothing... its not supposed to echo
anything out to your screen (since its the engine or server part of the db).

Did you install the client utilities or just the server?

On my system, its /usr/bin/mysql that allows me (the client) to talk to the
mysqld (the server).

You should read some of the documents and find out how to start up the
server and how to use the client.

(for your info, there is MySQL Control Center - a windoze graphical
interface that allows you to communicate with a MySQL server, regardless if
the MySQL Server is on another windoze or unix/linux box). It works fine
for my purposes and its simple to use, I suggest you check it out at the
download page of the mysql website.

Lastly - I believe you are not using the latest version 3 of MySQL (I
believe its 3.23.56, not 3.23.49) - I suggest you upgrade.
Jul 19 '05 #3

"Paul" <pb**@nospam.ne t> wrote in message
news:81******** *************** *******@news.te ranews.com...
I'm using ssh to administer a mysql server, version 3.23.49, which I
just installed.

The problem when starting mysqld: I type "mysqld" at the shell prompt
and hit return, then I get the message "mysqld: ready for
connections". But then it doesn't give me back the shell prompt. I can
type stuff on the screen, but it doesn't do anything. I've tried
Ctrl-C and Ctrl-Z, but that does nothing. Any ideas? Thanks.

Paul


I assume you're using Linux/Unix as opposed to windoze...

Also... mysqld I believe is the daemon - the "engine" as it were, and
"waiting for connections" means its waiting to take requests from a client.
When you start mysqld, you are running the engine in the foreground hence
why its just sitting there doing nothing... its not supposed to echo
anything out to your screen (since its the engine or server part of the db).

Did you install the client utilities or just the server?

On my system, its /usr/bin/mysql that allows me (the client) to talk to the
mysqld (the server).

You should read some of the documents and find out how to start up the
server and how to use the client.

(for your info, there is MySQL Control Center - a windoze graphical
interface that allows you to communicate with a MySQL server, regardless if
the MySQL Server is on another windoze or unix/linux box). It works fine
for my purposes and its simple to use, I suggest you check it out at the
download page of the mysql website.

Lastly - I believe you are not using the latest version 3 of MySQL (I
believe its 3.23.56, not 3.23.49) - I suggest you upgrade.
Jul 19 '05 #4

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

Similar topics

0
7532
by: Stephane Raimbault | last post by:
I've been searching the mailing list for a solution to my problem with "mysqld got signal 11;" and I haven't seen any answers that might help me. This is the situation. I have a db that is being accessed intensively about 400 connections during the wee at a time. I noticed the problem at first with 4.0.13 and tried 3.23.57 and now 4.0.14 with the same problem. I've run the db on FreeBSD 5.1 and 4.8, again same problem. This is what...
0
1391
by: Asif Iqbal | last post by:
This is what I bumped into now 030731 15:39:50 mysqld started 030731 15:39:52 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3491794745 InnoDB: Doing recovery: scanned up to log sequence number 0 3491800490 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 32 row operations to undo
0
1382
by: Albert Rossi | last post by:
all, i have seen a couple of postings on the following issues which i have encountered and have struuggled with for a couple of days now. i apologize in advance if someone has already posted the resolution and i missed it. Problem Description: on a Dual i386 Architecture with RH9, MySQL 3.23.54a-11 (or its .56 upgrade) under heavy loads the mysqld process reaches 99.9% CPU Utilization (as
0
624
by: Gary Cote | last post by:
>Description: I've recently compiled mysql 4.0.14 on redhat 8.0. The installation fails, however, when running mysql_install_db. I've attached a transcript below. I gather from searching the 'net that this isn't an entirely unusual thing to happen, and is likely the result of some misconfiguration on my part, or perhaps a version incompatability with my libc. Unfortunately, I haven't seen any concrete suggestions on how to get past it.
0
1792
by: Dominik Blunk | last post by:
Hi there I have a problem: I run 2 servers in a master-slave configuration (both Solaris 5.8 and mysql4.0.14). Mysql (only on master) crashes exactly every 15 Minutes with the following message: -----schnipp--------------- mysqld got signal 11;
0
3714
by: Rob Kings | last post by:
OK. I admit. I should probably have left well alone, but I wanted to move the installed location of mySQL. This all seemed to go OK, but when I moved from something like: /home/rob/mySQL/mysql-max-3.23.55-pc-linux-i686/bin to /mysql The when I try to startup the daemon I get an error
1
16811
by: Jeremy Kohansimeh | last post by:
Hello, I just installed version 4.0.21 on a Mandrake 8.2 system. I cannot get the MySql daemon to run. I am using the following commands, and receiving these errors: $mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/JBrain.pid 040921 09:01:55 mysqld ended
0
1370
by: kelvlam | last post by:
I have written a service that is depending on mysqld. The service startup just fine, but I would like to have my service *always* shutdown first before mysqld does. That way I can add some log into my table before the service shutdown. As I search online, I haven't found any way to do so. Since the "service dependencies" setting of services is only used at startup stage, but not at shutdown stage. Is there any way to intercept the...
1
1677
by: intheend | last post by:
respected when i start the mysqld it times out .. without starting service mysqld start time out when i give the command
0
9619
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10260
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10102
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10038
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9910
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8933
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4007
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.