MySQL Database
MySQL Database
A MySQL database exists in itself. Instead MySQL database is a way of organizing a group of tables. If you are going to make a bunch of different tables that share a common theme, you'll group them into a database to make the management process easier and easier.
First Steps Creating Database
Most web hosts do not allow you to create databases directly via a PHP script. Instead they require that you use a PHP / MySQL administration on a web host's control panel to make this database. Creating a database and assign new users to this database. For every example, we will use the following
information:
.:. Server - localhost
.:. Database - try
.:. Table - coba1
.:. Username - admin
.:. Password - adminadmin
Note: Tables can be changed in the advanced lessons, but everything else will remain the same!
server is the name of the location we want to connect to. Because all of our scripts will be placed on the server where MySQL is the correct address is localhost. If the MySQL server on a different machine from where the script is running, then you need to enter the correct address of the mysql database.
Your database, table, username, and password does not have to match us. If you choose a different
set the login information, remember to enter your own information when copying the script in this
tutorial.
Status Check
So far, you should have a new database and user assigned to it. You do not have to have
create table yet. If you are up-to-date, and then continue the tutorial. We will make our first table
in a future lesson.
also read about PHP/MySQL Database
A MySQL database exists in itself. Instead MySQL database is a way of organizing a group of tables. If you are going to make a bunch of different tables that share a common theme, you'll group them into a database to make the management process easier and easier.
First Steps Creating Database
Most web hosts do not allow you to create databases directly via a PHP script. Instead they require that you use a PHP / MySQL administration on a web host's control panel to make this database. Creating a database and assign new users to this database. For every example, we will use the following
information:
.:. Server - localhost
.:. Database - try
.:. Table - coba1
.:. Username - admin
.:. Password - adminadmin
Note: Tables can be changed in the advanced lessons, but everything else will remain the same!
server is the name of the location we want to connect to. Because all of our scripts will be placed on the server where MySQL is the correct address is localhost. If the MySQL server on a different machine from where the script is running, then you need to enter the correct address of the mysql database.
Your database, table, username, and password does not have to match us. If you choose a different
set the login information, remember to enter your own information when copying the script in this
tutorial.
Status Check
So far, you should have a new database and user assigned to it. You do not have to have
create table yet. If you are up-to-date, and then continue the tutorial. We will make our first table
in a future lesson.
also read about PHP/MySQL Database
0 Response to "MySQL Database"
Posting Komentar