About Wamp's HTML, PHP, MySQL operation and contact-MySQL simple configuration (iii)

In the previous chapter, the method of transmitting values between HTML and PHP is described in this chapter, which will be used by MySQL in Wamp for the next chapter of PHP call data preparation. Again, the author's wamp version is 3.0.6 64bit

To open Wamp's own MySQL attempt database steps:

Right-click Software Small Icon---Loaclhost Tools---phpMyAdmin, then appear this interface, need account and password to enter.

　　

The default is empty, here I suggest you change the account and password.

Step: Right-click Software Small icon, MySQL---MySQL Console

　　

Steps:

1, enter the console, prompt for password (do not enter any password, because the password is empty), press ENTER enter;

2. Input use MySQL, using database

3. Use the update user set Password=password (' Password you want to change ') where user= ' root '; Note: Do not omit semicolons and quotation marks

If the following error occurs, do not worry, the new version changes, no longer use the password field, instead of anthentication_string

　　

　　You can use the update user set Authentication_string=password (' 123456 ') where user= ' root '; (if error, please knock yourself)

　　

4, flush privileges; (Note that the semicolon ends, this command saves the modified user name and password);

5, quit; (Exit command Window)

　　

6, browser into localhost, appear interface, click phpMyAdmin Enter. (You can also enter localhost/phpmyadmin directly in the browser URL).

　　　　

　　　　

　　

Next is the creation of the database MySQL:

1, new database through the Operation view interface;

2, new database through PHP code;

3, by running the command to create;

　　

　　1. Create through the Operation View interface

　　1.1, modify the permissions of the account

　　　　

1.2. Click Edit Permissions

　　　　

1.3, tick Select All, click on the bottom of the ' execute ', to save.

1.4. Create a new database:

　　　　

1.5, click Create, the database MyTest will appear on the left, the next need to create a table in the database;

　　　　

In the MyTest database, create a userinfo data table, 3 properties, the number of properties can be changed by itself, and finally click on the right side of ' execute '.

1.6, fill in the properties of the key and the corresponding type and byte length, if the number of sensory attributes is not enough, you can add , such as:

　　　　

After clicking Save:

　　　　

1.7, at this time the value of the property is all empty , all we need to assign a value to the property, click the navigation bar to insert

　　　　

1.8, click on the execution, the page will jump to SQL, can not control, click on the navigation bar Browse

　　　　

To this, the database has already completed the data table, if the data is not enough, do 1.7 of the insert Operation , re-assignment, the data can be modified, can be deleted.

If you feel that the number of attributes is not enough, you can add attributes in the structure of the navigation bar

　　　　

Click on execute to jump as follows:

　　　　

　　　　Click Save , and then click Browse in the navigation bar

　　　　

　　　　Click Edit, repeat 1.7 Insert to assign value

　　　　

　　　The above is the database of the new and database data population.

　　　　The next chapter begins with PHP if you operate the database MySQL

　　　　

About Wamp's HTML, PHP, MySQL operation and contact-MySQL simple configuration (iii)