How to connect to database through local computer?

[Carlmagi]

Hi ApacheFriends,

First i wanna say IM REALLY NEWBIE!!!

Im using XAMPP 1.8.1 and i need help to connect to my database made on my Windows Server 2008 with XAMPP...

I want to connect to it through MY OWN local computer through navicat. (I DONT want the url.com/phpmyadmin thing)

If you guys can give me a so newbie tutorial or something else it would be great.

(Dont worrie about the XAMPP version, if you have a tutorial for this on the newest version then just give me it)

Thanks very much!

[Nobbie]

I want to connect to it through MY OWN local computer through navicat. (I DONT want the url.com/phpmyadmin thing)

In that case, you are wrong here. If you want to use navicat instead of phpmyadmin, you have to ask in a navicat forum instead of here. You need to know, how to configure navicat.

The credentials for a freshly installed MySQL/MariaDB from Xampp are:

Servername: localhost
Database: (none)
UserId: root
Password: (none - leave empty)

[Carlmagi]

Its not that, i just need to connect to the IP from a software that administrates DB's?

[Altrea]

Hi,

Nobbie already told you everything needed. There is a default user "root" with no password.
Anything beyond this is a navicat topic we cannot provide any support for.

Best wishes,
Altrea

[Nobbie]

Its not that, i just need to connect to the IP from a software that administrates DB's?

Honestly, i do not understand that question.

[Carlmagi]

I need to connect to a database made by XAMPP

And i want to connect to it with the program called Navicat, by MY local computer.

So what do i have to configure with XAMPP so it will work?

Other version of it:

I have XAMPP running on my VPS (Windows Server 2008)
it is running a website like normally, i can connect to the database on the VPS. BUT

I cant connect to the database by my local computer, what do i have to configure?

I know how to connect to the database by using phpmyadmin, but i dont wanna use that because it is too risky to have that on my webpage.

So i want to be able to connect to it

by using the
VPS IP: ---

and the
Username: root

and the
password: ---

And if i am able to that, i am able to connect to the database through Navicat. (Navicat is just a program that makes you edit the database JUST like PHPMyAdmin, but it is just a program and not a webpage..)

[Altrea]

You need to create a new database user who is allowed to get connected from an external host.

Keep in mind that XAMPP is configured to be secure enough as local test and development environment not for public accessible VPS.

[Nobbie]

So what do i have to configure with XAMPP so it will work?

NOTHING.

You have to configure Navicat.