To store data, MySQL database can be used with almost all programming languages. MySQL can be graphically controlled with phpMyAdmin. Such as creating databases, creating tables, creating columns, creating user management. Everything on the database with data updates of any row. These are to be done in the command line. So graphical is easy to do, is not it?
phpMyAdmin is installed on almost all shared servers. We can install it on our computer. As we work with MySQL, we need to install MySQL with phpMyAdmin. A package of everything we need is available, name WAMP. There are many more such packages. Wamp is my favorite, so writing about it. The following can be seen for details
If we install wamp and run http: // localhost / then we will see the information about the wamp, our project. You can go to phpMyAdmin by clicking Tools or Your Aliases on phpMyAdmin.
There are a lot of useful tools here. On the left side there will be database created by us. Clicking on the Users tab will show the list of users. To access the database on any programming language, we need three information
Hostname Localhost is localhost. But in the real project it refuses the server.
The name of the database that we will name to create database, it’s Just a few minutes later.
User name and password can be created from this User tab. If you forget the password you can reset it here. Another Imprint can be done. One database will provide one for one user. Just like a user can read data at database only. One can only insert data. A user can do everything. These are called Privilege, while creating the user, the Privileges can be set.
Database is usually exported to backup and saved somewhere. Any database can be backed up from the Export tab.
Import is imported to a database server. As we have done a project in Lokly. The project will now be uploaded to the server. For this, export the database from the local host and import it to the server.
These are the most important tools. The rest will be able to learn slowly.
Click on the Database tab to create the database. Then you will get the form to create database:
Click Create with the name of the database. Then the database will be created and it will be seen on the right side.
Click on the database you have created right next to it. Now you can create table, column, row etc. from this phpMyAdmin. After creating the database, clicking on it from the left side will bring the following forms. To create tables. Can be able to say that there will be columns and tables on table and table. Clicking on GO will give us the option to name the columns. And I can fix what kind of data I will keep in a column.
For example, if we create a table named user, and create three columns for it, then we will offer the following options:
We will place an ID for each table. And I will select A_I, Auto increment. If one data is saved in each column, its value can be increased by one.
Our user should put one of the remaining two columns in the table and another one.
In this way, we can make database, tables and columns like our own needs. After using this information, we can store data using our own preferred programming languages from our project. And we can show the user with such data queries as needed.