The use of MySQL database in the "XAMPP" Windows XAMPP integrated Environment

Source: Internet
Author: User

  1. After you have installed XAMPP, the "XAMPP" folder appears under the directory you installed, which is the directory for the entire XAMPP integration environment.

    We enter this directory first, and then we see the Xampp-control.exe execution file with the XAMPP flag.

  2. Double hit Open Xampp-control.exe, the following interface will appear, click to open Apache and MySQL, so we open the service, then we can use the GUI or the DOS interface using the MySQL database, first introduced the DOS interface.
  3. Using the DOS interface under XAMPP and using commands to operate MySQL, we can enter the DOS interface with the "Shell" button in the red box and operate the database after the service is turned on.
  4. Enter the DOS interface, use the command to enter the database, XAMPP initialization of the root password is empty, so you can not enter the password directly, then you can use the database.
  5. Another way is to use the Xampp graphical interface, which needs to be opened through the browser, after the service is opened, we enter "http://127.0.0.1" in the browser will enter the first page of XAMPP.
  6. After entering the homepage, select phpMyAdmin, enter the management interface
  7. After entering this is the appearance, the left red box is the database you already have, select the database you want to use and edit can enter the database for management.
  8. below to see how to add a database, click on the "database" will show you now have the database, you can enter the database from here to manage the data, you can enter the name and type of database in the red box after clicking "Create", a new database is created successfully.
  9. After creating the good one database, we set up a table for the database, enter the appropriate information in the Red box and click "Execute", the form is created.
  10. After you create the table, set the properties for the columns of the table
  11. After setting the column properties, we can see our table in the database, even if the table is complete.

    Then we can add the rows to the table.

  12. Click "Insert" to add a row to the table, click Browse, you can see the contents of the table transferred from: http://jingyan.baidu.com/article/d169e186467a44436611d8b1.html

The use of MySQL database in the "XAMPP" Windows XAMPP integrated Environment

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.