Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-20-2007, 06:56 AM   #1
Beta Member
 
Join Date: Mar 2007
Posts: 5
Unhappy 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..
__________________

kjgizmo is offline   Reply With Quote
Old 03-20-2007, 10:26 AM   #2
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,007
Default 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).
__________________

__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 03-20-2007, 02:30 PM   #3
Beta Member
 
Join Date: Mar 2007
Posts: 5
Default 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 ??
kjgizmo is offline   Reply With Quote
Old 03-20-2007, 04:16 PM   #4
Golden Master
 
DJ-CHRIS's Avatar
 
Join Date: Apr 2006
Posts: 5,203
Send a message via AIM to DJ-CHRIS Send a message via MSN to DJ-CHRIS Send a message via Yahoo to DJ-CHRIS
Default 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
DJ-CHRIS is offline   Reply With Quote
Old 03-21-2007, 09:04 AM   #5
Solid State Member
 
businessgeeks's Avatar
 
Join Date: Feb 2007
Posts: 10
Send a message via ICQ to businessgeeks Send a message via AIM to businessgeeks Send a message via MSN to businessgeeks Send a message via Yahoo to businessgeeks
Default 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
businessgeeks is offline   Reply With Quote
Old 03-24-2007, 01:25 AM   #6
Daemon Poster
 
pctechmike's Avatar
 
Join Date: Jan 2006
Posts: 836
Send a message via AIM to pctechmike Send a message via MSN to pctechmike
Default 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?
__________________
Pctechmike
www.adequateitsolutions.com
Please Add To My Rep If I Helped You
pctechmike is offline   Reply With Quote
Old 04-04-2007, 04:49 AM   #7
Beta Member
 
Join Date: Mar 2007
Posts: 5
Default 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
kjgizmo is offline   Reply With Quote
Old 04-15-2007, 05:25 AM   #8
Daemon Poster
 
RewtGuy's Avatar
 
Join Date: Dec 2004
Posts: 595
Send a message via AIM to RewtGuy
Default 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.
__________________

__________________
Windows: A thirty-two bit extension and GUI shell to a sixteen bit patch to an eight bit operating system originally coded for a four bit microprocessor and sold by a two-bit company that can't stand one bit of competition.
RewtGuy is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:51 PM.


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