MySql
- 2023-05-11 15:24:09
- Post By 高景洋
#按用户查看链接数
select USER , count(*) from information_schema.processlist group by USER;
#查看每个host的链接数
SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM informati
查看全文 | 浏览次数(234)
- 2023-05-01 15:02:20
- Post By 高景洋
use mysql;
set sql_safe_updates=0;
update user set authentication_string=password('12345678') where user='root';
flush privileges;
查看全文 | 浏览次数(201)
- 2023-05-01 14:58:00
- Post By 高景洋
如何修改mysql端口号？
按以下步骤操作，即可实现端口号修改
1、登陆mysql后，执行以下命令，即可查看当前端口号
show global variables like 'port';
2、执行 vi /etc/my.cnf 修改配置文件，增加port=13306参数
[mysqld]
po
查看全文 | 浏览次数(301)
- 2023-03-21 10:05:47
- Post By 高景洋
如何修改mysql 时区为东八区？并将时间设置为北京时间
1、首先查看MySQL当前的时间
> select curtime();
> show variables like “%time_zone%”;
time_zone说明mysql使用system的时区，system_time_zone说明system使用CST时区
查看全文 | 浏览次数(245)
- 2023-01-31 09:55:03
- Post By 高景洋
提示如下错误：
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -
查看全文 | 浏览次数(359)
- 2022-12-13 14:44:33
- Post By 高景洋
3306端口已开放，已配置mysql远程链接，但是提示 “is not allowed to connect to this mysql”，要怎么处理？
操作步骤如下：
1、终端连接mysql
2、执行以下 sql :
use mysql;
select host from user where user='root';
查看全文 | 浏览次数(423)
- 2022-12-13 14:40:20
- Post By 高景洋
1.开启端口3306
firewall-cmd --zone=public --add-port=3306/tcp --permanent
2.重启防火墙
firewall-cmd --reload
3.查看已经开放的端口
firewall-cmd --list-ports
查看全文 | 浏览次数(491)
- 2022-12-13 14:13:29
- Post By 高景洋
如何在linux centos 7 下安装mysql，请看以下步骤~
1、下载MySQL rpm包 wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
2、解压rpm包 rpm -ivh mysql57-community-re
查看全文 | 浏览次数(495)
- 2022-05-07 10:08:01
- Post By 高景洋
安装mysql时，提示以下内容：
The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are con
查看全文 | 浏览次数(1075)
- 2022-03-13 15:25:26
- Post By 高景洋
mysql错误 IP address 'xxxx' could not be resolved: Name or service not known
查看全文 | 浏览次数(732)