MYSQL :: How To Shutdown MySQL Default Port (3306)

MySQL Port 3306
I want to run MySQL on server but it only be accessible to programs on
localhost. I see that port 3306 is open on server so I need to close
it.How do I do that while keeping it available to programs running on
localhost?

MySQL 4.0.1 Port 3306 Error
I am trying to run the server on my PC and have already got Apache and PHP working fine. Whenever I run MySQL 4.0.1 Gamma however, a port 3306 error comes up saying that I possibly have another copy of the MySQL server already running which is not true. Also, I have noticed that my internet connection ceases to function along with Apache and everything tells me I'm behind an unknown proxy server.

How To Connect Directly To Mysql Server Port (3306) Using TCP/IP Protocol
I want to develop an application in LabWindows/CVI (ANSI C developpment software for instrumentation) from which I could connect directly to mysql server port (3306) using TCP/IP protocol. This developpment environment allows me to use functions to connect, read and write to a certain port using TCP/IP protocol. I must say I'm new to using MySQL and I searched the manual without any response to my question.

Port 3306
I'm trying to install my sql on a w2k3 std box....... I get the firewall setting error message... I open up the port (like stated in all the many topics I've seen here.... I STILL get the same massage. What the hell do I do? I tried earlier versions up to ver 4.1 and still the same thing.

Port 3306 - Can't Get Started
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:mysqlin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:mysqlin>mysql --install
mysql: ERROR: unknown option '--install'

C:mysqlin>mysqladmin -u root shutdown
....failed - and it suggested I telnet localhost 3306

C:mysqlin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:mysqlin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed.

Access Denied With Port 3306
here is my problem

I get the error "access denied for user root@localhost" with a note that if I have a firewall I should open port 3306

I really have a Norton 2005 firewall enabled and I do not know how to open port 3306
although I give a rule to all mysql services to use any ports.

Internet Port 3306 Open Safe
I have a server at an ISP - I've got port 3306 open in the firewall so
that I can work from remote however its got me thinking if its safe? I
know Microsoft got hit with slammer (or whatever) worm on their
unpatched machines that were exposed to the outside world, but I'm
trying to measure up the risks by having my db server exposed for a few
weeks.

Backup MySQL Via Port 3306 (which Tool? Automatic Backup?)
i have quite a big database on my website - and i cannot get any backup via system dump or scripts anymore, because my hoster added some memory limits - and scripts/dump can't finish...

so the only way left is to backup my database via connection to port 3306 and tools like mysqlfront.

mysqlfront is unfortunately quite slow and buggy - so do you know any tools which can backup databases via external connection? - it would be great if there are tools which run automatically? (batch/commandline??)
backup with mysql.exe - h -u .... is impossible, too!

Default Port Of Mysql
I've installed mySQL-essential-4.1.22-win32.

And it doens't connected to my coldfusion webserver because of port problem.

What is the default port of mySQL-essential-4.1.22-win32?

Cannot Remote Access On Non-default Port
On MySQL server running on UNIX machine I changed the default port 3306 to 40006. From Windows PC I ran this command: mysql -p -u user1 -h mysqltest:40006 testdatabase

It does not work. It only works if I use the default port 3306.
How can I remote access on non-default port?

Mysql Shutdown
how can I tell mysql to execute a shell command when it is going to shutdown. I want to do that, so I will be notified when mysql crashes.

Can't Shutdown MySQL
My server just started doing this... I have no idea why. (redhat, mysql 4)
Before I would control mysqld with the support-files/mysql.server start/stop command.
When I run mysql.server stop it "gives up waiting" for mysql to quit. I also tried the mysqladmin shutdown command.If I kill the pid, nothing happens. If I kill -9 the pid, it forks off and I end up with like 6 mysqld processes. What the heck is going on?

MySQL Two Way Replication Won't Shutdown
I have read up on MySQL failover/replication and decided that weren't
many cons to setting up two way replication where two servers are both
master and slave to eachother. Here's the my.cnf:

[mysqld]
log-bin
log-slave-updates
server-id=2
master-host=10.0.0.2
master-user=repl
master-password=<password>

The my.cnf on the other server is same except for server-id and
master-host.

This works fine when in use, updates to either server are immediately
shown on the other one. However, I'm not distributing the load, this
was done only for a failover situation when one server goes down, the
other one is available. I'm only doing db queries, selects and inserts
on one server.

The problem is that when I try to shutdown either one, the mysqld stop
hangs: # /etc/rc.d/mysqld stop

Stopping mysqld.
Waiting for PIDS: 7021, 7021, 7021, 7021, 7021, 7021, 7021, 7021, 7021,
7021, 7021, 7021, etc etc etc

This happens on both servers. They're MySQL 4.0.22(tried 4.1.7 with
same problem) on NetBSD 2.0. When I do a STOP SLAVE; on either one, it
takes about 1 min. Then I'm able to shutdown.

MySQL 4.0 Shutdown Abnormal
I have a problem referring MySQL Server 4. Sometimes, my Server shutdown with proper will, while my company use the server.

040923 8:32:18 InnoDB: Starting shutdown...
040923 8:32:21 InnoDB: Shutdown completed
040923 8:32:21 /usr/sbin/mysqld: Shutdown Complete

I read the log file and I found this:

040923 8:32:17 Aborted connection 333 to db: 'atendimento' user: 'atendimento' host: `192.168.200.88' (Got timeout reading communication packets).

Mysql Server Shutdown
i have mysql 4.1 installed on my home pc running windows xp home. occasionally i need to shut down the computer or restart it. mysql is installed as a service.

when i shut down the computer, do i need to perform a shutdown of mysql from the console of can i just shut down the computer and windows will take care of it??

Shutdown Mysql Server
This is on the command line only, running from the terminal of the box.
I have mysql 5.0.24 installed on solaris 8
mysql works great, but to get ready for production I want to lock down the root mysql user with a password. I do that with the command
SET PASSWORD FOR 'root'@'blahblah' = PASSWORD('blahblah');

But now when I issue the:
mysqladmin -u root shutdown
it fails because it requires a password, so i did:
mysqladmin -u root -p blahblah shutdown
then it returns with "please enter password"

How do I shutdown mysql from the command line with an account that needs a password? This is so I can use it with my rc3 scripts to terminate on system shutdown.

W2K Shutdown Issues After MySQL 5 Install
Has anyone heard of MySQL5 causing W2K to have problems shutting down? I'm running a 2K Server with MySQL 5.0.16 and noticed that after the install, the server would not shutdown cleanly. If I disable the MySQL Server prior to shutdown, the server shuts down or restarts without a problem.

What Port Does Mysql Use For SSL?
I can't find it documented what port the mysql server uses to listen for SSL connections. I'm trying to figure out what port to open up in the firewall. I'm using mysql 5.0.24a on RHEL 4.

MySQL Port
How do I check that what Port number is MySQL is running on it? I type this command: netstat -a did not show anything yet.
But I know that mysql run 3306 as default number, but when I run the following command: netstat -a | grep 3306 gives the following warning: 'warning, got duplicate tcp line'

On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?

MySQL Server On Different Port
Because I'm using a Java program that connect to my MySQL server from a remote location that doesn't allow connecting to port 3306.

I'm forced to change the port to a number that will work on the client end. Port 23 is allowed and since I don't run a telnet server, I'd like to run MySQL on port 23 instead of 3306. I change it to port 23 in the my.conf file, but the service won't start. I can make it port 3310 and it'll start just fine. Why won't it let me use 23?

Changing Mysql Port
How do you change the mysql port?

Opening Mysql Port
What I want to do is to open the mysql port. So I can access it from an other computer. How do I do this? I guess it's in an config file, But wich?

MySQL Server Port
whats the name of the config file I can edit so that mysql listens on port 3306. I dont seem to have a *.cnf file that acts as the mysql config file.
Better yet, what tool can I use to determine what config file was used

Changing Mysql Port:
How do you change the mysql port

MySQL Multiple Port Numbers
Have a LAMP server and am trying to get MySQL to listen on multiple ports.. I need 3306 and 3307 and I just can't figure out how to get it to listen on both, one or the other just not both at the same time.

Mysql Commandline Tool -- Port Broken
the "mysql" command allows me to use any ridiculous number after "--port=", even "80", as shown below. I can even use a random string like "abcd" in place of "80".

Exactly what I want to do? I need to experiment with the "mysql" commandline tool together with tcpdump. So far, my tcpdump command cannot detect *any* thing about mysql.

yes my tcpdump can detect http traffic.
yes my tcpdump can detect something when i run "telnet loalhost 3306".

------------- snip ---------------
$ mysql -u xxx -pxxxxxx -h localhost --port=80 -vvv
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 8319 to server version: 3.23.58

Reading history-file /home/httpd/vhosts/portal.crpp.servy.net/.mysql_history
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

Close Mysql Port Or Bind It To Only Localhost Or ...
I only use mysql locally. I want to

- close port 3306 if possible (like starting Oracle database without
starting listener),
- or bind it to localhost only (like what sendmail does),
- or next best thing

for security.

I am on redhat 9, and use mysql 3.23.55. I can upgrade if newer
version provide the functionality.

Mysql Command Line Client Ignores Port Number
I am running 4.1-7 on an SGI (unix.) The server is listening on port 3307.

I can connect like:
mysql -uusername -ppassword -P123 -hhostname database
and I can also connect like:
mysql -uusername -ppassword -P3307 -hhostname database

and they BOTH connect!

It seems that mysql ignores the port number passed in on the command line.

Is it reading a config file that I am missing (if so, why doesn't the command line port override whatever is set in this file.)

Localhost:3306 (bad Handshake?)
When I connect to "http://localhost:3306", I have this error message :

"B 5.0.24a-community-ntN&mu'^'B,Â¢WnGTOroU>tQuÃ¿Bad handshake"

Is it normal?
Does "http://localhost:3306" suppose to show something?

Listening On Two Ports (3306, 80)
my customer is not able to connect to MySQL Server on port 3306.So i need to change this to port 80.

But other standard applications also should connet to this Server and they should use port 3306.

How i can configure this?

Can't Shutdown Mysqld
I installed mysql-4.1.7 on solaris 8. I can start it using
mysqld_safe. But when I tried to shutdown using 'mysqladmin -p
shutdown' and type in the root password, it gave:

mysqladmin -p shutdown
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'oracle'@'localhost' (using password:
YES)'

I started mysqld_safe under Unix account "mysql", why it complains
about 'oracle'?

Root Shutdown
i have installed both PHP and mysql BUT

when i come to the part where i shall setup ""PHPRC"" as system variable and ""C:PHP"" as value. ISS stop's working. after tryingto find a solution here http://forums.devshed.com/iis-97/iss-problem-397461.html
i was looking trou the event manager and found this just as i was trying to go to localhost.

Application popup: PHP Error : Error parsing C:PHPphp.ini on line 681
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

and on line 681 there is "Program FilesMySQLMySQL Server 5.0inmysqladmin" -p -u root shutdown

Windows 98 Shutdown
Recently I installed mysql on a win98. Some 2 days after the
installation the system started experiencing a problem shutting
down. When shutting down the hard-disk kept spinning sometimes
as
long as 10 minutes.
The same problem was encountered on another win98 computer.
The system is working well with win2000 though..edu.tw

Will A SIGTERM Shutdown While Using LinuxThreads
On another mailing list, there is a discussion about whether or not
it is adequate/proper to manage the MySQL server process via a
watchdog script (namely, DJB's daemontools).

The point behind this watchdog script is to launch a service (such
as mysqld) in the foreground, and notice if that process exits. An
auxilary tool will send this managed process a SIGTERM, to request
shutdown.

It has been working for me under FreeBSD, and the MySQL docs imply
this should work for other OSes, but someone just pointed out to me
this info:

<http://www.mysql.com/doc/en/Linux.html>

"When using LinuxThreads you will see a minimum of three processes
running. These are in fact threads. There will be one thread for
the LinuxThreads manager, one thread to handle connections, and
one thread to handle alarms and signals."

I myself don't use Linux, much less LinuxThreads. Can anyone advise
how the theree process/threads should handle a SIGTERM in such a
watchdogged environment?

Windows 98 Shutdown Problem
Recently I installed mysql on a win98. Some 2 days after the
installation the system started experiencing a problem shutting
down. When shutting down the hard-disk kept spinning sometimes
as
long as 10 minutes.

The same problem was encountered on another win98 computer.

The system is working well with win2000 though.

#1053 - Server Shutdown In Progress???
Using this query:
Quote:

SELECT p.first, p.last, p.city, p.state, p.member_id, m.corr_type, m.member_corr_id
FROM members p
LEFT OUTER JOIN member_corrections m
ON p.member_id = m.member_id AND m.processed=Ɔ'
WHERE p.club_id = ðƒ' AND p.memLevel=Ƈ'
ORDER BY p.last

i get this error:

Quote:

#1053 - Server shutdown in progress

Any ideas why this might happen. It should produce roughly 250 results.

Running MySql 5.0.27

Really Slow Shutdown With Innodb, Db Not Accessible?
For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K)
to complete a shutdown. The fast shutdown flag is not set
(innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but
in the meantime, I don't have any access to the server -- clients simply
can't connect. This is a real problem, since it renders the database
useless for a long period of time. My Innodb table is about 15 GB and
probably has about 10 million records in various tables.

When the darn thing finally shuts down, I'll restart with fast shutdown on,
but I'm wondering how foolish it would be to kill the process, given that
Innodb should then do a crash repair. Would the crash repair take longer
than what it's doing now? Would the server be inaccessible as it is now?

Besides enabling fast shutdown, what else will help avoid this kind of thing
in the future?

Intercept Windows Shutdown Message
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 Shutdown window message being sent to
mysqld?I hope the answer is not to have me edit the mysqld source
code...

Port Range
What range of ports does MySQL use because I need to set it up with my firewall. At the moment i have added 3306 but when it changes port to one in whatever the range is it says lost connection to server. It works fine with firewall off.

Can I Run Two Instances On Same PORT
I am using mysql and like to know the possibilities of running two instances in same port?

Can't Connect Port = 0??
I have root access to this server which has been preconfigured. I can
connect using the mysql command tool. But I cannot connect using any
mysql GUI software (I am currently tunneling the 3306 port to 3306 on
the server using SSH). So i ran mysqladmin variables. And got the
following:

port 0

instead of the usually port 3306. Obviously I cannot connect on port 0.
How can I troubleshoot this and get mysql running so I can connect via
tunneling?

Open Additional Port
I need to access an external MySQL db through a firewall. I'd like to open up an additional port (leaving 3306 as is) to the same MySQL instance.
For example, I have my mail server running on both ports 25 and 26 (ISP blocks outbound 25).

Ado Connection String For Tcpip Port
Currently I connect to MySql using the following vbscript:

set conn = createobject("ADODB.Connection")
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=test;"_
& "UID=venu;PWD=venu;OPTION=3"
conn.open()

I would like to change my connection string so that I connect using
TCP/IP and I would like to specify port 3306 inside the string. I
know how to do this with MS SqlServer, but does someone know how to do
this with MySQL?

How To Change Root Password And Port
I have recently installed MySQL 3.23 on Windows 2000 Server. Can anyone tell me how do I change the root password and default port of MySQL?

Authentication Problem On Nonstandard Port
I am running two database instances of mysql (one on a nonstandard
port). After granting users permissions I find that I can access
mysql from other machines only if I use the standard port. When I use
the non-standard port I can only authenticate if I am on the box where
the database is running. Also some previously set up users can
authenticate through the non-standard port (sadly no one knows how
those users were set up). What do I need to do to allow for
authentication on the nonstandard port ex:

mysql -h<HOST> -u<USERNAME> -p
(defaulting to standard port works)
mysql -h<HOST> -u<USERNAME> -P<NON-STANDARD PORT> -p
(fails)

MySQL Default Value
When a customer places an order, the database sets the default at "3" which means "not complete" when it is complete and billed, It is assigned a "1"

I want to have it be assigned a new number on all future orders, but no not want it to go back and reset every single past order. If I change the default value number in the database, will it only apply to new orders, or will it change every single record to the new default regardless of their current status?

Connector/ODBC Not Saving Port Setting
Using MySQL Connector/ODBC 3.51, I set the port to a non-default value
(3309), under 'Connection Options' to connect to a remote machine running 2
versions of MySQL. 'Test' is successful but when I close the Connector/ODBC
window on XP the port setting is not saved so the DSN doesn't work.

How To Shutdown MySQL Default Port (3306)

i am Using Mysql default port 3306 I have created database and now I want to shut the port so i can used my other application of Instant Rails which uses Mysql to run that port. Can you plz jus help me how to shutdown the default port so i can use another application.