You can just highlight the path where the 'my. Once the 'Properties' dialog open, highlight and drag your mouse to the right (end) at the text below the 'Path to executable' area to locate where your 'my.ini' file is. If you don't know where to locate that, in Windows, open 'run' dialog and type 'services.msc' then click 'OK'.įind MariaDB/MySQL service name (or whatever custom service name you gave to it), right click it then select 'Properties': Another method you can try is simply checking the 'my.ini/my.cnf' file.In that example, the port is 4238, that is beside the word TCP: You might get result of two or more rows depending on the connection made to your database but the port will all be the same. Netstat -aon | findstr 'PID' then press 'Enter' for example, the 'PID' is 2668 so like this: Open Command Prompt (as administrator if required) then type the following If you have multiple process, note down all of the 'PID' numbers.ī. Navicat for MariaDB supports most of the additional features like new storage engines, microseconds, virtual columns, and more. Connect to local/remote MariaDB servers, and compatible with Amazon RDS. Make sure the database service is running then open task manager > go to 'details' tab and find process name 'mysqld.exe' : Navicat for MariaDB provides a native environment for MariaDB database management and development. If you're using Windows, you can try this method:Ī.

Even if you're not using Navicat, most tools that I know of will always need a specific port for the database connection so if you ever save the connection info on the tools, and the port is unchanged, then you can find it there. If you are currently connected to the database through Navicat, simply click the connection tab Red Hat Enterprise Linux 6.6 or later, CentOS 6.6 or later, Oracle Linux 6.6 or later, Fedora 20 or later, Debian 8.0 or later, SuSE Linux Enterprise 12 or later, Ubuntu 14.04 LTS or later, openSUSE 42.If you haven't connected to the database using Navicat yet and you don't already have the port, then there's no way you can find out the port from Navicat. Mac OS X 10.10 Yosemite, Mac OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra, macOS 10.14 Mojave, macOS 10.15 Catalina, macOS 11 Big Sur, macOS 12 Monterey, macOS 13 Ventura Microsoft Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2008, Server 2012, Server 2016, Server 2019 No behavior changes with how pages look when you are in dark mode. Set dark theme to protect your eyes from the traditionally blinding whiteness of computer.

Navicat mariadb