How To Create Mysql Database Using Xampp
Database setup using XAMPP
This is a short introduction to help you setup and test access to your database using a local web server (XAMPP). For more information on SQL commands, please refer to database textbook(s).
(Please let me know if you find any errors or omissions in the document —Upsorn Praphamontripong, 8-August-2021)
XAMPP is an open source package that is widely used for PHP development. XAMPP contains MariaDB, PHP, and Perl; it provides a graphical interface for SQL (phpMyAdmin), making it easy to maintain data in a relational database.
If you have not installed XAMPP, please refer to XAMPP-setup to install and set up XAMPP.
Assuming that you have already set up XAMPP
- Start the database server ("MySQL Database")
- Start the PHP environment ("Apache Web Server")
Note:phpMyAdmin runs on a PHP environment. To usephpMyAdmin to manage databases, Apache Web server must be started.
Reminder: be sure to stop the server when you are done. Leaving the servers running consumes energy and may later prevent the servers from starting (in particular, MySQL server).
Access phpMyAdmin
- Open a web browser, enter a URLhttp://localhost to access XAMPP dashboard
- SelectphpMyAdmin tab
Alternatively, you may accessphpMyAdmin via the XAMPP manager / controller, clickGo to Application button to access XAMPP dashboard.
The main page should look similar to the following
Add a user account
- On thephpMyAdmin screen, selectUser accounts tab.
- SelectAdd user account link.
- Enter user name and password of your choice. Note: do not use any of your official accounts such as UVA account.
- SelectLocal forHost name
- CheckCreate database with same name and grant all privileges
- CheckGrant all privileges on wildcard name (username\_%)
- CheckCheck all forGlobal privileges
- At the bottom-right of the screen. click theGo button
Do not change or update theroot account. If you may forget or need to reset your password, you can use theroot account to manage users.
To verify that the account has been created, go toUser accounts tab. You should see the newly created user account (as shown below).
Create a database
Let's create aguestbook database. To create a database, there are several options.
You may use the
Create databasefeature.
- On thephpMyAdmin screen, select theDatabases tab. Alternatively, you may click theNew link on the left panel.
- Under theCreate database, enter a Database name
- Click theCreate button
You may run the SQL command to create a database.
- On thephpMyAdmin screen, select theSQL tab
- Enter
CREATE DATABASE guestbook;
Note: SQL commands are not case sensitive. This example uses uppercase and lowercase simply to make it easy to read. - Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
Create a table
Let's create a table namedentries. To create a table, there are several options.
You may use the
Create tablefeature.
- On thephpMyAdmin screen, select theguestbook database.
- Select theStructure tab.
- Under theCreate table, enter a table name and the number of columns.
- Click theGo button. This will prompt you to enter the column information.
You may run the SQL command to create a table.
- On thephpMyAdmin screen, select theSQL tab
- Enter the following code
USE guestbook; CREATE TABLE entries (guestName VARCHAR(255), content VARCHAR(255), entryID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(entryID));
If you already selected theguestbook database (on the left panel), no need to include
USE guestbook
in your SQL to run. - Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
Insert data
To insert data into a table, there are several options.
You may use the
Insertfeature.
- On thephpMyAdmin screen, select theguestbook database, select theentries table.
- Select theInsert tab.
- For each record of data to be inserted, enter the value for each column.
- Click theGo button.
You may run the SQL command to insert data.
- On thephpMyAdmin screen, select theguestbook database, select theentries table.
- Select theSQL tab
- Enter the following code
INSERT INTO entries (guestName, content) values ("Humpty", "Humpty's here!"); INSERT INTO entries (guestName, content) values ("Dumpty", "Dumpty's here too!");
- Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
Retrieve data
To retrieve data from a table, there are several options.
You may use the
Browsefeature.
- On thephpMyAdmin screen, select theguestbook database, select theentries table.
- Select theBrowse tab. This will display all existing records of the table.
You may run the SQL command to retrieve data.
- On thephpMyAdmin screen, select theguestbook database, select theentries table.
- Select theSQL tab
- Enter the following code
SELECT * FROM entries;
- Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
Import SQL file
- Create a blank file namedfriendbook.sql. Paste the following content in the file
CREATE TABLE friends (friendName VARCHAR(255), phone VARCHAR(255), entryID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(entryID)); INSERT INTO friends (friendName, phone) values ("Humpty", "111-111-1111"); INSERT INTO friends (friendName, phone) values ("Dumpty", "222-222-2222");
- On thephpMyAdmin screen, select theguestbook database
- Select theImport tab
- Choose the .sql file to import
- Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
Export SQL file (back up your database)
- On thephpMyAdmin screen, select theguestbook database
- Select theExport tab
- Click theGo button to run the command.
- For Mac users, you may pressControl+Enter to run
- For Windows users, you may pressControl+Enter to run
How To Create Mysql Database Using Xampp
Source: http://www.cs.virginia.edu/~up3f/cs4750/supplement/DB-setup-xampp.html
Posted by: sullivanwouniend1968.blogspot.com
0 Response to "How To Create Mysql Database Using Xampp"
Post a Comment