msql database 2 questions... should be easy

Wolfsraider

Diamond Member
Jan 27, 2002
8,305
0
76
Back in PuTTY, at the UNIX prompt, we need to configure phpMyAdmin to recognize 1&1 server settings. To do so, change to the phpMyAdmin directory and edit the config.inc.php file with vi or joe. Only the following changes must be made:



$cfg['PmaAbsoluteUri'] = '';
Change this setting to reflect the full pathname and the directory where phpMyAdmin is located. For example: 1&1.com/phpMyAdmin

$cfg['Servers'][$i]['host'] = '';
Place the host name here

$cfg['Servers'][$i]['auth_type'] = 'config';
Make certain this option is set to config. It may be there by default.

$cfg['Servers'][$i]['user'] = '';
Your mySQL username

$cfg['Servers'][$i]['password'] = '';
Your mySQL password

$cfg['Servers'][$i]['only_db'] = '';
Your database name



how do i get to the phpMyadmin directory?what is meant by vi or joe?
 

Nothinman

Elite Member
Sep 14, 2001
30,672
0
0
Whoever asked you to do this should tell you where phpMyAdmin is located. If not, you could use the 'find' command to look for config.inc.php.

joe and vi are unix text editors.
 

Wolfsraider

Diamond Member
Jan 27, 2002
8,305
0
76
thanks

what i need to do is learn what i'm doing

i got the phpmyadmin uploaded and edited as per instructions

man trying to understand how to use this stuff is a pita,when i hear you folks saying this is the easiest way...i am always thinking compared to what?

guess i need to learn the commands and functions for php,simply following along blind,while it does work thru trial and error,is not how i want to run a website.

off to google for a better understanding.

until testerday i had only used ftp maybe half a dozen times
never used putty,tried to use a tar file but never suceeded,never heard of wget,never used ssh,etc...

so yes i am pretty much finding out how much of a newb i am.

mike

 

Nothinman

Elite Member
Sep 14, 2001
30,672
0
0
Welcome to the wonderfull world of unix. Once you get accustomed to it you'll find Windows to be the strange and annoying OS.
 

Wolfsraider

Diamond Member
Jan 27, 2002
8,305
0
76
thats if i can rid myself of the "windows remembers everything i was too lazy to learn syndrome"

i have gotten those fixed

and found joe lol

got the php setup

entered the correct parameters in the config doc


but the thing is there are two domains sharing the same web space

i need to divide the webspace so i can have 2 domains with different websites

i cant figured out the commands nessary to do this

i get a ./ directory a ../ directory phpMyAdmin-2.5.3 directory and a phpMyAdmin-2.5.3.tz.gz directory
plus the logs directory

the websites are supposed to reside in ./ and /wsc98 etc... but the second one doesn't exist lol

as you can see young padawan has much to learn

so off to find more answers

oh anybody got some good websites to do some major teaching in the following areas
php
mysql
unix
tutorials on vi or joe
security (website,general) hints etc..
i have access to coldfusion,but most of the themes are kiddie looking,is there better ones?can i just import my buttons,banners etc on the blank site...

phew

thanks to:
nothing man for the tips
gluck for the php resources

links, pm's or tips appreciated

mike