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).
Related Contents:
- ‘IF’ in ‘SELECT’ statement – choose output value based on column values
- How to select the nth row in a SQL database table?
- 1052: Column ‘id’ in field list is ambiguous
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How to do a batch insert in MySQL
- Error Code: 2013. Lost connection to MySQL server during query
- Count the occurrences of DISTINCT values
- What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
- Storing JSON in database vs. having a new column for each key
- MySQL Trigger after update only if row has changed
- difference between primary key and unique key
- Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
- How do I restore a dump file from mysqldump?
- MySQL Query to select data from last week?
- Using an Alias in SQL Calculations
- Adding a leading zero to some values in column in MySQL
- How do I add a custom CHECK constraint on a MySQL table?
- Can a table field contain a hyphen?
- MySQL query, MAX() + GROUP BY
- Cast int to varchar
- View’s SELECT contains a subquery in the FROM clause
- Import SQL file into mysql
- How do I get the ID of multiple inserted rows in MySQL?
- Alternative to using LIMIT keyword in a SubQuery in MYSQL
- How to insert data to MySQL with auto-incremented column(field)?
- MySQL Insert Into from one Database in another
- Calculating a Moving Average MySQL?
- Check for x consecutive days – given timestamps in database
- How to display open transactions in MySQL
- Does mysql have the equivalent of Oracle’s “analytic functions”?
- How to skip certain database tables with mysqldump?
- “where 1=1” statement [duplicate]
- Replace Into Query Syntax
- How to insert a file in MySQL database?
- MySQL: LAST_INSERT_ID() returns 0
- How to get multiple records against one record based on relation?
- MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
- How to set a MySQL row to READ-ONLY?
- FIND_IN_SET with multiple value [duplicate]
- Using reserved words in column names
- What is the difference between SQL and MySQL? [closed]
- Optimistic locking in MySQL
- Strings as Primary Keys in MYSQL Database [closed]
- How to split the name string in mysql?
- MySQL – How to unpivot columns to rows?
- Does MySQL index foreign key columns automatically?
- Why does MySQL allow “group by” queries WITHOUT aggregate functions?
- How to get the latest record in each group using GROUP BY? [duplicate]
- Set value to NULL in MySQL
- Convert datetime value into string