What mysql user is put into mysql_connect() for a registration page?

[settingsun]

I log into the mysql monitor as root, to practice using it. The registration page on my future website will need to connect to the mysql database to insert the information each customer gives it.

I started to write a php script that would use mysql_connect and a few other functions to give customers, who go to my future registration page, access to the database. I got a lot of errors.

I log into the monitor as root. That is not the user the registration page will be. What mysql user do I put into the mysql_connect() function - to give those who log onto the registration page of my site access to the mysql database, so they can insert their information?

Does this user go into /etc/my.cnf somewhere to let mysql know there is a user other than root?


Thank you

[Doug G]

In the mysql server, add the desired user to mysql using phpmyadmin or some other mysql tool. Then grant the desired permissions for that user on the database your application will be using. Refer to the GRANT statement documenbtation in mysql to see the sql used.

Then in your code identify the mysql user account to use in your connection. Yes, typically such information is in a configuration file for the php application.

[settingsun]

Thank you -

Yes, typically such information is in a configuration file for the php application.

Could you explain this in more detail?

[Doug G]

Could you explain this in more detail?

Here's a snip of the file config.php used by the php application "cms made simple". There are other settings in the config.php file, but this may give you an idea

#-----------------
#Database Settings
#-----------------

#This is your database connection information.  Name of the server,
#username, password and a database with proper permissions should
#all be setup before CMS Made Simple is installed.
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'mysqlusername';
$config['db_password'] = 'mysqlpassword';
$config['db_name'] = 'mydatabase';
#Change this param only if you know what you are doing
$config["db_port"] = '';


#If app needs to coexist with other tables in the same db,
#put a prefix here.  e.g. "cms_"
$config['db_prefix'] = 'cms_';

[settingsun]

Thank you - You pointed me in the right direction to figure this out.