Web Tutorial

Learn Coding

Website Development Training

HTML, CSS, Javascript, PHP, MySql, XML, Ajax, Json, Python
M Yakub Chowdhury   Whatsapp: 8801749400485   myakub@myakub.com

MySql Tutorial

To work with database on the website you need to create a database.
In the website cPanel there are MySQL Databases

MySql Database

There you can create a Database. Please remember database name.
You will need it to connect database from website.

Create MySql Database

There you can Add User. Please remember username and password.
You will need it to connect database from website.

Create user in MySql Database

There you can Add User to Database.
You have to select here the username and database you created.

Add user to MySql Database

In the website cPanel there is PHPMyAdmin under Databases.
Click on phpMyAdmin.

PHPMyAdmin in MySql Database

Create on the database name you created.
Click on NEW to create new table.

PHPMyAdmin Create New Table

Write a Table Name.
First row Give a name like ID. Select INT. Give a maximum digit limit of ID.
Select Primary Index. Select AI Auto Increament.
2nd ROW Give a name. Select Varchar. Give a limit of character or number.
Select more row as you need in table.
Finally Save. Your table is created.

PHPMyAdmin Create New Table with Column

My HTML Certificate:
My CSS Certificate:
My Javascript Certificate:
My PHP Certificate:
My MySql Certificate:
© copyright myakub.com