Wednesday, September 30, 2015

Access database tutorials

Access database tutorials. PhpMyAdmin is a program that is usually installed at decent servers and helps us create and modify databases and even query, add, modify or delete data stored on them very easily. Not all servers have this free program, in fact some do not offer even a database, so what would it do not phpMyAdmin, of course. But each passing day more than they already offer. As for payment servers, almost all offer some databases to use and access to phpMyAdmin. In CCTW Hosting and Domains section you can see some other hosting services offer this. In any case, you can check with your current hosting if you have these things.

To access Phpmyadmin first have to enter your control panel hosting service. Hopefully the panel Cpanel is the guy who is going to explain that CCTW. However, if other than not vary much and you will like all these explanations. PhpMyAdmin is the same regardless of the hosting control panel.

To access Phpmyadmin then you have to go before the panel of your server. You can usually access your Cpanel control panel by typing the address of your website followed by / cpanel. If you type into your browser window asking the user name and password for your hosting displayed.

Access database tutorials

If you guessed your password you enter your Cpanel and see to the right a lot of icons. Find and click on the one you pointed out below:

Access database tutorials

By clicking here you another Cpanel screen from which you can create a database and user password to access the same display. The screen is this:

Access database tutorials

Enter the name for the database and click sen "Create Database". After a few seconds Cpanel communicates you that the database has been created with this message:

Access database tutorials

Already it created our first database for testing. If we have the same window above click on "Go Back" which means "return" and we find this:

Access database tutorials

Access database tutorials
I noted with a red circle the name of the newly created data base. You see, your full name consists of the username you have to access the control panel followed by an underscore and then the name you gave to the database a few seconds ago. Remember this when you ask somewhere give the name of the database as it is not only that you put it is preceded by the name of user control panel plus the underscore.

Another thing I just realized. Do not bother putting because it underscores the jump and put the words together. After some tests I have seen that if you leave a blank ignores what's behind this. So write the name of the database without scripts everything together and ready.

Just to the right of the red circle you have a choice (Delete) to delete the database with all its contents (now has no content), the option to check it (Check) and the option of reparala (Repair). Underneath it all you come to have the previous box if you want to create another database more.

Lower down still have more options. The following allows us to create users to access (not hosting control panel but) to the database we indicate later. There is currently only create users and then indicate which users can access which databases.

Let's now create a user. To do this you only have to write the user name and password in the box below:

Access database tutorials

To not make a mess, you better you go pointing a note your username and password of your control panel and secondly the username and password for this database. Otherwise you might forget. As always, the name users will not have strange symbols or accents or capital letters or spaces or hyphens, to avoid problems.

Once you press "Create User" meaning "Create User" A confirmation screen will appear like this:

Access database tutorials

Access database tutorials
Ale, user created. After clicking again on "Go Back", you already know what it means, you will see how the user appears ... but ... go! As with the database, the user is also puts the user name on the control panel followed by an underscore. I remember it? In this example the user therefore has created cartago_pepe name.

We turn to the third party. Now we have to say which user can access which database and what powers will have on it. Right now it does not make much sense, because we only have one database and a single user, but when you have multiple databases and users makes sense. This is done in the next window below:

Access database tutorials

Access database tutorials
This is easy too, where it says "user" you choose the user (you have only one, it will be easy to know which to choose, no?), Where it says "database" you choose the database to which you want to access that user and below all the things you do leave, the permissions that will have you appear. Normally this user is for you, so you can and should give all powers. And since everything is written in English "All", marks the box and ready, it's like you've marked all right.

Perhaps in the future you want to create another user to access a friend, or a visitor. In that case you can do the same thing again but limiting permits, scoring only do what you let in from the left, where are all those options. I tell you quickly what each means, but I do not use it, at least for now.

Select is only to select data, insert to insert data into the database, update to change the value of the data, to delete elimimar, create allows you to create tables, I think emptying drop, lock lock them and even the rest .... ... I do not know, (for what I'm going to cheat, right? After activating the All box click "Add User To Database" which means "Associating the user to the database" and ready, all set to continue.

Artikel Terkait