Dreamweaver - php / mysql setup

Author

php / mysql setup

René

2006-03-26, 3:34 am

Hi guy's,

Could anybody help me out on a mysql / PHP problem?

I just installed studio 8, php5, Apache 2 and mysql, the problem is every
time I want to add a database to my site an error message pops up saying I
haven't got the phpmysql module installed.

I am new to PHP and mysql and have no idea how to install these packages.
extra info I have all the newest versions of php, mysql and apache
installed.

To me PHP seem to work fine (phpinfo.php tested ok) also copied the
libmysql.dll to the Windows system directory.

Hopefully somebody can help me out on this.

Thanks in advance and kind regards,

Rene

Nancy *ACE*

2006-03-26, 3:34 am

See David Powers' response to James0816 above 10 threads above this one. :)

--
Nancy Gill
Adobe Community Expert, Dreamweaver MX/UltraDev
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"René" <foruminfo@XXXXXXXXXX> wrote in message
news:e01ito$eot$1@forums.macromedia.com...
> Hi guy's,
>
> Could anybody help me out on a mysql / PHP problem?
>
> I just installed studio 8, php5, Apache 2 and mysql, the problem is every
> time I want to add a database to my site an error message pops up saying I
> haven't got the phpmysql module installed.
>
> I am new to PHP and mysql and have no idea how to install these packages.
> extra info I have all the newest versions of php, mysql and apache
> installed.
>
> To me PHP seem to work fine (phpinfo.php tested ok) also copied the
> libmysql.dll to the Windows system directory.
>
> Hopefully somebody can help me out on this.
>
> Thanks in advance and kind regards,
>
> Rene
>

Ian

2006-03-26, 3:34 am

Better still but his book, it's a great idiot guide- worked for me

Ian
"Nancy *ACE*" <nancy@webwish.com> wrote in message
news:e01jen$fft$1@forums.macromedia.com...
> See David Powers' response to James0816 above 10 threads above this one.
> :)
>
>
> --
> Nancy Gill
> Adobe Community Expert, Dreamweaver MX/UltraDev
> BLOG: http://www.dmxwishes.com/blog.asp
> Author: Dreamweaver 8 e-book for the DMX Zone
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner's
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
>
> "René" <foruminfo@XXXXXXXXXX> wrote in message
> news:e01ito$eot$1@forums.macromedia.com...
>
>

ktrolli

2006-03-26, 3:34 am

Here's your basic problem. PHP 5 does not have mysql support built in - you
have to add it. After spending 3 days w/ Macro/Adobe support trying to get
this to work - let me give you the quick way to get this all to work.

1. Remove php5 from your machine and install php4.2 or lower (They have MySQL
support built in)
2. Once you get PHP installed and sorted out, when you try to connect
Dreamweaver with MySql5, you will get another error - This has to do with
mysql's password hashing - You can do a search for the error code on Google and
the fix is pretty simple - get into SQL console and change the password system
back to the old style - non hashed.

I am as new to this as you - 2 weeks into my first project and not a PHP/ SQL
coder.

Let me know if you run into problems.

K

crash

2006-03-26, 3:34 am

Can you access http://localhost/phpmyadmin/? How are you tryign to add your
database? Have you added a user?

I personally would recommend http://www.apachefriends.org/en/xampp.html.
It's a one-click install that should get you setup with everything you need:
Apache, MySQL, PHP5 etc. also has MyPHPAdmin. It also can run mysql and
Apache as services.

I'm getting ready to take out of here, but you can send me an email at crash
http://cdcdigital.com

"René" <foruminfo@XXXXXXXXXX> wrote in message
news:e01ito$eot$1@forums.macromedia.com...
> Hi guy's,
>
> Could anybody help me out on a mysql / PHP problem?
>
> I just installed studio 8, php5, Apache 2 and mysql, the problem is every
> time I want to add a database to my site an error message pops up saying I
> haven't got the phpmysql module installed.
>
> I am new to PHP and mysql and have no idea how to install these packages.
> extra info I have all the newest versions of php, mysql and apache
> installed.
>
> To me PHP seem to work fine (phpinfo.php tested ok) also copied the
> libmysql.dll to the Windows system directory.
>
> Hopefully somebody can help me out on this.
>
> Thanks in advance and kind regards,
>
> Rene
>

David Powers

2006-03-26, 3:34 am

ktrolli wrote:
> 1. Remove php5 from your machine and install php4.2 or lower (They have MySQL
> support built in)
> 2. Once you get PHP installed and sorted out, when you try to connect
> Dreamweaver with MySql5, you will get another error

Sorry, but that's extremely bad advice. To support mysql 5.0, you need
PHP 5. Setting up support for mysql in PHP 5 is very easy (at least in
Windows).

1. Open php.ini.
2. In the Paths and Directories section, find the following line:
extension_dir = "./"
3. Change the value after the equals sign to point to the ext folder in
your PHP folder, like this (the actual value depends on the location):
extension_dir = "C:\php\ext\"
4. Scroll down to the section that contains a long list of Windows
Extensions.
5. Remove the semicolon from the beginning of this line:
;extension=php_mbstring.dll
6. Find this line:
;extension=php_mysql.dll
7. Copy the line and paste the copy on the next line, and then amend the
two lines like this:
extension=php_mysql.dll
extension=php_mysqli.dll
8. Save php.ini and restart Apache.

Depending on how you set up PHP originally, you may also need to copy
the following files to C:\WINDOWS\system32:

php_mbstring.dll
php_mysql.dll
php_mysqli.dll
libmysql.dll

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

crash

2006-03-26, 3:34 am

I put a video up for internal/external use. There is no troubleshooting
here, just a quick video demonstrating how easy it is to install XAMPP.

:O)

http://cdcdigital.com/vids/XAMPPIns...MPPInstall.html

René

2006-03-28, 6:29 pm

Dear David,

Thank you for your advice. I have set-up the php.ini file as described but
still cant seem to access nor make a data base in dreamweaver 8.

I keep getting the error? ''You don’t have mysql module loaded or you can't
use mysql_(p)connect functions.''

Would you be able to help me on this matter?

Also do I need to take the semicolon from only the beginning of the line
;extension=php_mbstring.dll or do I also need to take it from the other
ones?

Sorry to bother you with all this but don’t know what to do.

Kind regards,

Rene

"René" <foruminfo@XXXXXXXXXX> wrote in message
news:e01ito$eot$1@forums.macromedia.com...
> Hi guy's,
>
> Could anybody help me out on a mysql / PHP problem?
>
> I just installed studio 8, php5, Apache 2 and mysql, the problem is every
> time I want to add a database to my site an error message pops up saying I
> haven't got the phpmysql module installed.
>
> I am new to PHP and mysql and have no idea how to install these packages.
> extra info I have all the newest versions of php, mysql and apache
> installed.
>
> To me PHP seem to work fine (phpinfo.php tested ok) also copied the
> libmysql.dll to the Windows system directory.
>
> Hopefully somebody can help me out on this.
>
> Thanks in advance and kind regards,
>
> Rene
>

David Powers

2006-03-28, 6:29 pm

René wrote:
> Also do I need to take the semicolon from only the beginning of the line
> ;extension=php_mbstring.dll or do I also need to take it from the other
> ones?

Remove the semicolon from the beginning of the following lines:

extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

René

2006-03-28, 6:29 pm

Thanks ever so much David.

It seems to identify mysql now, but now get the error:

MySQL Error # : 2003
Can 't connect to mysql server on 'localhost ' (10061 )

Any ideas?

Sorry to bother you with all this,
Thanks in advance,
Rene

"David Powers" <david@example.com> wrote in message news:e09p95$6t7$2@forums.macromedia.com...
> René wrote:
>
> Remove the semicolon from the beginning of the following lines:
>
> extension=php_mbstring.dll
> extension=php_mysql.dll
> extension=php_mysqli.dll
>
> --
> David Powers
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> Author, "Foundation PHP 5 for Flash" (friends of ED)
> http://foundationphp.com/

David Powers

2006-03-28, 6:29 pm

René wrote:
> Thanks ever so much David.
>
> It seems to identify mysql now, but now get the error:
>
> mysql Error # : 2003
> Can 't connect to mysql server on 'localhost ' (10061 )

MySQL Error #2003 means that the mysql server isn't running. If you
installed it as a Windows service, you can restart it by opening Control
Panel > Administrative Tools > Services. Find mysql and click Start or
Restart in the Services panel. Alternatively, just restart your computer.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

René

2006-03-28, 6:29 pm

David,

Thank you ever so much for all your help, everything is working perfectly
now.

Kind regards,

René

"David Powers" <david@example.com> wrote in message
news:e0bffj$gke$1@forums.macromedia.com...
> René wrote:
>
> mysql Error #2003 means that the mysql server isn't running. If you
> installed it as a Windows service, you can restart it by opening Control
> Panel > Administrative Tools > Services. Find mysql and click Start or
> Restart in the Services panel. Alternatively, just restart your computer.
>
> --
> David Powers
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> Author, "Foundation PHP 5 for Flash" (friends of ED)
> http://foundationphp.com/

David Powers

2006-03-28, 6:30 pm

René wrote:
> Thank you ever so much for all your help, everything is working perfectly
> now.

Great. Have fun. :)

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/