phpMyAdmin is installed on almost all shared servers. We can install it on our computer. Since we are working with MySQL, we need to install MySQL using phpMyAdmin. A package of everything we need is available, the name is WAMP. There are many more such packages. Wamp is my favorite, so I'm writing about it. Details can be seen below
 |
| Database Management in PhpMyAdmin. How to Use without error? |
If we install wamp and run http:
There are many useful tools here. On the left side will be the database we created. Clicking on the Users tab displays a list of users. To access a database in any programming language, we need three information
- Hostname
- Database name
- Username
- User password
The host name Localhost is localhost. But in a real project, the server fails.
The name of the database we will name to create the database is just a few minutes later.
The username and password can be created on this User tab. If you have forgotten your password, you can reset it here. You can make another print. One database will provide one for one user. Just like the user can only read data in the database. You can only insert data. The user can do everything. These are called privileges, when you create a user, you can set privileges.
The database is usually exported to a backup and saved somewhere. Any database can be backed up on the Export tab.
The import is imported into the database server. How we made a project in Lokly. The project will now be uploaded to the server. To do 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 a database. You will then get a form to create a database:
Click "Create" with the name of the database. The database will then be created and can be seen on the right side.
Click on the database you created next to it. You can now create tables, columns, rows, etc from this phpMyAdmin. After creating the database, clicking on it on the left side will bring up the following forms. To create tables. It can be said that there will be columns and tables in a table and a table. Pressing GO will give us the option to name the columns. And I can fix what data I will store in the column.
For example, if we create a table called user and create three columns for it, then we will offer the following options:
We will place an ID for each table. And I'll choose A_I, auto increment. If one value is stored in each column, its value can be incremented by one.
Our user must place one of the remaining two columns and one more in the table.
This way we can create the database, tables and columns according to our needs. After using this information, we can store data using our own preferred programming languages from our project. And we can show such data requests to the user as needed.
To store data, the MySQL database can be used with almost all programming languages. MySQL can be graphically controlled using phpMyAdmin. For example, creating databases, creating tables, creating columns, creating user management. Everything in the database with data updates of any row. This must be done on the command line. So graphically it's easy to do, right?
.png)
.png)
