Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
No, that should basically work. Is there any information in the server log? –  Felix Frank Jun 17 at 13:05
    
I think I found the problem, the path in mysql 5.6 is not that. It is using the path where the data is stored intead of where mysql is installed. :s. This must be new on this version of mysql –  Joe Jun 17 at 13:15

1 Answer 1

MySQL 5.6 my.ini file is in the path where the data is stored, in my case

C:\Documents and Settings\All Users\Datos de programa\MySQL\MySQL Server 5.6 

instead of the path where mysql is install

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

, like older versions.

We have to change C:\Documents and Settings\All Users\Datos de programa\MySQL\MySQL Server 5.6 \my.ini file to the changes take effect, and restart the service.

On Windows, MySQL programs read startup options from the following files, in the specified order

enter image description here

More info Using options files

You can see configuration options through the following command and look up 'Default options' to see the paths where configuration .ini and .cnf are.

> mysqld --verbose --help

And with this other command you can see mysql variables

> mysqladmin variables
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.