Renegade Public Forums
C&C: Renegade --> Dying since 2003™, resurrected in 2024!
Home » Technical Support » Other » MySQL (Quick Quesiton)
MySQL [message #305073] Sun, 23 December 2007 11:31 Go to next message
trooprm02 is currently offline  trooprm02
Messages: 3266
Registered: August 2005
Location: Canada
Karma: 0
General (3 Stars)
Well I got a home webserver up and running, got php, apache, and mysql all setup and going good, but now a question:

1)If I have more than 1 thing that need a mysql database, do I make another one? Or can I use 1 universal database?

2)How do I lookup the name of my database, all the accounts/passwords associated with it, like the things I need are :

username (root?)
password
database name
host (localhost?)


Re: MySQL [message #305074 is a reply to message #305073] Sun, 23 December 2007 11:50 Go to previous messageGo to next message
Ryu is currently offline  Ryu
Messages: 2833
Registered: September 2006
Location: Liverpool, England.
Karma: 0
General (2 Stars)

one database per application.

I.E: if you want to install 2 forums, each forum must have there own database.

not sure about the second one.


Presence is a curious thing, if you think you need to prove it... you probably never had it in the first place.
Re: MySQL [message #305075 is a reply to message #305073] Sun, 23 December 2007 11:53 Go to previous messageGo to next message
trooprm02 is currently offline  trooprm02
Messages: 3266
Registered: August 2005
Location: Canada
Karma: 0
General (3 Stars)
I see, thanks. But, how do you get a 2nd instance running for a 2nd database? Huh Im guessing not using that config editor it comes with, becomes it only edits your current setup? Do you re-run the installer, and just install into a different directory or?

Re: MySQL [message #305095 is a reply to message #305073] Sun, 23 December 2007 13:48 Go to previous messageGo to next message
trooprm02 is currently offline  trooprm02
Messages: 3266
Registered: August 2005
Location: Canada
Karma: 0
General (3 Stars)
Wow, after 349948 websites, I managed to figuire out how to make another database.

The question is still, how do you make another user for a mysql database? Huh


Re: MySQL [message #305206 is a reply to message #305073] Sun, 23 December 2007 19:46 Go to previous messageGo to next message
Ethenal is currently offline  Ethenal
Messages: 2532
Registered: January 2007
Location: US of A
Karma: 0
General (2 Stars)

Download this: http://www.phpmyadmin.net/home_page/index.php
It's a very useful tool for running a MySQL setup. Rocked Over


-TLS-DJ-EYE-K wrote on Mon, 18 March 2013 07:29

Instead of showing us that u aren't more inteligent than a Toast, maybe you should start becomming good in renegade Thumbs Up

Re: MySQL [message #305324 is a reply to message #305073] Mon, 24 December 2007 09:54 Go to previous messageGo to next message
JPNOD is currently offline  JPNOD
Messages: 807
Registered: April 2004
Location: Area 51
Karma: 0
Colonel
Just get WAMP, or XAMPP. That almost speaks for itself.

as for the username. standard is root with empy ww.


WOL nick: JPNOD
Re: MySQL [message #305473 is a reply to message #305073] Mon, 24 December 2007 22:13 Go to previous message
trooprm02 is currently offline  trooprm02
Messages: 3266
Registered: August 2005
Location: Canada
Karma: 0
General (3 Stars)
thats for the tip. yep, heard of phpmyadmin, I already had it installed, but don't have php_mysql.dll setup, which is something Ill get around too.

Everything seems to be working now tho, thanks for the help.


Previous Topic: New processor & ram: Is it worth it?
Next Topic: Looking For Myspace Code
Goto Forum:
  


Current Time: Sat Nov 30 08:44:37 MST 2024

Total time taken to generate the page: 0.00638 seconds