Mysql – Change MYSQL Port on Windows

MySQLwindows-server-2003

I need some assistance changing the port that MySQL is running on.

So, according to http://dev.mysql.com/doc/refman/5.1/en/option-files.html

MySQL first looks for conf in WINDIR\my.ini, WINDIR\my.cnf ….etc…….

None of these files exist, not even my.ini in the install dir.

Therefore I created my.ini in the install dir…
@C:\Program Files\MySQL\MySQL Server 5.5\my.ini

The contents of the file is:

port=44999

I have tried various things with this ini, I used the examples, but when ever I go to services.msc and restart the MySQL55 service after having saved the updated ini, it always freakin starts on the default port 3306

Best Answer

Looking at the command line in the services console (services.msc) will tell you specifically where the proper .ini file is, and then you can modify that file (and hopefully get the results you want).

The command line specified for the service is shown in the Service's properties dialog. To find it:

Right-click on the service name
Click properties

Read the "Path to executable:" value. This is the command line used for the service. MySql will specify the --defaults-file option which has a path to the my.ini file.

Related Solutions

Mysql – thesqld crashes on any statement

See here: http://bugs.mysql.com/bug.php?id=44030

Philip S

I had the same issue. I tried upgrading from 5.1.33 to 5.1.36, but mysqld would still crash whenever accessing the database.

Some details, most of it probably irrelevant, but maybe something will pop out: This is a brand new laptop, and I just started on a new project. MD Turion X2 Dual-Core Mobile RM-74 w/4GB RAM DB size on disk is 1.67GB 1GB of RAM is being used as a ramdisk Fresh install of 5.1.33 on MS Vista 64 using the WAMP project installer. A lot of ALTERs, as this is a dev environment. Adding columns, indexes, etc. Renaming columns as well. The bug cropped up between coding sessions rather than during a coding session. All db schema was created using MySQL Administrator, and all data manipulation done using php and mysqli. Everything wrt MySQL is brand new. I'm sorry, I'm unable to provide data files.

Anyway, as the upgrade didn't work to allow me to access the data, and a lot of work occurred since my last backup, I wanted to restore/retrieve as much of the DB schema as possible, I wasn't concerned with data. I actually did retrieve most of the data as well. While I'm sure the process can be optimized, what worked for me is: C:\wamp\bin\mysql\mysql5.1.36\bin>mysqlshow.exe -u root then for each table C:\wamp\bin\mysql\mysql5.1.36\bin>mysqlshow.exe -u root until I got the error mysqlshow.exe: Cannot list columns in db: , table: : Lost connection to MySQL server during query then I restarted mysqld, started the MySQL console, and \u drop table for the table which caused the crash. After that, everything was back to normal other than the loss of the one small table which I should be able to recreate easily.

Centos – MySQL remote access not working – Port Close

# nmap -sT -O localhost -p 3306
...
PORT     STATE  SERVICE
3306/tcp closed mysql
...

In the above command you are getting port close because your mysql is running on the specific IP and not on localhost. So, when you will run this command on the server, it will show the port is closed. So this makes sense. If you want that to work, you need to replace the bind-ip with value 0.0.0.0

So, Can you please replace localhost with server-ip and post the output here.

Also, I know you have disable the firewall but still but be great if you can help me with these couple of commands:

iptables -L -n

cat /etc/hosts.deny

Also, have you done any optimizations in mysql and changed any values for any variables. If yes, then please post the same also.