mysql_connect

flyer

Dear forum...

I'm new to PHP and MySQL and need some help.

I'm running Mac OS X Panther, Apache, PHP and MySQL.

The story:

I'm working on a site where a user can register, PHP sends an email to the address the user submitted together with a random username and password. The user comes back and tries to login with his random username and password.

2 questions:

1 - What username and password should be used in the mysql_connect function when I store the user random username and password to the table?

2 - What username and password should be used in my mysql_connect function when the user comes back and login, or when he wants to change the random username and password?

I feel a bit dissoriented at the moment, can someone please tell me about this in a simple way?

BTW: I am a programmer so that part is no problem. 🙂

Thanks...

laserlight

You use the username/password to the database, no different from what you would normally use.

flyer

Do you mean 'root' as the username and 'nothing' as the password?

Or should I change the password to a real password? If that's the case, where can I change username and password?

So the usernames and passwords that my users register have nothing to do with the username and password I use in the mysql_connect function?

I know, it's a stupid question but I must ask it 🙂

Thanks...

laserlight

Or should I change the password to a real password?

You should, unless you want people to crack into your database server.

If that's the case, where can I change username and password?

You can use the command line, read up the mysql docs on that.
You might be able to send the query using a PHP script, but I dont think there's much point in doing that if you have the command line alternative.

So the usernames and passwords that my users register have nothing to do with the username and password I use in the mysql_connect function?

Definitely.
mysql_connect() is used to connect to the database.
Whatever you want to do with the data stored in the database is up to you.

flyer

Thanks a lot for your answer. I slowly begin to understand now. I will work on this for a while and se where it takes me 😃