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: 190
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