I can't change mysql port (5.6.12) changing the lines of my.ini (windows 8)

Posted by videador on Server Fault See other posts from Server Fault or by videador
Published on 2013-10-20T12:33:22Z Indexed on 2013/10/20 15:56 UTC
Read the original article Hit count: 161

Filed under:
|

I was trying to change the port of my mysql server in my local machine but i can't. The version of mysql is 5.6.12, is an installation from wamp and I am on Windows 8.

I change these lines in my my.ini file located in (C:\wamp\bin\mysql\mysql5.6.12).

[client]
#password   = your_password
port        = 3307
socket      = /tmp/mysql.sock

[wampmysqld]
port        = 3307
socket      = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M

The previous values were 3306.

Ok then I've reset the server installed, but it doesn't works, the mysql server is still running on 3306.

Then, I rename the path of the services with this, to make sure that the my.ini is read by the mysql instance.

c:\wamp\bin\mysql\mysql5.6.12\bin\mysqld.exe --defaults-file="C:\wamp\bin\mysql\mysql5.6.12\my.ini" wampmysqld

But nothing, it stil doesn't works.

My last bullet was to copy the content of my.ini to a file my-default.ini (a file that is placed in C:\wamp\bin\mysql\mysql5.6.12\ and that I don't know what is its mission). However it still doesn't work and the port is still 3306.

© Server Fault or respective owner

Related posts about Windows

Related posts about mysql