Creating a database with phpMyAdmin (video tutorial)

This video tutorial about databases and phpMyAdmin is part of a series of video tutorials on the application server, http server, php, mysql, phpmyadmin and implementation of a website or a blog.

We Refer this video tutorial to achieve a simple database (in Romanian) or database (in English) with which we will install in the next video tutorial a web based (browser interface) that we could put on up a website or blog, we'll make their ideas and knowledge on the internet.

Series of video tutorials that will follow will introduce even more mysteries and dedesupturile Internet, websites and site hosting servers.

In these video tutorials we will learn to come read a little bit about html, php, css, rss and many other interesting topics and necessary when we want to create a website or a blog.

We look forward to watching and following tutorials, we will continue what we started now.

But better yet watch this video tutorial that explains in detail some of the things mentioned above.

by Cristian Cismaru

CAREFUL

For your visual comfort of this tutorial video can be watched full screen (Fullscreen)



Related Tutorials



Comments

  1. another interesting tutorial ffffff

  2. hello I installed wampu and I give legal aid by mistake when I walk in http://localhost/phpmyadmin/ I did a print screen but nush how you send it. Give me an email and try to send it to you

  3. Are banks and finance student please tell me what program I could use for a database application. in which we:
    a customer base of each client's shares, stock records sold, purchased

    Thank you in advance

    • adrian: Are banks and finance student please tell me what program I could use for a database application. in which we:
      a customer base of each client's shares, stock records sold in advance cumparateMultumesc  

      Yes mail [email protected] and I'll help you.

    • adrian: Are banks and finance student please tell me what program I could use for a database application. in which we:
      a customer base of each client's shares, stock records sold in advance cumparateMultumesc  

      To you or to build? I recommend to you to look after a server to support and database access. It would not be hard to build it (I mean the) the hard part is to build scripts that do everything you want (very much php). You're interested in a trade platform, and it is for sale on themeforest codecanyon or at a reasonable price (up-20 30 $ $). Hope I helped.

  4. @adrian: Please post under another name so that we can be more easily distinguished, as you can see on this site is a top of the comments, posting under the name of Adrian even with a small "a" your comments will be counted as mine ! I don't want that at all, please be understanding, look for a nickname, pseudonym, something… Thank you in advance!

  5. Andre @: I also got this error at first. Look at Manage> Service if MySQL is started. When I looked at STARTING, it must say SRARTED. Problem was with ZoneAlarm. I closed the Alarm zone and the problem was solved.

    ADRIAN @ Congratulations, you do a great job. If you can post more video pt. advanced programming: PHP, HTML.

    Success!

  6. Cristi, for example, I'm in a chain… and the idea is that it doesn't work for me ica I mean I have a normal ip but I also have a 192.168.2.198… and the central ip… and I don't know how to make it enter me not on my router: ((

  7. Loud tutorial
    but not subdomain domain: D ms ms

  8. Adrian said

    @Cipri: Type Search: "domain" or "domains" (without quotes!) Or "How to buy a domain and hosting space for a website" or "How to make a free domain from dyndns when you have a dynamic ip" or "How to make a free domain or how to change the ip with a free subdomain from Dyndns"

  9. What is the "past tutorial" give a link to the tutorial. THX

  10. Regarding databases do not know much, but from what I understand any means text, or articles published here are stored, so the data will increase over time.
    I created a database and installed wordpress.
    A table in the database called "wp_posts" and apparently there are stores all the articles you write. As I write more, so this table will be large (tens of KB, hundreds of KB ... as appropriate). But oddly enough, if I decide to delete some articles that I've written, the size of this table "wp_posts" not decrease, remain the same. I reached somewhere around 3 MB, we had a deleting all items in wordpress. Database size has not decreased. (The table "wp_posts" and column "size" tells me the same value, ie 3 MB)'s something neinregula? So should it be?
    But the checkbox next to it "wp_posts" and give "repair table" I no longer indicate the size, value 3 MB, but I show the normal, ie approx 8 KB. Why not shrink the database automatically when removing certain articles of wordpress? (Deletion of articles was made directly from WordPress, not phpMyAdmin).

  11. vali: Regarding the database do not know much, but from what I understand any means text, or articles published here are stored, so the database will increase in time.
    I created a database and installed wordpress.
    A table in the database called "wp_posts" and apparently there are stores all the articles you write. As I write more, so this table will be large (tens of KB, hundreds of KB ... as appropriate). But oddly enough, if I decide to delete some articles that I've written, the size of this table "wp_posts" not decrease, remain the same. I reached somewhere around 3 MB, we had a deleting all items in wordpress. Database size has not decreased. (The table "wp_posts" and column "size" tells me the same value, ie 3 MB)'s something neinregula? So should it be?
    But the checkbox next to it "wp_posts" and give "repair table" I no longer indicate the size, value 3 MB, but I show the normal, ie approx 8 KB. Why not shrink the database automatically when removing certain articles of wordpress? (Deletion of articles was made directly from WordPress, not phpMyAdmin).

    No need to worry about the size of the database, it does not become overweight, for example we have in this site over 250 articles, 20.000 comments yet database're only 13 MB we have a database in our application traffic monitoring (as trafic.ro) here reached almost 200 MB database, we have database of advertising serveruyl 50MB which reached fairly quickly, other applications can gain the database, but WordPress, Joomla, Drupal, XOOPS, phpBB etc. will not load so much database.
    At the level of a database or even deleting a post-4 6 posts is nothing, not feeling the text takes up very little space, if you want to see can create a blank text document and then write something in it, look Look at the size of empty and then the size of the text written by you, the difference will be insignificant.
    From time to time it is good to optimize the database tables, this is like a defrag, if you know how to do, I'll explain it in the tutorial, do not play another one until the database is not up Make a backup if you want to delete a post, delete it from your dashboard wodrpress is not recommended to remove them from the database.
    A talk on these tutorials about databases, their optimization, backup these and other issues.

  12. Thank you

  13. What I understand from my tutorials on how to do this server is: why not have installed wamp server, xampp etc. in Particia C?? It is mandatory that the server is installed in another partition??

    Otherwise all the best!
    gpa

  14. It worked perfectly for me ... when I did that, but after I reset everything, instead of what should appear in my directory, it tells me: "It works"
    What do I do?

  15. I continually receive the following error:
    Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user '.root'.

    Because of this error fail to use most applications (starting with privileges)

    If I can help I would be very grateful

    Thank you in advance !

  16. I have a problem.
    I hosted a free webhosting but I can't make a database of that with "login register logout" I mean I don't know anything can you help me please?

    Thank you!!

  17. I have a question when I give localhost fails, YOU CAN crysti please help me

  18. Hi, the site is very useful from my point of view, making a comparison with other tutorials (from other sites) that have everything prepared and installed and starts directly to do without explaining step by step, it pleases us most and explain everything. However, I have a question, I started a site, I bought a domain where I also received an email, a site hosting site, an ftm account and the whole package… I bought the domain from romarg, and it is .ro. I put the site on file, but when I put drupal (versions 6 or 7) and start installing it, I have a problem with the MySQL database, it writes to me that the user is not authenticated or in English "Access denied for user" I was very carefully when I wrote usernamuul password database and host however I tried many times I made several databases exactly as in the tutorial..but without success, if you could help me I would remain very grateful..if you need email: [email protected] Thank you! Continued success!

  19. Virginia thimble said

    Hello
    I have a problem: I've got domain and hosting from lx.ro. They sent me the confirmation email: field and the fact that I created a database (including data connection to the database). I now what to do?

  20. hi..I have something to add, for all domains bought from romarg or rotale .ro domains or others, the database can be created much easier than using the wamp server in the computer. on the brouser write up “http: // domainname. (ro, eu, org, com or others) / cpanel enter the data (user and password) received from where you bought the domain and search for the MySQL database in the panel. only works when you have purchased a package included with the database esc thank you

  21. panther2006 said

    Hello I have a problem I want to create a database for a chat (subdomain is hosted hi2.ro), my big problem is I do not know how to add a table in the database? or how to link the site and database? porma they put a php script on the site? I know there are questions about wrongheaded yes I searched on google and frankly I do not understand please help me nimic.Va

    • panther2006Hi I have a problem I want to create a database for a chat (subdomain is hosted hi2.ro) My big problem is I do not know how to add a table in the database? or how to link the site and database? porma they put a php script on the site? I know there are questions about wrongheaded yes I searched on google and frankly I do not understand please help me nimic.Va  

      The structure is like this:

      Database> Table> Field
      To add a table enter the base and down pages that are generated in a right of option to add. As you click to edit the Left and then generates all the right fields. To edit a selected and click on the pencil that. To add a camp of an option below.

      To make the connection between PHP and the database is set to work connecting sql script:

      mysql_connect (“localhost”, “root”, “pass”) or die (mysql_error));
      mysql_select_db (“php”) or die (mysql_error ());

      In the first line that says localhost defines host
      In the first line that says root defines user
      In the first line that says pass defines password
      To do this you make a file called connect.php and include it whenever you need with include "include / connect.php" or require_once.

      To enter a script you need to clear the script, have an area where you enter all the data and make the connector to fit on your database.

  22. I forgot to say in the second line where it says php write the name of the database.

  23. I did however just give you give the phpMyAdmin it gives me error dc. Could you put a download link to pull the same program WampServer, which also used lai tutorialu above

  24. paul filip said

    you show many visitors what they could learn by paying for these lessons I know you don't have the time and maybe space to show them some complete applications but for beginners it's FF good and enough to get started So I would like to ask you if I can download "tag -s ”from the HTML presentation if I don't copy them with a pen on a piece of paper

    • Adrian admin said

      paul filip: I'll show you more visitors ECAC they could learn these lessons paying time and I know you can not space to show complete some applications but for beginners it's FF well enough for Aces to initiate any to ask if I could download " tags "from HTML presentation unless their children on a sheet pixu  

      If you read more carefully at the text at the tutorial sfrsitul have some download links. No need to copy the pen, you have heard of print screen? Write up in the search box on the right: how to do a print screen, hit enter and you will find a tutorial on this topic

  25. mostwanted said

    When accessing phpMyAdmin, I appear the following error: http://img541.imageshack.us/img541/3239/phpnu.png

    please, can you help me?

  26. Thank you very much!
    Gj critical!

    PS: Mandatory: Close the firewall or put in exceptions or mysql wamp will not work! Will start and will disable 3 seconds!

  27. Hello, I use WAMP for more than a year and yesterday something happened to me that I had it once and I got it a few months ago but now I do not really remember how .. Skype is set 80 and not to use port forwarding is done correctly but for 80 8080 port if necessary. I checked and nothing else uses server ports .. Really do not know how I solved but I know it was something simple.
    The problem is that the "Put online" option of any color no longer works. Everything went smoothly until yesterday but I don't know what gave up. I'm wondering if a flood could have turned upside down who knows what permissions on a file or I really don't know, but I would be happy if someone could give me an answer because I can't find anything on google related to this problem, or I haven't searched enough yet .. I need help .. Thank you very much

  28. I forgot to mention that everything goes very well and beautifully from localhost. It just doesn't work from the internet. I even set the firewall very carefully… I really don't know what jumped up .. 🙁

  29. Welcome. A very useful tutorial. I'd like to do and some tutorials about programming: PHP, Java

  30. What is the next tutorial?

  31. I also have a problem, I installed the wamp server well exactly as cristi said, I see in the localhost wampserver but when I try to open phpadmin it tells me that I don't have access to it (“You don't have permission to access / phpmyadmin / on this server ”), I went into the firewall and gave access to the wamp and it still doesn't work, who can help me? THX

  32. iliebr said

    How to change from yahoo mail beta yahoo maill classic?. I found a tutorial on youtube but I did not understand much. Could you help me with a tutorial made right here in videotutorial.ro?

  33. AdrianGudus said

    iliebr:
    How to change from yahoo mail beta yahoo maill classic?. I found a tutorial on youtube but I did not understand much. Could you help me with a tutorial made right here in videotutorial.ro?

    Before you played that video, did you watch the date on which that video was posted on YouTube? Yahoo no longer has Y! Mail in Beta… it used to be…. last year 2 years ago

  34. Lorenzo said

    I made a html site. I put in www directory.
    I can connect to the database somehow website?
    For example, when entering someone give register and make their own database?

  35. Lorenzo:
    I made a html site. I put in www directory.
    I can connect to the database somehow website?
    For example, when entering someone give register and make their own database?

    You like to have included hosting package database option. If you have, you just have to define in php file (or make a special connection file that then to include all the files you will need it) username, password and database name (mysql_connect ( servername, username, password)).
    After you have created the database in admin panel (with the same last name in the function above) should work.
    If you host the database I suggest you look for one that offers Cpanel find many tutorials and is easy to work with him.

  36. PHP about a full-time or part-time!
    - Advanced notions of OOP, knowledge and understanding of design patterns, data structures and algorithms
    - Strong knowledge of the PHP programming language is required
    - Knowledge and experience in working with MySQL / AJAX / JavaScript / HTML / CSS / JQuery
    - Knowledge of ZendFramework or CakePHP is a plus
    Can someone help me ?

  37. If you can tell me how to view in a browser the database I created. I mention that I am very new to phpmyadmin, mysql…. Thank you.

  38. I installed wamp, but I can not get into the database, when I click on phpMyAdmin I Forbbiden appears 403 (access denied), which is the cause? What can you do? Thank you.

  39. arhimania said

    Very good tutorial!

  40. Hello .. I want to ask myself some issues can dak
    I bought a domain and webhosting .. and put in domain website and I write
    ex: “http://adrian.com” .. says that it does not connect with detabase from pc 😐
    It can help me with this problem? I do not really know to know something
    Thank you

  41. me who helped me a database in oracle?: ((((((((((((((((

  42. We ask for your help, as is done in Java with a web database in oracle.

  43. I do not create new data base appears to me as I do? I created a subdomain on hi2.ro not know how to install phpbb can not create databases on ajutaima and min plz

  44. Luchian said

    If you buy a domain from ROTLD have a web hosting package for a database?

  45. who can help me with a database something like I add a list of phone numbers memorize my numbers then show me from the list the numbers that are not in the database, then add another list and so on to memorize numbers and to show me those that are not in the database can help me someone I do not know in creating a database….

  46. I begin by thanking you for this tutorial, in fact among the few of its kind. I try
    Specifically we tables
    item (itemId, itemPrice, itemTitle…)
    orderitem (itemId, orderId) -> join table
    orders (orderId, CUSTOMERID, ORDERDATE)
    customer (customerId, customerName, CustomerAddress….)
    * Note CUSTOMERID's foreign key table in orders, Itemid, orderId foreign key in orderitem.

    problem: how to make the total order given that an order contains more orderitem. Itemid rows.

    List the names of clients whose order is more than 20 lei.

    I have never written on comenturi simply because I thought I would have an answer. I'm curious how quickly and if someone responds.

Trackbacks

  1. […] Creating a database with phpmyadmin (video tutorial) […]

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.