I have dreamweaver and frontpage and would like to set up a user database where users can register on my site and then login. I want to do this in php and was told I need a MYSQL db. So how do I setup a MYSQL db and how do I get it, where do I download it from? Please can someone help as i'm very baffled
You want to install mysql on your computer?Or just want to make database on your hosting account? Saad
MySQL is usually not something you install yourself unless you are hosting a site on your "localhost" (your own computer). MySQL is usually available from your hosting company and can be found within your control panel. Most hosts offer this for free, but some do require a fee. Your best bet is to ask your host if they do infact offer it. If not, find a host which does.
In addition to that, if your host dosent support mysql then you canot install it there unless you have root acess on your host's server. Saad
Also, as for the actual scripting, you are better off searching google for a "member authentication" script. There are literally thousands of them out there.
Ok i have just asked my host and they say yes they do support MYSQL, my server is linux. I want a register/ login database for my site but do not know how to set one up. I have dreamweaver, frontpage, and have good knowledge in PHP. What else do I need to set up the login, register code on my site, I hear I need a mysql db for it to query? Please help
You should find a login scrpit first and you need mysql only if your script backend is based on mysql moreover do you have any control panel on your hosting? Saad
There should be an option to called mysql databases in your control panel. At least thats the case if your using cpanel. You can then create your database on that page and then create a user as well. Finally add the user to the database and you should be able to access your db.
Im have cpanel xp evolution installed. I have a good login script, and is based on a mysql db. Now how to go about getting a mysql db, shall I google it and download it?
Login to cpanel xp then go to sql section and make one you dont have to download it.It's already installed on your server.. Saad
If you have good knowledge of PHP then look at the PHP functions for mysql, specifically mysql_connect, mysql_query and mysql_result.. You'll also need a working knowledge of SQL I would suggest looking for a tutorial on login scripts with PHP, Sessions and mySQL, and then write it yourself Good Luck!