473,699 Members | 2,380 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can't stop mysql

Got mysql started, created root password.

Decided to change it and used mysqladmin to try and change. It says access
denied.

I tried to stop the service, can't do that. I even restarted the computer
and it says there is still a connection on localhost:3306 and it can't make
changes.

I have deleted mysql and completely re-installed. Nothing changes.

How can I completely stop the service that it tying up :3306.

Is there anyway to see those ports and see what is connected?

Thanks,
Fred
Jul 19 '05 #1
2 8914
In mysql admin prompt (> mysql )
do "show processlist" which shows connections. Might tell you which service
is connecting.
Could be the web server is the one connecting.
(You can kill processes there also)
Strange it won't kill it anyway. Did you say if Windows or Unix?
dp
"Fred Blair" <fb*****@ev1.ne t> wrote in message
news:vn******** ****@corp.super news.com...
Got mysql started, created root password.

Decided to change it and used mysqladmin to try and change. It says access denied.

I tried to stop the service, can't do that. I even restarted the computer
and it says there is still a connection on localhost:3306 and it can't make changes.

I have deleted mysql and completely re-installed. Nothing changes.

How can I completely stop the service that it tying up :3306.

Is there anyway to see those ports and see what is connected?

Thanks,
Fred

Jul 19 '05 #2
In mysql admin prompt (> mysql )
do "show processlist" which shows connections. Might tell you which service
is connecting.
Could be the web server is the one connecting.
(You can kill processes there also)
Strange it won't kill it anyway. Did you say if Windows or Unix?
dp
"Fred Blair" <fb*****@ev1.ne t> wrote in message
news:vn******** ****@corp.super news.com...
Got mysql started, created root password.

Decided to change it and used mysqladmin to try and change. It says access denied.

I tried to stop the service, can't do that. I even restarted the computer
and it says there is still a connection on localhost:3306 and it can't make changes.

I have deleted mysql and completely re-installed. Nothing changes.

How can I completely stop the service that it tying up :3306.

Is there anyway to see those ports and see what is connected?

Thanks,
Fred

Jul 19 '05 #3

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

Similar topics

0
2886
by: Stefan Hinz | last post by:
Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be , not (mysqld2).
0
1509
by: Trina Schwimmer | last post by:
Hi. Can anyone stop this guy and this message? I'm getting a ton of them. I might just direct his email to my delete bin. Thanks, Trina -----Original Message----- From: Info Sent: Thursday, July 24, 2003 10:01 PM To: mysql@lists.mysql.com; nils@knowd.co.jp; vikram@w-o-i.com
0
3945
by: flubdgub | last post by:
Hi there, I want to do something ridiculously simple and naturally MySQL is presenting me with problems that the manual doesn't even hint at. Platform is Debian Linux 2.4.21 All I want to do is change the datadir in /etc/mysql/my.cnf from /var/lib/mysql to /DB. I attempted this as follows:
0
2194
by: Cleber Hostalácio de Melo | last post by:
Hi, I need to change the stop word file used by the MySQL in fulltext seach. The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html) explains how to inform to MySQL the new stop word file through the "ft_stopword_file" variable. But I could not find any reference to the layout of this file, for example, how to separate each stop word in the list?
0
591
by: Fred Blair | last post by:
Got mysql started, created root password. Decided to change it and used mysqladmin to try and change. It says access denied. I tried to stop the service, can't do that. I even restarted the computer and it says there is still a connection on localhost:3306 and it can't make changes. I have deleted mysql and completely re-installed. Nothing changes.
0
2329
by: Mark Adams | last post by:
I really need some help with this. MySQL will not start on boot despite everything I've done to make sure that it is set to do so. When I start it as root from a terminal with "/usr/bin/mysqld_safe --skip-grant-tables &" I show several mysqld procs. and one mysqld_safe, but I can't connect: # ps -aux| grep mysql Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html root 3650 0.0 0.1 2276 664 ? S ...
3
5763
by: eieiohh | last post by:
MySQL 3.23.49 PHP 4.3.8 Apache 2.0.51 Hi All! Newbie.. I had a CRM Open Source application installed and running. Windows Xp crashed. I was able to copy the contents of the entire hard drive onto a USB External Hard Drive. I have to assume I also copied the data. I
2
18763
by: Michal Stankoviansky | last post by:
Hi Environment: some version of Slackware, Apache 2.2.x, PHP 5.1.5, MySQL 5.0.24. The issue: I'm using Zend Framework Zend_Db component (which uses PDO). We have 2 mysql socket related settings in php.ini: mysql.default_socket = /var/run/mysql/mysql.sock mysqli.default_socket = /var/run/mysql/mysql.sock
4
7118
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 this? Thanks, Bob
0
8689
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
8618
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
9178
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
8885
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...
1
6534
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5875
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4376
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3058
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
2
2348
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.