Server Help Forum Index Server Help
Community forums for Subgame, ASSS, and bots
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   StatisticsStatistics   RegisterRegister 
 ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin (SSL) 

Server Help | ASSS Wiki (0) | Shanky.com
MySQL
Goto page 1, 2  Next
 
Post new topic   Reply to topic Printable version
 View previous topic  New SS graphic site launched Post :: Post   View next topic  
Author Message
Donkano
Server Help Squatter


Gender:Gender:Male
Joined: Jul 02 2003
Posts: 763
Offline
PostPosted: Fri Oct 01, 2004 11:32 pm   Post maybe stupid    Post subject: MySQL Reply to topic Reply with quote
I know that this has nothing to do with Continuum, but but how do I set up a MySQL database? (Honestly, I have never done it before so bear with me)
Back to top
View users profile Send private message Add User to Ignore List
Donkano
Server Help Squatter


Gender:Gender:Male
Joined: Jul 02 2003
Posts: 763
Offline
PostPosted: Fri Oct 01, 2004 11:33 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Crap! Meant to post in General Questions!
Back to top
View users profile Send private message Add User to Ignore List
Night_Fox
dark_mistress is too sexy for me


Age:54
Gender:Gender:Female
Joined: Jan 24 2004
Posts: 252
Offline
PostPosted: Sat Oct 02, 2004 12:13 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
You have a web server to run it?
Info:
http://forums.devshed.com/t44152/s.html
http://www.blue105.com/internet/support/mysql_offline.html
http://www.vbulletin.com/forum/showthread.php?t=96200
http://www.uniqhost.com/howto-mysql.php
Back to top
View users profile Send private message Add User to Ignore List
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Sat Oct 02, 2004 7:19 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
What would you need a "web server" for? Just run it on your own computer. icon_confused.gif

Go to MySQL's official website, download the installer for Windows and install it.

Get a graphical administration client (you can use SQL to change settings but that's harder than using a graphical client which does it for you) like MySQL CC.

Notice: your MySQL server's account with the highest access level: "root", is not protected with a password yet.

Log in using MySQL CC, use "root" as username and no password.

Change the root password, then create other accounts for your other work.
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline
PostPosted: Sat Oct 02, 2004 11:15 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
I got a web server for it and the software I use for it is in a big package that supports PHP, MySQL, Apache and CGI
Back to top
Donkano.
Guest


Offline
PostPosted: Sat Oct 02, 2004 11:23 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
BTW, the package i got is called EasyPHP1-7
Back to top
Donkano.
Guest


Offline
PostPosted: Sat Oct 02, 2004 11:44 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
Well, I installed that MySQLCC and I am trying to add it with the server (which the server is at my house) and it won't work.

Here is my Info:

Name: Digital Vortech
Host Name: website-host.ath.cx
Username: root
Password: ******
Port: 3306

and it still fails.
Back to top
Donkano.
Guest


Offline
PostPosted: Sat Oct 02, 2004 11:46 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
Actually, if anyone could, netmeeting (comes with all versions of Windows) this address: website-host.ath.cx

It would be so much easier for both sides if someone just did it remotely tongue.gif
Back to top
Night_Fox
dark_mistress is too sexy for me


Age:54
Gender:Gender:Female
Joined: Jan 24 2004
Posts: 252
Offline
PostPosted: Sat Oct 02, 2004 3:47 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
You need a webserver to run it doh! Like apache or something....
Back to top
View users profile Send private message Add User to Ignore List
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Sat Oct 02, 2004 3:58 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
No you don't, haha.

DOH!`1¬
Back to top
View users profile Send private message Add User to Ignore List
Dustpuppy
Server Help Squatter


Age:40
Gender:Gender:Male
Joined: Jan 23 2003
Posts: 215
Location: England
Offline
PostPosted: Sat Oct 02, 2004 4:06 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Night_Fox wrote:
You need a webserver to run it doh! Like apache or something....

OK she doesn't know what she's talking about so ignore her.

When you say it doesn't work, what do you mean? That really doesn't help at all. Describe what you're doing and where you think it's going wrong.
_________________
Back to top
View users profile Send private message Add User to Ignore List Send email Visit posters website
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Sat Oct 02, 2004 7:53 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Why are you giving that account info? A MySQL server isn't used as some public webserver, mostly, so it's not like anyone of us is going to check your MySQL server out.

What error are you getting?
For some errors the MySQL manual has some tips on solving your problems.

Did you specify a password which shouldn't be used?

I see in the account information you posted that you are using a password, as I said in a previous post:
Solo Ace wrote:
Notice: your MySQL server's account with the highest access level: "root", is not protected with a password yet.

So first you have to login without any password for the root user, because a password is not set yet.
Change the password in the user administration of the root account (you can only do this after logging in, of course), then change it in your account login information too.

If that wasn't the problem, maybe there's a networking problem?

Did you try connecting to "localhost" instead of to that other address?

Are you sure the server is up?
Check it in the service list of your computer or your task manager (ctrl + alt + del).

See which IPs it's using by running netstat in a command prompt.
Go to Start -> Run, type "cmd" on Windows XP or "command" on 9X, type netstat -an | find ":3306" in the command prompt and hit the Enter key.
This will run netstat and output all active IP's with port 3306.

It should be listening on your local loopback and it should run on your local LAN IP (or on "0.0.0.0" which stands for all available).

When trying to connect from outside your local LAN make sure port 3306 (TCP) is routed to the system which is running the MySQL server.
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline
PostPosted: Sun Oct 03, 2004 12:33 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Okay, I got rid of MySQLCC cause I found the segment in my package with MySQL in and I don't know how to connect things up to it.

There is a guide at http://www.canowhoopass.com/guides/easyphp/setupmysql.php but it doesn't really help me. I have no idea where to put the stuff and what not.




Another issue, I cann't access my MySQL directory through IE. It says the page is forbidden for me to enter.
Back to top
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Sun Oct 03, 2004 12:35 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Wtf?!

Do you have any idea what you're trying to do?
Back to top
View users profile Send private message Add User to Ignore List
k0zy
Server Help Squatter


Gender:Gender:Male
Joined: Jan 11 2003
Posts: 571
Location: Germany
Offline
PostPosted: Sun Oct 03, 2004 12:58 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Solo Ace wrote:
Wtf?!

Do you have any idea what you're trying to do?


Exactly what I was thinking...
_________________
It's a shark! Oh my god! Unbelievable!
Back to top
View users profile Send private message Add User to Ignore List
CypherJF
I gargle nitroglycerin


Gender:Gender:Male
Joined: Aug 14 2003
Posts: 2582
Location: USA
Offline
PostPosted: Sun Oct 03, 2004 1:53 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Rotfl EasyPHP.. just take the time to learn how to install each component separately...
_________________
Performance is often the art of cheating carefully. - James Gosling
Back to top
View users profile Send private message Add User to Ignore List
Versetti
Novice


Gender:Gender:Male
Joined: Jan 05 2004
Posts: 54
Offline
PostPosted: Sun Oct 03, 2004 3:15 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Well MySQL has it's own user database and it has a CUI Client. Default is the root of the MySQL does not have a pw but is binded to 127.0.0.1. Also what it could be is your configurations. Also MySQL is not related to anyother web server it can run standalone.
Back to top
View users profile Send private message Add User to Ignore List AIM Address MSN Messenger
Dustpuppy
Server Help Squatter


Age:40
Gender:Gender:Male
Joined: Jan 23 2003
Posts: 215
Location: England
Offline
PostPosted: Sun Oct 03, 2004 4:27 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Solo Ace wrote:
Wtf?!

Do you have any idea what you're trying to do?
Back to top
View users profile Send private message Add User to Ignore List Send email Visit posters website
D1st0rt
Miss Directed Wannabe


Age:37
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline
PostPosted: Sun Oct 03, 2004 7:27 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
http://www.freesql.org
_________________
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Sun Oct 03, 2004 7:28 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
Gtfo, stop giving him MySQL help, he probably doesn't even know what it is. sa_tongue.gif
Back to top
View users profile Send private message Add User to Ignore List
Smong
Server Help Squatter


Joined: 1043048991
Posts: 0x91E
Offline
PostPosted: Tue Oct 05, 2004 11:17 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
I'd like to point out that there are two root accounts, local and external, you need to change the passwords on both (or delete the external one, it depends on what you want to use mysql for).
Back to top
View users profile Send private message Add User to Ignore List Visit posters website MSN Messenger
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Tue Oct 05, 2004 2:31 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
That's not even the point here, he doesn't know what it is. icon_sad.gif

Guess he just wants to look cool by asking about it, like he did here.

And I guess Night_Fox wanted to look coolar than me by correcting me, and saying MySQL needs a webserver to run on!
"Oh watch me trying to act intelligent and say things I don't know shit about".
Back to top
View users profile Send private message Add User to Ignore List
D1st0rt
Miss Directed Wannabe


Age:37
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline
PostPosted: Tue Oct 05, 2004 8:41 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
^ angry penguin
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
PostPosted: Wed Oct 06, 2004 10:16 am   Post maybe stupid    Post subject: Reply to topic Reply with quote
^- Annoying "Miss Directed Wannabe".
Back to top
View users profile Send private message Add User to Ignore List
CypherJF
I gargle nitroglycerin


Gender:Gender:Male
Joined: Aug 14 2003
Posts: 2582
Location: USA
Offline
PostPosted: Wed Oct 06, 2004 12:18 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote
LOL...
Back to top
View users profile Send private message Add User to Ignore List
Display posts from previous:   
Post new topic   Reply to topic    Server Help Forum Index -> Trash Talk All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
View online users | View Statistics | View Ignored List


Software by php BB © php BB Group
Server Load: 36 page(s) served in previous 5 minutes.

phpBB Created this page in 0.691098 seconds : 49 queries executed (75.8%): GZIP compression disabled