Re: mySQL connection

Yes. You can download a version for your machine:

http://www.mysql.com/downloads/mysql-4.0.html

After you install it, you will also need to install the mySQL odbc
driver so you can use the Data sources panel to add connectivity (Windows).
You can also try using MySQL Front to make administration easier:
http://mysqlfront.sstienemann.de/

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote

Is it possible to create a mySQL database on my local computer and then
upload it to my server, and if so what do I need to make sure to do in my
setup?

I'm sorry for the late reply. You will have to connect to your remote
database using Dreamweaver so when you upload your pages, it will work
without modifying anything. So instead of developing using 'localhost', just
use the MySQL IP or host. I hope this helps.

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote

Yeah I have done all that, I was just wondering how to put the site with
the
mySQL database connected. Do I need to setup it up anyway specific as far
as
passwords and usernames go? I established a connection just using
localhost
and root with no password, but I have a feeling that will not be what I
need
to upload it to the net.

"MMontero - MMTS" <supportinfo (AT) macromedia (DOT) com> wrote in message
news:bems27$cqi$1 (AT) forums (DOT) macromedia.com...
Yes. You can download a version for your machine:

http://www.mysql.com/downloads/mysql-4.0.html

After you install it, you will also need to install the mySQL odbc
driver so you can use the Data sources panel to add connectivity
(Windows).
You can also try using MySQL Front to make administration easier:
http://mysqlfront.sstienemann.de/

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote in message
news:bemq7t$9dr$1 (AT) forums (DOT) macromedia.com...
Is it possible to create a mySQL database on my local computer and
then
upload it to my server, and if so what do I need to make sure to do in
my
setup?

When defining your database connection (from the Databases tab), you can
either use localhost (your local db) or use the one that's live on your web
server. Your hosting company's MySQL server should have a host or IP, that's
what you can put in your connection info. As an example:

BEFORE
------------
Connection Name: ConnTest
MySQL Server: localhost
User Name: sa
Password: sa
Database: MySQL

AFTER
------------
Connection Name: ConnTest
MySQL Server: mysql.site.com
User Name: sa
Password: sa
Database: MySQL

This way, you're directly working on the live database. And when you upload
the pages that
are done, you don't need to worry since everything will be seamless unlike
when working locally.

I hope this clarifies things a bit.

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote

No problem fo rthe late reply I am just getting my info before I start. I
am
a little confused on what you mean by use the MySQL IP or host. Could you
clarify a little?

"MMontero - MMTS" <supportinfo (AT) macromedia (DOT) com> wrote in message
news:bf16h5$3ct$1 (AT) forums (DOT) macromedia.com...
I'm sorry for the late reply. You will have to connect to your remote
database using Dreamweaver so when you upload your pages, it will work
without modifying anything. So instead of developing using 'localhost',
just
use the MySQL IP or host. I hope this helps.

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote in message
news:bemt8d$f1p$1 (AT) forums (DOT) macromedia.com...
Yeah I have done all that, I was just wondering how to put the site
with
the
mySQL database connected. Do I need to setup it up anyway specific as
far
as
passwords and usernames go? I established a connection just using
localhost
and root with no password, but I have a feeling that will not be what
I
need
to upload it to the net.

"MMontero - MMTS" <supportinfo (AT) macromedia (DOT) com> wrote in message
news:bems27$cqi$1 (AT) forums (DOT) macromedia.com...
Yes. You can download a version for your machine:

http://www.mysql.com/downloads/mysql-4.0.html

After you install it, you will also need to install the mySQL odbc
driver so you can use the Data sources panel to add connectivity
(Windows).
You can also try using MySQL Front to make administration easier:
http://mysqlfront.sstienemann.de/

--

Best regards,

Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX

Search the Support Site -
http://www.macromedia.com/support/ultradev/
http://www.macromedia.com/support/dreamweaver/

Macromedia Newsgroups -
http://webforums.macromedia.com/dreamweaverultradev/
http://webforums.macromedia.com/dreamweaver/

"Brad" <bradbrevet (AT) ropeofsilicon (DOT) com> wrote in message
news:bemq7t$9dr$1 (AT) forums (DOT) macromedia.com...
Is it possible to create a mySQL database on my local computer and
then
upload it to my server, and if so what do I need to make sure to
do
in
my
setup?