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.
- 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.
- 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.
- 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.
- 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.
- After entering the homepage, select phpMyAdmin, enter the management interface
- 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.
- 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.
- 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.
- After you create the table, set the properties for the columns of the table
- 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.
- 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