close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

which database?

Thread began 6/16/2010 10:23 am by lagreen284256 | Last modified 6/22/2010 2:35 pm by Justin Nemeth | 2168 views | 19 replies |

lagreen284256

which database?

I dont have MySql installed on server can I use the Microsoft SQL Database? If so How do I set up SiteAssist to use it ?

Sign in to reply to this post

Justin Nemeth

I assume you actually are using Site Sculptor? It will only work with MySQL, there is no way to get it to work with MSSQL outside or redoing all the database code.

Sign in to reply to this post

lagreen284256

mysql

Iam using Site Sculpture, sorry in wrong forum. I guess I will try to install Mysql.

Sign in to reply to this post

Justin Nemeth

Cool, it is free to setup and will get you going.

Sign in to reply to this post

lagreen284256

My SQL setup

I installed MySql 5.1 and the management end but can not get the CMS to connect to the DB. I am not a DB person and am stopped at the login setup. It will not accept any of my info. I used localhost, database name, user(root) and password, the fields then turn pink/red. (except the database name). Is there anyone who can walk me thru this? I am willing to compensate for time.

ALSO pls understand I will be using this for creating multiple site for several customers, so the info in the databases can't be intermixed.

See attachment

Sign in to reply to this post

neilo

Hiya Les,

Which testing server model do you have running on your machine - i.e. IIS, XAMPP, MAMP (Mac), or WampServer (WAMP5)?

What 'management end' are you using?

You will need to have set the root (super-user) password for mySql during install, - this is the password you will need to enter during the (testing-server) Sculptor install.

You will also need to create a new database within your mySql install for each new site that you develop, - so the 'database' field will be different for each site but the password will be the same each time as the database user will always be 'root' (unless you have created new mySql users/passwords for other people to share the database).

Make sure you are using the super-user (root) password, and that you are entering the name of the database you have created for your sculptor site correctly.

Post back with any queries (and say what testing server model and management client you have installed).

Sign in to reply to this post

LesGreen1943

Over my head, PHP new technology for me.

Which testing server model do you have running on your machine - i.e. IIS, XAMPP, MAMP (Mac), or WampServer (WAMP5)?

A. IIS, this I know. Server 2003 Enterprise x64

What 'management end' are you using?

A. MySQL Workbench 5.1 OSS

You will need to have set the root (super-user) password for mySql during install, - this is the password you will need to enter during the (testing-server) Sculptor install.

A. thought I set it up when installed.

You will also need to create a new database within your mySql install for each new site that you develop, - so the 'database' field will be different for each site but the password will be the same each time as the database user will always be 'root' (unless you have created new mySql users/passwords for other people to share the database).

A. OK, that is good. I need to segregate users and DB.

Make sure you are using the super-user (root) password, and that you are entering the name of the database you have created for your sculptor site correctly.

A. I did but it rejects that.

Sign in to reply to this post

neilo

OK - cheers Les.

Just to check - When you open MySql Workbench to the main Workspace, and click 'Manage Connections' (bottom-left of screen) and select your localhost connection from the left-hand 'Stored Connections' list, does it indicate that a password has been set (stars in the Password field) and if you click the 'Test Connection' button, do you get the 'parameters are correct' message?

I don't think there is a way to reveal the password - the number of stars will match with the number of charcters though. But to be absolutely sure, you could reset your password from the 'Manage Security' option (choose the localhost server to connect to).

[If you do reset your password and happen to use phpMyAdmin locally, you will need to add the new info to your phpMyAdmin/config/config.inc.php]

Sign in to reply to this post

LesGreen1943

Just to check - When you open MySql Workbench to the main Workspace, and click 'Manage Connections' (bottom-left of screen) and select your localhost connection from the left-hand 'Stored Connections' list, does it indicate that a password has been set (stars in the Password field) and if you click the 'Test Connection' button, do you get the 'parameters are correct' message?

A. Yes! It says everything is correct.

I don't think there is a way to reveal the password - the number of stars will match with the number of charcters though. But to be absolutely sure, you could reset your password from the 'Manage Security' option (choose the localhost server to connect to).

A. I know what password is.

[If you do reset your password and happen to use phpMyAdmin locally, you will need to add the new info to your phpMyAdmin/config/config.inc.php][/QUOTE]

Sign in to reply to this post

LesGreen1943

this is what I see on the server

I hope this helps. I can't figure it out.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...