365bet外围网站-约彩365安卓版本-365dni是真的吃吗

查看本地服务器MYSQL的端口号

查看本地服务器MYSQL的端口号

进入mysql后,输入命令:show global variables like 'port';

具体如下:

~$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

mysql> show global variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+ 1 row in set (0.02 sec)

---------------------

关于如何查看mysql版本:

方法一:

进入mysql cmd,

status; 将显示当前mysql的version的各种信息。

方法二:

还是在mysql的cmd下,输入:

select version();

查看MySQL端口号:

show global variables like 'port'; ------

如何查看mysql 默认端口号和修改端口号

1. 登录mysql

[root@test /]# mysql -u root -p Enter password:

2. 使用命令show global variables like 'port';查看端口号

mysql> show global variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+ 1 row in set (0.00 sec)

3. 修改端口,编辑/etc/my.cnf文件。

[root@test etc]# vi my.cnf [mysqld] port=3506 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0

[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

"my.cnf" 11L, 261C written [root@test etc]#

4. 重新启动mysql

[root@test ~]# /etc/init.d/mysqld restart 或 service mysql restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]

5.再次登录后检查端口已修改为’3506’.

[root@test etc]# mysql -u root -p Enter password:

mysql> show global variables like 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3506 | +---------------+-------+ 1 row in set (0.00 sec)

---------------------