Computer Forums

Computer Forums (http://www.computerforums.org/forums/)
-   Server Administration (http://www.computerforums.org/forums/server-administration/)
-   -   Setting up a MYSQL database server (http://www.computerforums.org/forums/server-administration/setting-up-mysql-database-server-159560.html)

kjgizmo 03-20-2007 06:56 AM

Setting up a MYSQL database server
 
Hello

I'm a little new at this, so don't mind the stupid questions :)

I am trying to configure a MYSQL database server, and when I get startet on the configuring I get to following problems:

Adding a new connection:
connection-name : my-database
user : jep..........
password : k..............

Hostname : Problem here.. ?? what's going to stand here ?? something like: 192.168.0.1 `??

port : 3306

Type : Problem here.. ?? Which type is the best to configure a database from.. ??


'Hope u can help me here.. :D

root 03-20-2007 10:26 AM

Re: Setting up a MYSQL database server
 
Yes, put the machines IP address into the server box.

type is unimportant really, it makes a difference to the way that the tables are sorted and stored, but in realiity just accept the default, (unless you want to read up all about it).

kjgizmo 03-20-2007 02:30 PM

Re: Setting up a MYSQL database server
 
Quote:

Originally Posted by root
Yes, put the machines IP address into the server box.

type is unimportant really, it makes a difference to the way that the tables are sorted and stored, but in realiity just accept the default, (unless you want to read up all about it).



I have tried to write the following IP: 192.168.0.1 because I have installed the mysql server database on my desktop, where I also will be running it from. But comes which a error..

what are I'm doing wrong here ??

DJ-CHRIS 03-20-2007 04:16 PM

Re: Setting up a MYSQL database server
 
If you're on the same computer as the database try 127.0.0.1 as the IP

businessgeeks 03-21-2007 09:04 AM

Re: Setting up a MYSQL database server
 
If your using the same computer where you installed MYSQL. I think you can use "localhost" instead of an IP Address.


________________

My Personal Blog: BusinessGeeks -- Finding Offline and Online Businesses
My Website: Pinoy Compuworld - Computers and Information Technology for Pinoys in the Philippines

pctechmike 03-24-2007 01:25 AM

Re: Setting up a MYSQL database server
 
Every MySQL database I have ever setup, the default is usually "localhost" and the username and password you used when you first setup the database. How is this setup? On a Linux box? Any reason why it's running from the desktop?

kjgizmo 04-04-2007 04:49 AM

Re: Setting up a MYSQL database server
 
Quote:

Originally Posted by pctechmike
Every MySQL database I have ever setup, the default is usually "localhost" and the username and password you used when you first setup the database. How is this setup? On a Linux box? Any reason why it's running from the desktop?

I haven't been able to locate me a server yet.. But I have just talked to a friend, so I'm getting a server from him.. But I'll try write "localhost"..

thanx for your help :D

RewtGuy 04-15-2007 05:25 AM

Re: Setting up a MYSQL database server
 
If I am correct, 192.168.0.1 is usually the gateway (router, switch). These people are right if it's on your own box localhost, 127.0.0.1, or even the ip address on your network (assuming it's 192.168.0.2). You could even port forward to yourself (through your router) and connect to yourself through the ip given to you by your isp.

Looks like you're just connecting to the wrong host.


All times are GMT -5. The time now is 12:46 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0