Узнать порт mysql linux

How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don’t remember my username. And for connectivity with JDBC, I need the URL, host and port number. Where do I find all of these?

12 Answers 12

If you’re already logged into the command line client try this:

It will output something similar to this:

+----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.41 sec) 

In my example above, I was logged in as root from localhost .

To find port number and other interesting settings use this command:

If you want to know the port number of your local host on which Mysql is running you can use this query on MySQL Command line client —

SHOW VARIABLES WHERE Variable_name = 'port'; mysql> SHOW VARIABLES WHERE Variable_name = 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+ 1 row in set (0.00 sec) 

It will give you the port number on which MySQL is running.

If you want to know the hostname of your Mysql you can use this query on MySQL Command line client —

SHOW VARIABLES WHERE Variable_name = 'hostname'; mysql> SHOW VARIABLES WHERE Variable_name = 'hostname'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | hostname | Dell | +-------------------+-------+ 1 row in set (0.00 sec) 

It will give you the hostname for mysql.

If you want to know the username of your Mysql you can use this query on MySQL Command line client —

select user(); mysql> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) 

It will give you the username for mysql.

How can I get ip address ? I mean for above example there is ‘DELL’ hostname and can I get ip address instead of name ?

//If you want to get user, you need start query in your mysql: SELECT user(); // output your user: root@localhost SELECT system_user(); // -- //If you want to get port your "mysql://user:pass@hostname:port/db" SELECT @@port; //3306 is default //If you want hostname your db, you can execute query SELECT @@hostname; 

Please add some explanation. Your answer is currently flagged «low quality» and might eventually be removed without.

If you don’t know the exact variable name use like , as the result may contain more than 500 rows:

mysql> show variables like "%port%"; 

If using MySQL Workbench, simply look in the Session tab in the Information pane located in the sidebar.

default-username = root password = you-know-it-better url for localhost = jdbc:mysql://localhost default-port = 3306 

Easiest way is probably using command status; In the output you’ll find database, user, host and port:

mysql> status; -------------- mysql Ver 8.0.13 for Win64 on x86_64 (MySQL Community Server - GPL) Connection id: 43 Current database: mysql Current user: user@localhost SSL: Cipher in use is DHE-RSA-AES128-GCM-SHA256 Using delimiter: ; Server version: 8.0.13 MySQL Community Server - GPL Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: cp852 Conn. characterset: cp852 TCP port: 3306 Uptime: 3 hours 32 min 40 sec Threads: 3 Questions: 197 Slow queries: 0 Opens: 214 Flush tables: 2 Open tables: 190 Queries per second avg: 0.015 -------------- 

Источник

How to Determine Which Port MySQL is Running On

When the MySQL server is configured, the user needs to set the suitable port. Later, a specified port is used to run the MySQL server on the local system. Sometimes, users encounter multiple situations where they want to determine the port number. During that time, multiple SQL queries can be used.

This post will discuss multiple ways to get which port MySQL runs.

How to Find Which Port MySQL is Running?

Multiple commands can be used to get which port MySQL is running on, such as:

• SHOW variable WHERE variable_name = ‘port’;
• SELECT @@port;
• SHOW GLOBAL variable LIKE ‘port’;
• SHOW variable WHERE variable_name in (‘hostname’,’port’);

Let’s check out the working of all commands one by one!

Initially, connect with the MySQL server by executing the following command:

Run the “SHOW” command with a “WHERE” clause to get the port number:

• “SHOW” command will display all specified records.
• “WHERE” clause is utilized for extracting the required records.
• “variable_name” is the resultant column name.
• “port” is added to get the port number.

As you can see, the running port of the MySQL server is obtained as “3306”:

The “SELECT” command can also be used for determining the running port of the MySQL server:

In the above-stated command, the “@@port” is the system variable:

Another way to get the current MySQL running port number is this:

• “GLOBAL variable” statement is used to show the global system variable value.
• “LIKE” clause searches for a provided pattern in the table column:

If you want to get the port number along with the hostname, run the below-provided command:

It can be observed that the hostname is “Haier-PC” and the port number is “3306”:

We have provided different ways to find which port MySQL is running on.

Conclusion

To determine which port MySQL is running on, the “SHOW variable WHERE variable_name = ‘port’;” command, the “SELECT @@port;” command, the “SHOW GLOBAL variable LIKE ‘port’;” command, and the “SHOW variable WHERE variable_name in (‘hostname’,’port’);” command can be used. This post demonstrated several ways to get which port MySQL is running on.

About the author

Maria Naz

I hold a master’s degree in computer science. I am passionate about my work, exploring new technologies, learning programming languages, and I love to share my knowledge with the world.

Источник

Default MySQL/MariaDB Port, Finding It, Changing It

This article will show you how to find the default or current MySQL (or MariaDB) port and how to change it.

What is a Port?

A port is a numerical identifier for a communication endpoint on a computer network. Or, put simpler, it’s a unique number on your computer that points to a specific program that is running so that other programs can connect to it.

MySQL/Maria DB, being networked database services, expose themselves to other computers via a configured port, allowing other computers to connect to and read from the databases being hosted by MySQL.

A port is usually displayed following a : (colon) character:

Where HOSTNAME is the network address or hostname of the computer and PORT is the port number.

Default MySQL Port

This port will be in use on a fresh installation of MySQL.

Changing the MySQL Port

The port is configured in the my.cnf MySQL configuration file. This file is usually located at:

However, the location of this file may vary depending on your OS, so you can find it by running:

If you look through the output, you will be able to see which .cnf file is loaded.

This file can then be edited using the nano text editor by running:

Then, scroll down to the line where the port is configured:

…and change the port number to whatever new port you wish to use.

Finding the current MySQL Port

The netstat command can tell you which port a running process is using and whether it is open:

The above command will list running processes and the ports and interfaces they are bound to – the output will look something like this:

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 27788/mysqld

Under the Local Address column, you can see that MySQL is running on port 3306.

Specifying the Port When Connecting

If you are connecting using the MySQL client from the command line, you can specify the port with the -port option:

mysql --host=localhost --user=username --password databasename --port=3306

If you are using the default port, there is no need to specify it.

If you are connecting from another application, for example, a PHP framework or GUI database manager, that software will provide an option to specify the port, which should be documented in their own documentation.

I’m Brad, and I’m nearing 20 years of experience with Linux. I’ve worked in just about every IT role there is before taking the leap into software development. Currently, I’m building desktop and web-based solutions with NodeJS and PHP hosted on Linux infrastructure. Visit my blog or find me on Twitter to see what I’m up to.

Leave a Comment Cancel reply

SHARE:

RELATED GUIDES

RECENT ARTICLES

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

Источник