Phpmyadmin used phpmyadmin3.5.2.2 to create a table. it is newly installed and feels different from the old version. When I create a database for a table, I have no mistakes or questions. I used phpmyadmin to create a practice Database. if the database was not successfully created, creating was always displayed. later, I used the command line to create the database. Create a table under practice: tablename: usersadd4columnsNa phpmyadmin
I used phpmyadmin 3.5.2.2. the newly installed phpmyadmin is different from the old version.
When I create a database for a table, I have no mistakes or questions.
I used phpmyadmin to create a practice Database. if the database was not successfully created, creating was always displayed. later, I used the command line to create the database.
I create a table under practice:
Table name: users add 4 columns
Name Type length/value Default Collation Attributes Null Index A_ I Comments
Id INT 11 NONE utf8_general_ci not selected or primary checked or not
Username VARCHAR 10 NONE utf8_general_ci not selected or not
Password VARCHAR 40 NONE utf8_general_ci not selected or not
Email VARCHAR 30 NONE utf8_general_ci is not selected, unique is not selected, and unfilled
Storage Engine: INNODB Collation: utf8_general_ci
Is there any problem with table creation? I clicked save and did not respond. there was a red box in the ground, and an exclamation point in the box.
There are no errors.
I use the command line
Create table users
(
Id int (11) primary key,
Username varchar (10) not null,
Password varchar (40) not null,
Email varchar (40) not null,
Status varchar (10) not null.
------ Solution --------------------
Are there any error messages? If this is not the case, use the lower version. both 3.5.1 and 3.4 are good.
------ Solution --------------------
If you can log on to phpmyadmin, the database link is normal. do you have no permission to access the directory where your database is located?