Tuesday, January 11, 2011

Costco European Cookies Sampler

Sites dynamic local user database and website users


Sometimes I feel a bit 'of confusion in the understanding of the roles of identifying you if you need to manage multiple web sites on the same server, especially in local to do all the appropriate tests.

For this reason I wrote this brief note of clarification, hoping it will be helpful.
as examples of locally based installation of Joomla, but the discussion can obviously be extended to other dynamic sites.
The username and password from the main user of the Joomla database, and the administrator name and password necessary to enter the site with administrator privileges ARE NOT THE SAME WHAT.

Nothing prevents us from inserting the same parameters (same name and same password in both cases, although in terms of security is nonsense) but the important thing is to understand the distinction between these .
To clarify, we summarize the functions:
In mysql server, which can contain a variety of databases, there are:
the primary user (usually, but not necessarily, called root) with its password, which can access the server mysql via terminal or via http://localhost/phpmyadmin; this user manages all the databases on the server, not just to Joomla, and in fact is present in all the database of those listed, to find out, once entered into with phpmyadmin these privileges, select a database at a time and we see the presence of this user under 'privileges';

users with their password (usually but not exclusively, one for each database), which can access a specific database to administer it (these people must be set in any particular database) to each site in this (the same server can host many web sites), the specific user is used directly from the site during the administration of the specific database of the specific site, so much so that you have set it at the time of initial configuration (in other words it must be said that the site is the database and how to manage the administrative user data).
As for the site, however, there is an administrator user with its password, which is the only one who can administer the site coming from the back end (folders AUTHORITIES; in local http://localhost/nomesito/administrator), and users with their passwords, which may enter the restricted areas through their front end (before the login site viewable by the browser) without administrative privileges
  • To clarify, here is an example (
  • Note: all names and passwords listed below are random, are used only as an example and, above all, do not meet the minimum safety requirements, then DO NOT USE IT) .

In the local web server they were loaded again to install a site called Joomla (CMS) and a site called ZenCart (eCommerce) (for 'site called' is the name of the folder that we uploaded to the web root folder, which by default is located in / var / www / but we've seen can be placed where it seems).
local MySQL database server will then be created before anything else, two databases (more than the default ones): joomladb and
zencartdb . The called root, with password
first, is one that can manage the server database, and therefore can create and edit all

databases, eg. http://localhost/phpmyadmin through.
The root user enters the server and creates the database, once created, enter in each of these, select the privileges and creates the corresponding administrator user on the specific database.
For Joomla site, created in the database
joomladb the called joomlauserdb with joomlapwdb password, this is the only one who can handle joomladb database.
For ZenCart site, created in the database zencartdb the called zencartuserdb with zencartpwdb
password, this is the only one who can handle zencartdb database.
Let sites.
During installation, each site will request the name of the site with her password to see who can enter the back end of the site with administrator privileges to modify it. If you choose Joomla joomlaadmim password joomlapwadmin ; in Zencart you choose
zencartadmin
password zencartpwadmin . Also during installation, each site will ask you which is the database and which is the user can administer it, the prompt, enter the adjusted data in the creation of the database.

At this point we
:
the Joomla (http://localhost/joomla), which will be managed by the user joomlaadmim password joomlapwadmin (through http://localhost/Joomla/administrator/), and that will save the data in the database by the user joomladb
joomlauserdb password joomlapwdb ; ZenCart site, (http://localhost/ZenCart), which will be managed by the user
zencartadmin password
zencartpwadmin
(through http://localhost/ZenCart/admin) and that will save the data in the database zencartdb by the user
  • zencartuserdb
    password zencartpwdb ; Hope this clear:-D Good site all

0 comments:

Post a Comment