cent7.0 MySQL Modify port

2. How to view MySQL default port number and modify port number 2015-03-19 17:42:18
8. 1. Log in to MySQL
12. [Email protected]/]# mysql-u root-p
14. Enter Password:
20. 2. Use the command show global variables like ' port '; View port number
24. MySQL> show global variables like ' port ';
26. +---------------+-------+
28. | variable_name | Value |
30. +---------------+-------+
32. | Port | 3306 |
34. +---------------+-------+
36. 1 row in Set (0.00 sec)
42. 3. Modify the port, edit the/etc/my.cnf file, the earlier version may be the my.conf file name, add the port parameter, and set the port, note that the port is not used, save exit.
46. [Email protected] etc]# VI my.cnf
48. [Mysqld]
50. port=3506
52. Datadir=/var/lib/mysql
54. Socket=/var/lib/mysql/mysql.sock
56. user=MySQL
58. # Disabling Symbolic-links is recommended to prevent assorted security risks
60. symbolic-links=0
64. [Mysqld_safe]
66. Log-error=/var/log/mysqld.log
68. Pid-file=/var/run/mysqld/mysqld.pid
72. "My.cnf" 11L, 261C written
74. [Email protected] etc]#
78. 4. Restart MySQL
82. [Email protected] ~]#/etc/init.d/mysqld restart
84. Stopping mysqld: [OK]
86. Starting mysqld: [OK]
90. 5. After logging in again, check that the port has been modified to ' 3506 '.
94. [Email protected] etc]# mysql-u root-p
96. Enter Password:
98. Welcome to the MySQL Monitor. Commands End With; or \g.
100. Your MySQL Connection ID is 2
102. Server version:5.1.66 Source Distribution
106. Copyright (c), Oracle and/or its affiliates. All rights reserved.
110. Oracle is a registered trademark of the Oracle Corporation and/or its
112. Affiliates. Other names trademarks of their respective
114. Owners.
118. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
122. MySQL> show global variables like ' port ';
124. +---------------+-------+
126. | variable_name | Value |
128. +---------------+-------+
130. | Port | 3506 |
132. +---------------+-------+
134. 1 row in Set (0.00 sec)
138. MySQL>
142. Summary: Note that the modified port should not be occupied, and planning, do not light always adjust the database port. There is security, remember with the person responsible for the network advance notice, so that the port can not be used properly.

cent7.0 MySQL Modify port