How to change the default port of mysql from 3306 to 3360

Question

I want to change the default port number of MySQL server presently it is 3306  I want to change it to 3360   I have tried   -- port 3360     But things are not working for me  Please provide query to change port not any configuration  I am using Windows 8 64 bit

User · Answer

In Windows 8 1 x64 bit os  Currently I am using MySQL version    Server version  5 7 11-log MySQL Community Server  GPL    For changing your MySQL port number  Go to installation directory  my installation directory is     C  Program Files MySQL MySQL Server 5 7   open the my-default ini Configuration Setting file in any text editor   search the line in the configuration file     port           replace it with    port  lt my new port number gt    like my self changed to    port 15800   To apply the changes don t forget to immediate either restart the MySQL Server or your OS   Hope this would help many one

User · Answer

When server first starts the my ini may not be created where everyone has stated   I was able to find mine in  C  Documents and Settings All Users Application Data MySQL MySQL Server 5 6  This location has the defaults for every setting       CLIENT SECTION   ----------------------------------------------------------------------     The following options will be read by MySQL client applications    Note that only client applications shipped by MySQL are guaranteed   to read this section  If you want your own MySQL client program to   honor these values  you need to specify it as an option during the   MySQL client library initialization     client     pipe   socket 0 0 port 4306                     Change this                    mysql  no-beep  default-character-set utf8

User · Answer

On newer  for example 8 0 0  the simplest solution is  good choice for a scripted start-up for example    mysqld --port 23306

User · Answer

You need to edit your my cnf file and make sure you have the port set as in the following line   port   3360   Then restart your MySQL service and you should be good to go   There is no query you can run to make this change because the port is not a dynamic variable  q v  here for MySQL documentation showing a table of all system variables

User · Answer

The best way to do this is take backup of required database and reconfigure the server   Creating A Backup  The mysqldump command is used to create textfile    dumps    of databases managed by MySQL  These dumps are just files with all the SQL commands needed to recreate the database from scratch  The process is quick and easy   If you want to back up a single database  you merely create the dump and send the output into a file  like so   mysqldump database name  gt  database name sql   Multiple databases can be backed up at the same time   mysqldump --databases database one database two  gt  two databases sql   In the code above  database one is the name of the first database to be backed up  and database two is the name of the second   It is also simple to back up all of the databases on a server   mysqldump --all-databases  gt  all databases sql    After taking the backup  remove mysql and reinstall it  After reinstalling with the desired port number   Restoring a Backup  Since the dump files are just SQL commands  you can restore the database backup by telling mysql to run the commands in it and put the data into the proper database   mysql database name  lt  database name sql   In the code above  database name is the name of the database you want to restore  and database name sql is the name of the backup file to be restored    If you are trying to restore a single database from dump of all the databases  you have to let mysql know like this   mysql --one-database database name  lt  all databases sql

User · Answer

try changing the connection port to 8012 open xampp as administrator Mysql config   gt  my ini change the port from 3306 to 8012 close and run it again I hope it will work

User · Answer

If you re on Windows  you may find the config file my ini it in this directory  C  ProgramData MySQL MySQL Server 5 7    You open this file in a text editor and look for this section     The TCP IP Port the MySQL Server will listen on port 3306   Then you change the number of the port  save the file  Find the service MYSQL57 under Task Manager   Services and restart it

User · Answer

Actually  you can just run the service using  mysqld --PORT 1234  it would force mysql to run on the specified port without change the cnf ini file    I just cought a case that cnf didn t work  It was weired    so I just use the cmd line as the shortcut and it works

User · Answer

Go to installed mysql path and find bin folder open my ini and search 3306 after that change 3306 to 3360

[mysql] How to change the default port of mysql from 3306 to 3360

Examples related to mysql

Examples related to sql

Examples related to database

Examples related to port