How to connect to database through local computer?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to connect to database through local computer?

Postby Carlmagi » 09. November 2015 15:40

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! :|
Carlmagi
 
Posts: 3
Joined: 09. November 2015 15:36
Operating System: Windows

Re: How to connect to database through local computer?

Postby Nobbie » 09. November 2015 15:48

Carlmagi wrote: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)
Nobbie
 
Posts: 8779
Joined: 09. March 2008 13:04

Re: How to connect to database through local computer?

Postby Carlmagi » 09. November 2015 16:54

Its not that, i just need to connect to the IP from a software that administrates DB's?
Carlmagi
 
Posts: 3
Joined: 09. November 2015 15:36
Operating System: Windows

Re: How to connect to database through local computer?

Postby Altrea » 09. November 2015 18:03

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How to connect to database through local computer?

Postby Nobbie » 09. November 2015 19:06

Carlmagi wrote: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.
Nobbie
 
Posts: 8779
Joined: 09. March 2008 13:04

Re: How to connect to database through local computer?

Postby Carlmagi » 09. November 2015 19:29

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..)
Carlmagi
 
Posts: 3
Joined: 09. November 2015 15:36
Operating System: Windows

Re: How to connect to database through local computer?

Postby Altrea » 09. November 2015 20:05

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How to connect to database through local computer?

Postby Nobbie » 09. November 2015 22:18

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


NOTHING.

You have to configure Navicat.
Nobbie
 
Posts: 8779
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests