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 it was not successfully created, creating was always displayed. later, phpmyadmin created the table.
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?
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