<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>易陆发现互联网技术论坛 - MySql/Mariadb数据库</title>
    <link>http://38.121.62.70/forum-53-1.html</link>
    <description>Latest 20 threads of MySql/Mariadb数据库</description>
    <copyright>Copyright(C) 易陆发现互联网技术论坛</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Wed, 08 Apr 2026 05:46:20 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>http://38.121.62.70/static/image/common/logo_88_31.gif</url>
      <title>易陆发现互联网技术论坛</title>
      <link>http://38.121.62.70/</link>
    </image>
    <item>
      <title>安装mariadb-server-10.5.0版本（yum）</title>
      <link>http://38.121.62.70/thread-3158-1-1.html</link>
      <description><![CDATA[# rpm -qi mariadb-server
Name        : mariadb-server
Epoch       : 3
Version     : 10.3.10
Release     : 1.el7.0.0.rdo2
Architecture: x86_64
Install Date: 2025年08月15日 星期五 22时48分52秒
Group       : Unspecified
Size        : 84783877
License    ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Sat, 16 Aug 2025 02:38:47 +0000</pubDate>
    </item>
    <item>
      <title>数据库使用root用户直接登录问题解决</title>
      <link>http://38.121.62.70/thread-3040-1-1.html</link>
      <description><![CDATA[[root@streamcontrolle ~]# mysql -uroot -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \\g.
Your MariaDB connection id is 16
Server version: 10.5.27-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corpor]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Sat, 15 Feb 2025 00:00:01 +0000</pubDate>
    </item>
    <item>
      <title>mysql数据库优化调整内存</title>
      <link>http://38.121.62.70/thread-2976-1-1.html</link>
      <description><![CDATA[MySQL 性能优化 - 数据库配置优化
MySQL 是一个广泛使用的关系型数据库管理系统，但随着数据量的增长和访问频率的提高，其性能可能会成为瓶颈。为了保持高效的性能，除了应用层的查询优化和索引优化之外，数据库配置优化 也是非常重要的一个方面。通过合理配置 MySQL 的 ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Mon, 18 Nov 2024 07:00:03 +0000</pubDate>
    </item>
    <item>
      <title>通过binlog日志恢复数据</title>
      <link>http://38.121.62.70/thread-2907-1-1.html</link>
      <description><![CDATA[1、执行4.1前置准备中的操作，生成一个新的binlog文件，假设我这里生成新的文件叫做mysql_bin.000004，后续数据的操作日志都会记录在这个日志文件中。

2、准备数据，直接执行本文第三点制作测试数据中的SQL即可。

3、将mysql_bin.000004这个binlog日志归档，因为我们 ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Mon, 12 Aug 2024 02:12:44 +0000</pubDate>
    </item>
    <item>
      <title>\'mysql\' 不是内部或外部命令，也不是可运行的程序 或批处理文件。</title>
      <link>http://38.121.62.70/thread-2895-1-1.html</link>
      <description><![CDATA[\'mysql\' 不是内部或外部命令，也不是可运行的程序 或批处理文件。


如果 已经安装mysql，那就配置环境变量


解决办法：
   设置找到高级系统设置


 系统属性，找到环境变量
   找到系统变量  path参数   添加对应的mysql的bin文件的目录即可。
 ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Wed, 24 Jul 2024 23:15:25 +0000</pubDate>
    </item>
    <item>
      <title>创建mysql用户并创建对应的访问库</title>
      <link>http://38.121.62.70/thread-2886-1-1.html</link>
      <description><![CDATA[创建mysql用户并创建对应的访问库


MariaDB [(none)]&gt;  select distinct(User) from mysql.user;
+-------------+
| User        |
+-------------+
| mariadb.sys |
| mysql       |
| root        |
+-------------+
3 rows in set (0.003 sec)

MariaDB [(none)]&gt; c ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 23 Jul 2024 07:43:31 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 1356 (HY000): View \'mysql.user\' references invalid table(s) or column(s)</title>
      <link>http://38.121.62.70/thread-2885-1-1.html</link>
      <description><![CDATA[update mysql.user set password=password(\'xxxx\') where User=\'root\';
ERROR 1356 (HY000): View \'mysql.user\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 23 Jul 2024 04:51:00 +0000</pubDate>
    </item>
    <item>
      <title>mysql/mariadb数据库创建用户以及远程登录create user</title>
      <link>http://38.121.62.70/thread-2879-1-1.html</link>
      <description><![CDATA[mysql/mariadb创建用户并指定连接地址：
create user xxx@\'localhost\' identified by \'******\';


create user xxx@\'%\' identified by \'******\';


给数据库权限以及地址访问：
grant ALL PRIVILEGES on *.* to \&quot;xxx\&quot;@\&quot;localhost\&quot; Identified by\&quot;xxx\&quot;;

刷新下表空间， ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Thu, 11 Jul 2024 01:00:06 +0000</pubDate>
    </item>
    <item>
      <title>windows下mariadb数据库配置环境变量</title>
      <link>http://38.121.62.70/thread-2868-1-1.html</link>
      <description><![CDATA[找到数据库安装目录bin文件目录：
C:\\Program Files\\MariaDB 11.5\\bin


环境变量配置：
右键点击我的电脑 属性设置&gt;&gt;&gt;&gt;弹出窗口，找到相关设置&gt;&gt;&gt;高级系统设置&gt;&gt;&gt;弹出对话框，在对话框最底下找到环境变量&gt;&gt;&gt;&gt;&gt;弹出新的对话框 &gt;&gt;&gt;&gt;环境变量&gt;&gt;&gt;&gt;

系统变量中点击新建  &gt;&gt; ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 11 Jun 2024 02:31:21 +0000</pubDate>
    </item>
    <item>
      <title>mysql 标记删表操作 drop table快速命令</title>
      <link>http://38.121.62.70/thread-2782-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 26 Dec 2023 15:07:21 +0000</pubDate>
    </item>
    <item>
      <title>MySQL数据库创建只读账号readonly 账号 select 权限</title>
      <link>http://38.121.62.70/thread-2780-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 26 Dec 2023 04:23:23 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 1356 (HY000): View \'mysql.user\' references invalid table(s) or column(s)</title>
      <link>http://38.121.62.70/thread-2661-1-1.html</link>
      <description><![CDATA[ERROR 1356 (HY000): View \'mysql.user\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Sat, 01 Jul 2023 14:59:39 +0000</pubDate>
    </item>
    <item>
      <title>mysql数据命令组合显示删除语句方式concat</title>
      <link>http://38.121.62.70/thread-2657-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Thu, 29 Jun 2023 10:00:16 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constrai</title>
      <link>http://38.121.62.70/thread-2656-1-1.html</link>
      <description><![CDATA[]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Thu, 29 Jun 2023 09:00:19 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 2002 (HY000): Can\'t connect to local server through socket \'/run/mysqld/</title>
      <link>http://38.121.62.70/thread-2619-1-1.html</link>
      <description><![CDATA[ERROR 2002 (HY000): Can\'t connect to local server through socket \'/run/mysqld/mysqld.sock\' (111)
  138  vim /etc/mysql/my.cnf
  139  vim /etc/mysql/conf.d/mysql.cnf 
  140  vim /etc/mysql/conf.d/mysqldump.cnf 
  141  vim /etc/mysql/debian.cnf 
  1]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Mon, 15 May 2023 05:00:00 +0000</pubDate>
    </item>
    <item>
      <title>mysql root用户增加远程和本地登录</title>
      <link>http://38.121.62.70/thread-2597-1-1.html</link>
      <description><![CDATA[MariaDB [mysql]&gt; GRANT ALL PRIVILEGES ON *.* TO \'root\'@\'%\' IDENTIFIED BY \'root\' WITH GRANT OPTION;
Query OK, 0 rows affected (0.012 sec)

MariaDB [mysql]&gt; GRANT ALL PRIVILEGES ON *.* TO \'root\'@\'localhost\' IDENTIFIED BY \'root\' WITH GRANT OPT]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Tue, 02 May 2023 02:00:01 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 1709 (HY000) at line 162: Index column size too large. The maximum column</title>
      <link>http://38.121.62.70/thread-2415-1-1.html</link>
      <description><![CDATA[ERROR 1709 (HY000) at line 162: Index column size too large. The maximum column size is 767 bytes.

在my.cnf文件mysqld中加入：

在创建表时，需要 加 ROW_FORMAT=DYNAMIC 参数：]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Wed, 26 Oct 2022 02:36:35 +0000</pubDate>
    </item>
    <item>
      <title>ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 76</title>
      <link>http://38.121.62.70/thread-2414-1-1.html</link>
      <description><![CDATA[ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 767 bytes

导入数据库时报错：
[mysqld]

innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
[mysql.server]
innodb_file_format =  ...]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Wed, 26 Oct 2022 02:00:33 +0000</pubDate>
    </item>
    <item>
      <title>数据库mariadb删除表操作记录</title>
      <link>http://38.121.62.70/thread-2413-1-1.html</link>
      <description><![CDATA[Database changed
MariaDB [zabbix]&gt; show tables;
+------------------+
| Tables_in_zabbix |
+------------------+
| group_discovery  |
| group_prototype  |
| groups           |
| hosts            |
| maintenances     |
| screen_user      |
| scree]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Wed, 26 Oct 2022 01:58:51 +0000</pubDate>
    </item>
    <item>
      <title>错误： 您的MySQL TimeZone数据库未被填充。 请在继续之前填入此数据库。</title>
      <link>http://38.121.62.70/thread-2393-1-1.html</link>
      <description><![CDATA[[root@ceph1 cacti]# /var/lib/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -uroot -p mysql
Enter password: 
Warning: Unable to load \'/usr/share/zoneinfo//iso3166.tab\' as time zone. Skipping it.
Warning: Unable to load \'/usr/share/zonein]]></description>
      <category>MySql/Mariadb数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Sep 2022 06:22:01 +0000</pubDate>
    </item>
  </channel>
</rss>