blocks|key|2218764|text|如果您使用的是archlinux，那么理解包管理器(pacman)是一个至关重要的想法。对于关于/etc/my.cfg的问题，您可以运行|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2218765|pacman+-Ql+mariadb|code-block|syntax|javascript|2218766|在那里，您将看到该文件实际上名为：|2218767|/etc/mysql/my.cnf|2218768|2218769|Arch+linux将不会为您配置包，这是arch+的一部分。它将提供示例配置，甚至为您提供一个systemd单元文件|BOLD|2218770|usr/lib/systemd/system/mysqld.service|2218771|但您有责任确保配置正确并实际启动守护进程。|2218772|systemctl+enable+mysqld+++#+add+the+unit+file+to+the+boot+sequence
systemctl+start+mysqld++++#+runs+ExecStart=+in+the+unit+file
systemctl+stop+mysqld+++++#+kills+the+daemon
systemctl+disable+mysqld++#+remove+unit+from+boot+sequence|2218773|2218774|重新安装|2218775|由于重新安装这个词出现在问题的标题中，因此有人可能会发现这个问题:要重新安装mariadb，您只需执行以下操作|2218776|pacman+-S+mariadb|2218777|pacman将重新安装已经安装的软件包，不需要删除该软件包(为了完整性，pacman+-R会删除软件包)|2218778|entityMap^0|7|9|Q|6|1C|B|0|0|0|0|0|L|12|1C|7|0|0|0|L|0|0|0|0|4|0|0|1J|12|7|0|0|0|1G|0|6|10|9|0^^$0|@$1|2|3|4|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1H|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|1I|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1K|8|@$9|1L|A|1M|B|R]|$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|S|3|T|5|H|7|1P|8|@]|D|@]|E|$I|J]]|$1|U|3|V|5|6|7|1Q|8|@$9|1R|A|1S|B|R]]|D|@]|E|$]]|$1|W|3|X|5|H|7|1T|8|@]|D|@]|E|$I|J]]|$1|Y|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]|$1|Z|3|10|5|6|7|1V|8|@$9|1W|A|1X|B|R]]|D|@]|E|$]]|$1|11|3|12|5|6|7|1Y|8|@$9|1Z|A|20|B|R]|$9|21|A|22|B|C]]|D|@]|E|$]]|$1|13|3|14|5|H|7|23|8|@]|D|@]|E|$I|J]]|$1|15|3|16|5|6|7|24|8|@$9|25|A|26|B|R]|$9|27|A|28|B|C]|$9|29|A|2A|B|C]]|D|@]|E|$]]|$1|17|3|-4|5|6|7|2B|8|@]|D|@]|E|$]]]|18|$]]

If you're using <code>archlinux</code> it is a vital idea to understand the package manager (<code>pacman</code>). For the question about <code>/etc/my.cfg</code> you can run

<pre><code>pacman -Ql mariadb
</code></pre>

there you will see that the file is actually called:

<pre><code>/etc/mysql/my.cnf
</code></pre>

<hr>

Arch linux will not configure the package for you, that is part of the arch philosophy. It will provide example configurations, and even provide you with a <code>systemd</code> unit file

<pre><code>usr/lib/systemd/system/mysqld.service
</code></pre>

but it is your responsibility to ensure that the configuration is correct and actually start the daemon.

<pre><code>systemctl enable mysqld # add the unit file to the boot sequence
systemctl start mysqld # runs ExecStart= in the unit file
systemctl stop mysqld # kills the daemon
systemctl disable mysqld # remove unit from boot sequence
</code></pre>

<hr>

<h1>reinstall</h1>

Since the word reinstall is in the title of the question and someone might find this question thanks to that: To reinstall <code>mariadb</code> you simply do

<pre><code>pacman -S mariadb
</code></pre>

<code>pacman</code> will reinstall a package that is already installed, there is no need to remove the package (for completeness, package removal happens with <code>pacman -R</code>)

blocks|key|310810|text|CNF文件在Arch+Linux中为/etc/mysql/my.cnf。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|310811|当MariaDB关闭时，我可以用一种简单的方法来重现您的问题。很抱歉，如果这听起来很愚蠢，但正如您没有提到的:+MariaDB启动了吗？sudo+systemctl+start+mysqld.service|310812|你应该看看MariaDB日志来获得一些线索：journalctl+_SYSTEMD_UNIT=mysqld.service+(如果你仍然不明白发生了什么，可以粘贴一些部分)。|310813|entityMap^0|I|H|0|1W|Z|0|M|13|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|K|$]]

CNF file is <code>/etc/mysql/my.cnf</code> in Arch Linux.

One simple way I can reproduce your issue is when MariaDB is shut down. Sorry if it sounds dumb but as you did not mention it: is MariaDB started? <code>sudo systemctl start mysqld.service</code>

You should have a look at MariaDB logs to get some clue: <code>journalctl _SYSTEMD_UNIT=mysqld.service</code> (maybe paste some part if you still don't get what is going on).

blocks|key|5320926|text|从7-28-17开始，我必须在新的安装上执行此操作。新手可能会节省一些时间。这真是一件痛苦的事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5320927|好吧，这就是交易！安装APACHE+_+NO探测|5320928|在启动服务前安装MYSQL+_PROBLEM+pacman+-S+mysql|5320929|5320930|必须在以下位置取消注释INNODB：|ordered-list-item|5320931|5320932|在启动服务之前，nano+/etc/mysql/my.cnf|5320933|then必须初始化数据目录：|unordered-list-item|5320934|5320935|用户--+mysql_install_db+=mysql+--basedir=/usr+--datadir=/var/lib/mysql|5320936|在启动服务之前，您需要初始化MariaDB数据目录。这可以使用mysql_install_db命令来完成，例如:+mysql_install_db+--user=mysql+--basedir=/usr+--datadir=/var/lib/mysql对于mariadb+galera:对于带有Galera+WSREP的MariaDB集群，perl-dbd-mysql:对于mysqlhotcopy，mysql_convert_table_format和mysql_setpermission|5320937|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|10|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|13|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

as of 7-28-17 I had to do this on a new install. Newbie here might save someone some time. It was a real pain.

OK HERE IS THE DEAL!!!!!
INSTALL APACHE _ NO PROB

INSTALL MYSQL _PROBLEM
pacman -S mysql then before starting service

<ol>
<li>MUST UNCOMMENT INNODB IN:

nano /etc/mysql/my.cnf</li>
<li>then must initialize datadirectory before starting service:

mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql</li>
</ol>

You need to initialize the MariaDB data directory prior to starting
 the service. This can be done with mysql_install_db command, e.g.:
 mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Optional dependencies for mariadb
 galera: for MariaDB cluster with Galera WSREP
 perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and
 mysql_setpermission

blocks|key|2218838|text|这在您第一次安装MySQL和MariaDB时发生。正如grochmal所指出的，在第一次使用之前，您必须设置配置。但是，用户teckk在archlinux+newbie+corner中发送了这三个链接|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2218839|2218840|https://wiki.archlinux.org/index.php/MariaDB|ordered-list-item|2218841|https://wiki.archlinux.org/index.php/MariaDB#Reset_the_root_password|2218842|https://bbs.archlinux.org/viewtopic.php?id=51981|2218843|2218844|简而言之，在启动服务之前，您必须运行以下命令：|2218845|sudo+mariadb-install-db+--user=mysql+--basedir=/usr+--datadir=/var/lib/mysql|code-block|syntax|javascript|2218846|您还可以(推荐)通过调用以下命令来执行improve+the+initial+security：|2218847|sudo+mysql_secure_installation|2218848|现在您可以启动服务了：|2218849|sudo+systemctl+start+mariadb|2218850|或者，您也可以安装和使用graphical+front-end+tool。按照archwiki+post+on+MariaDB+Configuration中的说明继续设置配置。|2218851|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/users/6327365/grochmal|1|https://bbs.archlinux.org/viewtopic.php?pid=1962943#p1962943|2|3|4|5|https://wiki.archlinux.org/index.php/MariaDB#Improve_initial_security|6|https://wiki.archlinux.org/index.php/MySQL#Graphical_tools|7|https://wiki.archlinux.org/index.php/MariaDB#Configuration^0|R|8|0|1W|N|1|0|0|0|18|2|0|0|1W|3|0|0|1C|4|0|0|0|0|J|S|5|0|0|0|0|C|O|6|13|12|7|0^^$0|@$1|2|3|4|5|6|7|1M|8|@]|9|@$A|1N|B|1O|1|1P]|$A|1Q|B|1R|1|1S]]|C|$]]|$1|D|3|-4|5|6|7|1T|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|1U|8|@]|9|@$A|1V|B|1W|1|1X]]|C|$]]|$1|H|3|I|5|G|7|1Y|8|@]|9|@$A|1Z|B|20|1|21]]|C|$]]|$1|J|3|K|5|G|7|22|8|@]|9|@$A|23|B|24|1|25]]|C|$]]|$1|L|3|-4|5|6|7|26|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|27|8|@]|9|@]|C|$]]|$1|O|3|P|5|Q|7|28|8|@]|9|@]|C|$R|S]]|$1|T|3|U|5|6|7|29|8|@]|9|@$A|2A|B|2B|1|2C]]|C|$]]|$1|V|3|W|5|Q|7|2D|8|@]|9|@]|C|$R|S]]|$1|X|3|Y|5|6|7|2E|8|@]|9|@]|C|$]]|$1|Z|3|10|5|Q|7|2F|8|@]|9|@]|C|$R|S]]|$1|11|3|12|5|6|7|2G|8|@]|9|@$A|2H|B|2I|1|2J]|$A|2K|B|2L|1|2M]]|C|$]]|$1|13|3|-4|5|6|7|2N|8|@]|9|@]|C|$]]]|14|$15|$5|16|17|18|C|$19|1A]]|1B|$5|16|17|18|C|$19|1C]]|1D|$5|16|17|18|C|$19|F]]|1E|$5|16|17|18|C|$19|I]]|1F|$5|16|17|18|C|$19|K]]|1G|$5|16|17|18|C|$19|1H]]|1I|$5|16|17|18|C|$19|1J]]|1K|$5|16|17|18|C|$19|1L]]]]

This happens the first time you install MySQL and MariaDB. As <a href="https://stackoverflow.com/users/6327365/grochmal">grochmal</a> pointed out, you have to set up configurations before first use. But, the user teckk sent these three links in the <a href="https://bbs.archlinux.org/viewtopic.php?pid=1962943#p1962943" rel="nofollow noreferrer">archlinux newbie corner</a>:
<ol>
<li><a href="https://wiki.archlinux.org/index.php/MariaDB" rel="nofollow noreferrer">https://wiki.archlinux.org/index.php/MariaDB</a></li>
<li><a href="https://wiki.archlinux.org/index.php/MariaDB#Reset_the_root_password" rel="nofollow noreferrer">https://wiki.archlinux.org/index.php/MariaDB#Reset_the_root_password</a></li>
<li><a href="https://bbs.archlinux.org/viewtopic.php?id=51981" rel="nofollow noreferrer">https://bbs.archlinux.org/viewtopic.php?id=51981</a></li>
</ol>
In short, you have to run the command below before starting the service:
<pre class="lang-sh prettyprint-override"><code>sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
</code></pre>
Optionally (recommended) you should <a href="https://wiki.archlinux.org/index.php/MariaDB#Improve_initial_security" rel="nofollow noreferrer">improve the initial security</a> by calling:
<pre class="lang-sh prettyprint-override"><code>sudo mysql_secure_installation
</code></pre>
Now you can start the service:
<pre class="lang-sh prettyprint-override"><code>sudo systemctl start mariadb
</code></pre>
Optionally, you could install and use a <a href="https://wiki.archlinux.org/index.php/MySQL#Graphical_tools" rel="nofollow noreferrer">graphical front-end tool</a>.
Carry on with setting up the configurations as described in the <a href="https://wiki.archlinux.org/index.php/MariaDB#Configuration" rel="nofollow noreferrer">archwiki post on MariaDB Configuration</a>.

I'm trying to use <code>MySQL</code> on Arch Linux. it is already installed but this error comes up when I try to connect:
<pre class="lang-none prettyprint-override"><code>connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 &quot;No such file or directory&quot;)'
</code></pre>
I've looked for <code>/etc/my.cfg</code> but the file does not exist.
Something must have gone wrong during the installation.
How can I &quot;purge&quot; <code>MariaDB</code> and reinstall it?

mysql.sock does not exist error in fresh install of MySQL on Arch Linux

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试在Arch Linux上使用MySQL。它已经安装，但当我尝试连接时出现以下错误：connect to server at 'localhost' failederror: 'Can't connect to local MySQL server through socket '/run/mysqld/mys...

问在Arch Linux上全新安装MySQL时出现mysql.sock不存在错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Arch Linux上全新安装MySQL时出现mysql.sock不存在错误EN