Mysql – Error changing thesql 5.6 default port

configurationMySQLwindows

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306.

I've tried in mysql 5.5 and it worked fine.

C:\Archivos de programa\MySQL\MySQL Server 5.6

my.ini

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
port = 3309
# server_id = .....

What am I missing? Is there any bug?

EDIT BY @RolandoMySQLDBA

Please run the following

cd C:\Archivos de programa\MySQL\MySQL Server 5.5
dir
cd C:\Archivos de programa\MySQL\MySQL Server 5.6
dir

and post the output in this question

Best Answer

you need to make sure the correct my.ini is edited, you can check it from windows services by opening MySQL properties and make sure it is related to MySQL 5.6. now you need to stop the service then open the ini file in the service description and edit the port. finally start the service and try to log in from CMD using:

1) cd C:\Archivos de programa\MySQL\MySQL Server 5.6

2) mysql -uroot -Pport -ppassword

Related Question