How Do You Login To a MYSQL Database?

M

marvinrulz

New member
Joined
Nov 21, 2005
Messages
3
Im A Newbie and have an account on a hosting server.
And i have created an database called marvin_djlogin and have two user logins.. how do i log into teh database?

Can someone help me please!
 
The logins for a MySQL database aren't so a person can physically "Log In", like you would a website. The username and password for a MySQL database is to be used by code in a Webpage or other applications to give them access to the database contents. In other words, the username and passwords are mainly for programmatical use so that unauthorized programs, webpages, or hackers can't have free access to your data.

Now, if you wanted to view the data in the database, you would use PHPMyAdmin (there should be a link to it in your control panel). You login to PHPMyAdmin with the same Username and Password as you use to log into your control panel.

Louie
 
Thanks.. youve been very helpfull, what i need mysql database for is i want to have a form on my website were people request songs andd complaints and it gets sent to a database were the dj can login and delete some while look at them. (Obviously i have a radio) How can i do this? and i also want a database to show updated stats of the radio...!
 
To do that you will have to use the PHP programming language on your website (since that is the dynamic language installed on a DirectAdmin server) and use it to interface with the database. If you don't know how to do this, you will have to find somebody that does.

I can't help you much here because there a LOT of things you need to know before creating an application like you are talking about, so a few snippets of code here wouldn't help much.

I would recommend using ezSQL with your PHP pages as it makes it VERY easy to create database applications using this PHP class. I have had great results with it! You can find it here:

http://justinvincent.com/home/articles.php?articleId=2

Louie
 
Hmm...It worked when I posted it. Must be something wrong with the server it is hosted on because none of that site will work now. If I find another link, I will find it. Or, you can search for ezSQL on Google.

Louie
 
You must log in or register to reply here.
Back
Top