Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Maros h on October 23, 2001, 03:50:29 PM

Title: MySql howto
Post by: Maros h on October 23, 2001, 03:50:29 PM

Well i want to make a database with mysql but don't know where to start..
Do anyone have a link or something where i can get the information how to make a database and get the information out of it with some php pages..

Thanx

Title: Re: MySql howto
Post by: Johan Wijngaard on October 23, 2001, 10:15:01 PM

Hello,

At the first download at www.mysql.com the documentation off Mysql here you can read the basic's of a MySql databse.
Then download here on this site the Mysql admin tool (e-smith-phpmyadmin-0.2-3.noarch.rpm) so you can managed the MySql database on your E-smith box.

Then read or download at www.php.net the documentation off php programming

Look at the internet off ther some where is programming the idee you want, lots of work is al ready done.

good luck

Johan

Title: Re: MySql howto
Post by: Sander on October 25, 2001, 12:13:58 PM

well i downloaded e-smith-phpmyadmin. after install e-smith told me to go to http://localhost:980/phpMyAdmin . For wondering round in the internet i went to my computer and tried to go to the address. But the computer said - dns error.
so when i went to 192.168.0.5:980(this is my servers internal nic)/phpMyAdmin it said the following error :

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /etc/e-smith/web/panels/manager/html/phpMyAdmin/lib.inc.php3 on line 255
Error
MySQL said:
Back

what is wrong? i havent done anything with mysql. I dont know how to deal with it. Can anyone help me on how to change the admin password of mysql.

Thanks
Sander

Title: Re: MySql howto
Post by: steve macgregor on October 25, 2001, 12:41:19 PM

sender,

I have not used the rpm install of phpmyadmin, but I do know that when I put
it in an ibay, I need to go in and edit lib.inc.php adding the mysql root pw,
and of course root for the username. One other thing (and it might just be
that it was an old version) but I needed to change 'host' to 'localhost.'
Other than that info, I think it is very easy to set up without the RPM by
just putting it in the ibay.

regards,

steve

Title: Re: MySql howto
Post by: Sander on October 30, 2001, 04:09:13 PM

i wanted mysql for setting up a forum.
i got phpbb almost working. but it does not support any smiles. :(
when i make a new topic and put thesre some smiles it says: it tries to make an image and  SRC="/php/images/smiles/">

what is wrong?
when i installed phpbb (from my computer not in server) i specified the address as localhost not the domain.

if you like you can see the forum at raie.dyndns.org/php

Sander