Hello, I am trying to make a registration and login for my website. I am using Dreamweaver currently yet everytime I download MySQL from their website I cant get a connection going. Is there any other way to make a registration and login form for a website without MySQL and it doesn't have to be in php. Any suggestions or codes would be greatly appreciated.
Thank you.

Hiya

did you set up the database on your host for it to connect to?

Yea I set up a MySQL database on my computer and I cant figure out how to get it into Dreamweaver. Anyone know?

i am currently writing a small community site with log in using html, php and mysql but i use mysql on my host.

are you actually hosting the website, php and mysql server on your pc then?

<?php
// Make a MySQL Connection
mysql_connect("localhost", "databaseusername", "databasepassword") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error());
?>

is what i use, but not directly into log in form, you need to include it instead and have this php file in another directory that isn't easy accessible to the public or they could to get your database username and password :-(

Shaz

I dont know the database name, I made it in the MYSQL wizard but it never had me make a database name, and what should I put under localhost?

hmmm i am guessing the database wizard is only the wizard for the connection settings, the actual database is a different thing, you have to set that up on your host
when you do, you will know ..
the database name
the database username
the database password
and the host, mainly you just use "localhost" but thats pending on how your website host has it set up.

in your website host, go to mysql and set up a new database and you will have a little more understanding of what goes where

Shaz

All that the installation has is the root password but no database name. By the way it is called Mysql server instance config wizard. Do you know what the problem is?

Download and install SQLyog (http://www.webyog.com/en/downloads.php) they have a free version.

Open the program, define the connection to your mysqldb ie Host => localhost, username => root , password => mydbpwd

connect, then right click in the left window pane anywhere, and click create database, enter desired name, hit enter, right click newly created db and click create table(s) then create your table layout. click ok, enter table name, click ok again. now you are ready to connect to the db and start adding data.

Word of advice create a new mysql user for your website, along with a good password, and assign that user permission for that database only.

or if you have php configured correctly download and setup on your webserver phpMyAdmin

I got sqlyog and set up the connection but then when i go to my website server on smartftp and upload the registration form. But it doesnt write to the database because it says it cannot connect to localhost on 10061. But I connected fine in sqlyog. Thanks

You dont need much..
if you are using WAMP its simple also, plus its proberly the same.
server = "localhost"
username = "root"
password = ""
database_name = "Name of db u want to use..."

Its simple...