How to set up mySQL to the Server

Doan_Du · 11-01-2005, 12:21 AM

My friend has a server and he give me 500 MB on his server. This is a Linux server and supprt PHP script.
Now I want to use database with mySQL on my website. What I must do ?
When I study PHP, I test my PHP script on localhost. I have no experience remote server.
I need all your help.

XZanE · 11-01-2005, 01:53 AM

i always thought that php and mysql go hand in hand so if one was installed it was already installed guess i was wrong.

Doan_Du · 11-01-2005, 10:53 PM

PHP is programing language, mySQL is database management system. They're different.
Some one help me, please

**Grove** · 11-02-2005, 01:03 AM

Hey Doan_Du,

XZanE does have a point. The best combination is PHP and MySQL. I understand the differneces between but they are practically made for each other.

I don't own a Linux System so I have never tried setting up a server there. All that will be needed is to have the server read your mySQL nad php code etc.
Please specify which server to see if I can help you further.

Have a fun and computing day,
Grove

ebackhus · 11-02-2005, 08:46 AM

Modifying mySQL databases is easy! I use them myself on my own server so I'll tell you how it can be done. PHP and mySQL do work wonders together, especially for forums like this one and other things that you want dynamic updating with. In order to actually access the databses you'll need a program that can tap into them. I recommend mySQL Control Center. last I remember it's free and works great for working on databases. You can create servers, drop servers, create databses, add users, set permissions, query, all of that!

~~Jayso~~ · 11-03-2005, 12:35 AM

By the sounds of it you don't actually have a MySQL Database, and if not then kindly ask your friend if you can get one (Ask for phpmyadmin too, as it is a good program for SQL)

Although if you do have access to a Database than you should probably follow the advice of the other ppl (It's still worth asking for phpmyadmin)

tgo · 11-09-2005, 03:49 PM

to check for mysql do

telnet localhost 3306

if it connects then mysql is running. if he doesnt have telnet installed do

netstat -pan

if you see a line like:

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN -

then mysql is listening on 3306 like it should.

Now if he has it he must give you an account on it (unless you have root and you can give yourself an account) and after you get the account wget the phpmyadmin code. untar then nano/pico/vi config.inc.php and in the first server block

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"

make those blank ( for security reasons) and change

$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?

that line to http like i have (its default config) this way when you go to phpmyadmin you will get a .htaccess like box asking for username and password. If you left it as config then you would have to fill contorluser and controlpass and anyone that found your phpmyadmin url would have access to your db.

Good Luck!

Doan_Du · 11-14-2005, 10:33 PM

It's usefull, thanks alot

11-01-2005, 12:21 AM	#1 (permalink)
Doan_Du Registered User Join Date: Nov 2005 Posts: 4 OS: XP	How to set up mySQL to the Server My friend has a server and he give me 500 MB on his server. This is a Linux server and supprt PHP script. Now I want to use database with mySQL on my website. What I must do ? When I study PHP, I test my PHP script on localhost. I have no experience remote server. I need all your help.

11-02-2005, 01:03 AM	#4 (permalink)
Grove Professor/Moderator, TSF Design School Join Date: Jun 2005 Location: Australia Posts: 2,382 OS: Windows XP SP2	Hey Doan_Du, XZanE does have a point. The best combination is PHP and MySQL. I understand the differneces between but they are practically made for each other. I don't own a Linux System so I have never tried setting up a server there. All that will be needed is to have the server read your mySQL nad php code etc. Please specify which server to see if I can help you further. Have a fun and computing day, Grove __________________ ========================================== Get Help: TSF Security Forum \| HijackThis \| MB's 5 Step Process Get Clean: AdAware SE \| Spybot S&D \| CWShredder \| Ewido \| CleanUp! Get Protected: SpywareBlaster \| SpywareGuard \| Windows Updates \| IE-SpyAd If TSF has helped you, please consider making a donation to help keep the board running.

11-02-2005, 08:46 AM	#5 (permalink)
ebackhus Manager, Design Join Date: Apr 2005 Location: SATX Posts: 12,767 OS: WinXP Pro SP3 My System Blog Entries: 25	Modifying mySQL databases is easy! I use them myself on my own server so I'll tell you how it can be done. PHP and mySQL do work wonders together, especially for forums like this one and other things that you want dynamic updating with. In order to actually access the databses you'll need a program that can tap into them. I recommend mySQL Control Center. last I remember it's free and works great for working on databases. You can create servers, drop servers, create databses, add users, set permissions, query, all of that! __________________ ----------------------------- There are no dumb questions, unless a customer is asking them. Help in the fight against cancer and other serious illnesses.

11-09-2005, 03:49 PM	#7 (permalink)
tgo Registered User Join Date: Jul 2005 Posts: 185 OS: slackware 10.1	to check for mysql do telnet localhost 3306 if it connects then mysql is running. if he doesnt have telnet installed do netstat -pan if you see a line like: tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN - then mysql is listening on 3306 like it should. Now if he has it he must give you an account on it (unless you have root and you can give yourself an account) and after you get the account wget the phpmyadmin code. untar then nano/pico/vi config.inc.php and in the first server block $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" make those blank ( for security reasons) and change $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? that line to http like i have (its default config) this way when you go to phpmyadmin you will get a .htaccess like box asking for username and password. If you left it as config then you would have to fill contorluser and controlpass and anyone that found your phpmyadmin url would have access to your db. Good Luck! __________________ My new homepage:

11-01-2005, 01:53 AM	#2 (permalink)
XZanE Registered User Join Date: Nov 2004 Location: Brisbane, Australia Posts: 173 OS: Windows Vista	i always thought that php and mysql go hand in hand so if one was installed it was already installed guess i was wrong.

11-01-2005, 10:53 PM	#3 (permalink)
Doan_Du Registered User Join Date: Nov 2005 Posts: 4 OS: XP	PHP is programing language, mySQL is database management system. They're different. Some one help me, please

11-03-2005, 12:35 AM	#6 (permalink)
~~Jayso~~ Register user Join Date: Nov 2005 Location: Australia Posts: 66 OS: Dual-Boot: Microsoft Windows XP x64 Edition & Red Hat Linux Fedora Core 4 My System	By the sounds of it you don't actually have a MySQL Database, and if not then kindly ask your friend if you can get one (Ask for phpmyadmin too, as it is a good program for SQL) Although if you do have access to a Database than you should probably follow the advice of the other ppl (It's still worth asking for phpmyadmin)

11-14-2005, 10:33 PM	#8 (permalink)
Doan_Du Registered User Join Date: Nov 2005 Posts: 4 OS: XP	It's usefull, thanks alot