<div>
a) Is MariaDB or MySQL installed on the system? &nbsp;If so, does it pass its own diagnostics? &nbsp;What is the name of the database you're trying to connect to? 
 
b) Look in the config file. &nbsp;The startup process thinks a port number is being specified and that the host is &quot;localhost&quot; (i.e., the same system, 127.0.0.1) &nbsp;There is a clear conflict in what the startup is reporting: 
 
&nbsp; * hostname you specified &quot;localhost&quot; (default is &quot;localhost&quot;) 
&nbsp; * port you specified &quot;3306&quot; (default is 3306) 
 
&nbsp; resulting in (at least) &quot;Connection error: port cannot be specified when host is localhost or embedded&quot;
</div>

Fractional CTO

David Favor

<div>
Just try this... 
 

<pre><code class="code-1 nolinks" id="code-20-43342004-1">mytop
</code></pre>
 
No options... 
 
If you have a plain vanilla install of MySQL or MariaDB, then mytop will work using either /etc/mysql/debian.cnf (MySQL) or root auth plugin (MariaDB). 
 
Attempting to pass options... mytop will just ignore them... for most versions of mytop... 
 
Also, there's no such file as .mytop ( whatever that might be) so this will be ignored if it exist. 
 
Note: Refer to the man page for what you can + can't supply to mytop.
</div>

<div>
Hi, Check out <a href="https://www.digitalocean.com/community/tutorials/how-to-use-mytop-to-monitor-mysql-performance" rel="ugc">this link</a> on how to configure and connect to a database using mytop. Your root user &nbsp;might be missing the .mytop (thus /root/.mytop) config file. Regards, &nbsp; &nbsp; Tomas Helgi 
</div>

<div>
The server is running the latest mariadb service and everything works fine. As I mentioned, I've tried a number of different things and so far nothing works. Without a /root/.mytop config file, I get this. <pre><code class="code-10 nolinks" id="code-20-43342169-1"># mytop
Use of uninitialized value $ENV{"HOME"} in concatenation (.) or string at /usr/bin/mytop line 136.
Cannot connect to MariaDB/MySQL server. Please check the:

&nbsp; * database you specified "" (default is "")
&nbsp; * username you specified "root" (default is "root")
&nbsp; * password you specified "" (default is "")
&nbsp; * hostname you specified "localhost" (default is "localhost")
&nbsp; * port you specified "3306" (default is 3306)
&nbsp; * socket you specified "" (default is "")

The options my be specified on the command-line or in a ~/.mytop or
~/.my.cnf config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Connection error: port cannot be specified when host is localhost or embedded


</code></pre>No matter if I try entering the options on the command line or in the config file, I get errors. Mostly it complains about the port, other times it complains about other things. With the config file suggested in the link posted; <pre><code class="code-1 nolinks" id="code-20-43342169-2">host=localhost
db=mysql
delay=5
port=3306
socket=
batchmode=0
color=1
idle=1
</code></pre>I get the exact same port error. I had tried this exact config and other variations but always some errors. The /etc/mysql/my.cnf file does not have the port in there. Could it be as simple as that?
</div>

Screenshot-from-2021-09-25-13-39-50.png

Just gotta ask!

Mike

<div>
The use of a .mytop file seems to only apply to some versions of mytop. 
 
The mytop I'm running (Ubuntu Focal) doesn't document this file as being used + if I create ~/.mytop + camp on it with inotifywait, then the file is opened, so I'd verify your version of mytop actually accesses this file, before investing time setting it up. 
 
In Debian, you should never have any concern about this, as /etc/mysql/debian.cnf is setup by default for MySQL or with MariaDB, installed from the project's repositories (best option) the root authentication plugin runs automatically. 
 
In either case, if mytop fails, that means 2x likely possibilities. 
 
1) Your runtime environment is munged/destroyed. This is best fixed as future package updates + many other housekeeping functions will fail. 
 
2) You're running as a non-root user, so if you create a ~/.mytop file, you've just exposed your root db login to any hacker accessing your machine. 
 
Having cleansed many a machine of hacks, best to avoid this security hole... by fixing #1, if required, then only running mytop as the root user, so if required... 
 

<pre><code class="code-1 nolinks" id="code-20-43342510-1">sudo mytop
</code></pre>
</div>

<div>
<div class="content wysiwyg-content fr-view">
<div><div class="content wysiwyg-content fr-view">Not finding anything on the net about this problem that can help. It's installed on Debian 11 and while this shows one try, I've tried many other ways including;mytop mytop -u root -p mytop -u root -d mysql --promptI've also tried with and without a .mycnf file in the /root directory. The so called 'exact' errors never seem to lead to the actual problem. Since I cannot find much info, I don't know for sure if mytop is looking for this file where I have it or somewhere else. I did not find a .mytop file anywhere else on the system. <pre><code class="code-10 nolinks" id="code-10-29224930-1"># mytop
Cannot connect to MariaDB/MySQL server. Please check the:

&nbsp; * database you specified "mysql" (default is "")
&nbsp; * username you specified "root" (default is "root")
&nbsp; * password you specified "" (default is "")
&nbsp; * hostname you specified "localhost" (default is "localhost")
&nbsp; * port you specified "3306" (default is 3306)
&nbsp; * socket you specified "" (default is "")

The options my be specified on the command-line or in a ~/.mytop or
~/.my.cnf config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Connection error: port cannot be specified when host is localhost or embedded

</code></pre></div></div>
</div>
</div>


Not finding anything on the net about this problem that can help.
It's installed on Debian 11 and while this shows one try, I've tried many other ways including;
mytop
mytop -u root -p
mytop -u root -d mysql --prompt
I've also tried with and without a .mycnf file in the /root directory.
The so called 'exact' errors never seem to lead to the actual problem.
Since I cannot find much info, I don't know for sure if mytop is looking for this file where I have it or somewhere else. I did not find a .mytop file anywhere else on the system.
# mytop
Cannot connect to MariaDB/MySQL server. Please check the:

  * database you specified "mysql" (default is "")
  * username you specified "root" (default is "root")
  * password you specified "" (default is "")
  * hostname you specified "localhost" (default is "localhost")
  * port you specified "3306" (default is 3306)
  * socket you specified "" (default is "")

The options my be specified on the command-line or in a ~/.mytop or
~/.my.cnf config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Connection error: port cannot be specified when host is localhost or embedded

mytop on debian won't run

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Debian

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.