MYSQL :: Changing Mysql Port

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'

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?

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?

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

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 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 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 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.

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.)

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.

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!

Changing MySQL.cnf
I want to change the values of query_cache and key_buffer in Mysql.cnf. Do I need to restart the dDb or is there a way to change this dynamically?

Mysql Changing Value Of My Decimal
this is really weird. I tried it on both windows and linux with the same problem.

Basically, I have a float(10,2) field, and if I enter a big number with decimal of .01 the decimal gets rounded to .02
example:
222333.01 becomes 222333.02
My database is mysql 4.1.2
here is a dump of my test database:
CREATE TABLE `tblpayroll` (
`payenddate` date NOT NULL default &#55612;&#57200;-00-00',
`principal_id` int(100) unsigned NOT NULL default Ɔ',
`vessel_id` int(100) unsigned NOT NULL default Ɔ',
`vessel_allotment` float(8,2) NOT NULL default Ɔ.00',
`vessel_pesoval` float(10,2) NOT NULL default Ɔ.00',
`amt1dollar` float(8,2) NOT NULL default Ɔ.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tblpayroll`
--
INSERT INTO `tblpayroll` (`payenddate`, `principal_id`, `vessel_id`, `vessel_allotment`, `vessel_pesoval`, `amt1dollar`) VALUES (&#55612;&#57200;-00-00', 1, 1, 222333.01, 0.00, 0.00);
any thoughts??

Changing MySQL Password
I am trying to learn MySQL and I don't have a clue what my username and password is. I am on win98.

I had installed MySQL awhile back and tried re-installing it, but it skips the password / username part.

I assume there must be a file I can change in notepad.

Changing Mysql On New Host
A friend of mine set up a mySql database for me a while ago and i have been maintaining what he built for some time. Due to issues with bandwidth i have had to transfer web hosts. So i need to transfer what i have into the new panal.

Sounds easy - as i say im a complete novice and am struggling. My new host have given me new passwords for my mySql database and i have an SQL dump of my old database.

I am starting completely from the absolute beginning on the new database and using things for the very first time. What do i do?

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?

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.

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).

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.

Changing Existing Mysql Account Usernames
The situation I have is, I have an existing MySQL user account, lets say its called "myacct". What I want to do is change "myacct" to "testacct", leaving all the account privileges intact. From looking at the database I thought I would be able to accomplish this by issuing UPDATE commands on mysql.db, mysql.tables_priv, and mysql.user to change all occurrences of "myacct" to "testacct" but this gives me some weird problems when I try to access the database using "testacct".

Changing An Existing MySQL Password In RHL8
Runnin'MySQL 4.x in a RHL8 system.
Had assigned a temporary password to the root account
of MySQL using:

/usr/bin/mysqladmin -u root password passisalive
/usr/bin/mysqladnin - root -h systemname password
passisalive

Now, great, that work, when trying to change the
EXISTING password:

/usr/bin/mysqladmin/ -root passisalive password
passisalive2

This is not working as it reports:

error: 'Access denied for user: 'root@localhost'
(Using password: NO)'

Changing Directories In Mysql Server In Windows
I would like to use < , source and load data, but how do I change the directory MySql server looks in for the text files?

Changing Forgotten MySQL Root Password
I get an error like this when trying to fix the password with safe mode and mysqladmin:

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Here is what I have done so far:

Command: mysqladmin -u root -p <oldpw> password <newpw>
Outcome: mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql''

I have performed everything in the MySQL Manual section A.4.1 How to Reset the Root Password.

Same outcome same error. I dont get it. What is going on.
I have researched this for about 6 hours now with no luck. Finally going to see what the "experts" have to say.

Changing Member ID's In A Mysql Database
I've been dumped in charge of an intranet site that has various php pages. One of the pages is a member list.

Quite simply, this page lists members in the order that they were added to the mysql database that contains them.

At the moment, I have a list of members under a member table that are pulled from the db in ascending order according to their member ID (1-25).

I now just want to add a new row to the member table (via phpmyadmin) and add a member with the ID of 4, so that he appears under member #3. The php page will then put him in the right place in the list.

The trouble is that there is already a member #4, so I can't just change his member # to 4 (obvious primary key error occurs).

My question is, how can I simply slip in a new member where I want, so that the consequent members and there member ID's all shift one place down in the table?

I'm obviously no php pro and don't plan to be, it's just every so often I need to change a member ID in this way and I'm clueless as to how to do it.

Changing Servers With Lower Mysql Version
I am trying to change servers and the new server is hosting a lower version of mysql therefore giving me errors when trying to import db.

The dbs are for postnuke and here's the error I am getting:

Error
> SQL query:
>
> -- phpMyAdmin SQL Dump
> -- version 2.8.2.4
> -- http://www.phpmyadmin.net
> --
> -- Host: localhost
> -- Generation Time: Oct 04, 2006 at 12:33 PM
> -- Server version: 4.1.21
> -- PHP Version: 4.4.2
> --
> -- Database: `betweent_business`
> --
> CREATE DATABASE `betweent_business` DEFAULT CHARACTER SET latin1 COLLATE
> latin1_swedish_ci;
>
>
>
> MySQL said:
>
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
>
> I know a little about mysql, but not enough to mess with this...
>
> New version: MySQL - 4.0.27-standard
> phpMyAdmin - 2.8.0.2
>
> My old version: MySQL - 4.1.21-standard
> phpMyAdmin - 2.8.2.4

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?

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?

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?

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.

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)

Changing Order Of Columns Using Mysql Query Browser
I have a table that is already created and I wanted to add a column, but put it somewhere in the middle of the table. is there a drag and drop (or something just as easy) method to move it up in the table? or do I have to re-create the whole table?

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.

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.

Changing .cnf
I have been advised by a tech to change the my.cnf settings. Do I have to stop mysql before I change the .cnf file? Or can I change the config settings and then restart it... How do I stop mysql? How do I restart mysql? Code:

Changing NOW()
Is it possible to change NOW() to a different time zone? Reason why I need this is my server is in America and I live in Australia, I know how to do it though php but I would have to use the date function, just thought I would check to see if it is possible to do it in mysql before starting on the php way.

Changing Max
I'm using MySQL server, community edition 5.0.18-nt installed on localhost.
I'm using the Dot Net connector drivers on client side within a Dotnet application.
I am migrating selected parts of my Microsoft SQL Server database to mysql. One of the tables is my images table which contains BLOB fields that may be quite large.
While trying to import records to this table, I receive the error "Unable to write to stream".
A google search revealed the following page http://forums.mysql.com/read.php?38,47230,47230
I fixed it with "set global max_allowed_packet=268435456;"
How can i view what the current max_allowed_packet size is?
At some time in the near future we'll be using a MySQL server version of our database in the field. It's very very likely that I'll completely forget that this value needs changing when MySQL is installed on client machines. If this value CAN be set in an option file that I can add to an install, which one is it please?.

Changing The Ordering
Sadly, this isn't one that can be answered simply by changing ORDER BY field DESC to ORDER BY field ASC. What I need to do is to be able to display a list of items in an arbitrary order that can be changed, e.g.,
A
B
C
D
might need to change to
C
B
D
A
I'm thinking that the best way to approach this would be to add another column sort_order that contains integer values which could then be used in an ORDER BY clause on my SELECT statements. Anyone else have any better ideas? I've done it this way before and it does work, I'm just wonder if there's some utterly brilliant solution out there that doesn't require additional metadata.

Changing A Query To Use BETWEEN?
I'm trying to convert my SQL query so I can only show the results which are between a from date and a to date?
Heres the original...

SELECT Approve, ID, Name
FROM PROVIDER
WHERE Approve = Ƈ'
ORDER BY ID ASC
LIMIT $from, $max_results

Heres what I want to do..

SELECT Approve, ID, Name, From, To
FROM PROVIDER
WHERE Availibility BETWEEN From AND To AND Approve = Ƈ'
ORDER BY ID ASC
LIMIT $from, $max_results

Changing Value After 30 Seconds?
Is there a way to change a value after 30 seconds of it being changed? So if I change it to 1 from an external script, I want to 30 seconds later to change to 0. Is this possible without a script (or a script in sql of some sort?)?

Changing Mysql Port

How do you change the mysql port?