current location:Home > Technical Articles > Database > phpMyAdmin

  • How to set login password for phpmyadmin
    How to set login password for phpmyadmin
    How to set the login password for phpmyadmin: 1. First enable the password login function in config.inc.php in the root directory of phpMyAdmin. 2. Then configure the username and password of mysql in config.default.php.
    phpMyAdmin 4543 2019-12-09 15:27:58
  • How to establish foreign key constraints using phpmyadmin
    How to establish foreign key constraints using phpmyadmin
    The method to use phpmyadmin to establish foreign key constraints is: 1. First select the database to which you want to add foreign keys; 2. Then select the table where you need to create foreign key constraints; 3. Click [Operation] and modify the storage engine in the table options; 4. Select To add a table with foreign keys, click [Structure], [Related View], and add foreign keys; 5. Finally, click [Save].
    phpMyAdmin 3339 2019-12-09 14:29:12
  • How to set up iis to support phpmyadmin
    How to set up iis to support phpmyadmin
    The method to set iis to support phpmyadmin is: 1. First download phpmyadmin from the official website, and then use the FTP tool to upload it to the server or download it directly from the server; 2. Then place the file in the iis application physical directory; 3. Then open iis, Add the website; 4. Finally write the security group rules.
    phpMyAdmin 2313 2019-12-09 14:10:57
  • How to adjust the phpmyadmin import database file size limit
    How to adjust the phpmyadmin import database file size limit
    The method to adjust the size limit of the database file imported by phpmyadmin is: 1. First open the [php.ini] configuration file; 2. Modify the maximum upload file size to the size you want; 3. Modify the maximum information that can be received through the [POST] method. A large number is the required value; 4. Turn on the [file_uploads] option.
    phpMyAdmin 1930 2019-12-09 13:57:35
  • How to modify the upload limit of phpmyadmin
    How to modify the upload limit of phpmyadmin
    The first step: Modify the file upload size configuration in the php.ini configuration file; The second step: Modify the PHP execution time and memory limit to implement the large file upload function of phpmyadmin; The third step: Modify the phpmyadmin configuration file.
    phpMyAdmin 2272 2019-12-09 13:37:43
  • How to use phpmyadmin to modify the database default encoding
    How to use phpmyadmin to modify the database default encoding
    The method to use phpmyadmin to modify the default encoding of the database is: 1. First log in to phpmyadmin; 2. Then click [Variables] in the navigation bar; 3. Then use the [Ctrl+F] shortcut key to find the default encoding format of the database; 4. Finally Just change the default encoding format used by the database to the required encoding.
    phpMyAdmin 4521 2019-12-09 13:37:16
  • how to install phpmyadmin on linux
    how to install phpmyadmin on linux
    Install phpMyAdmin under the Linux operating system and decompress the downloaded software package "phpMyAdmin-2.11.5-all-languages.rar" to the root directory of the configuration environment. For ease of use, you can rename the decompressed folder for phpMyAdmin.
    phpMyAdmin 3020 2019-12-09 13:30:23
  • How to change database password using phpMyAdmin
    How to change database password using phpMyAdmin
    The method to change the database password using phpMyAdmin is: 1. First click the [User] option, select the last item, and click [Edit Permissions]; 2. Then click [Modify Password] on the modification permissions page; 3. Finally, set a new password. Click [Execute]. If there is an error in logging in, you need to modify the configuration file.
    phpMyAdmin 2206 2019-12-09 13:25:59
  • How to set permissions in phpmyadmin
    How to set permissions in phpmyadmin
    Open phpmyadmin with a browser and enter your username and password to log in. Select the database for which you want to set permissions on the left and click Permissions. Click "Edit Permissions" in the pop-up window. Enter the permission setting page and set permissions as needed. After the settings are completed, click "Execute" in the lower right corner to update permissions.
    phpMyAdmin 5324 2019-12-09 13:15:53
  • How to import excel into phpmyadmin
    How to import excel into phpmyadmin
    The first step is to get an excel table, which contains a lot of data that we need to import. Click "File"--"Save As" to save the excel table as a csv document. Enter phpMyAdmin to create a table, create a new field, and the field names are associated with the table fields you want to import and in the same order. Click "Import".
    phpMyAdmin 3974 2019-12-09 11:58:10
  • How to clear phpmyadmin database
    How to clear phpmyadmin database
    Use the phpmyadmin tool to delete mysql database tables in batches and log in to phpmyadmin. Select your mysql database name to enter - click Structure - select the data table you want to delete - select Delete in "Selected Items" to perform the table deletion operation.
    phpMyAdmin 1996 2019-12-09 11:40:24
  • How to upgrade phpmyadmin version in wamp
    How to upgrade phpmyadmin version in wamp
    The method to upgrade the phpmyadmin version in wamp is: first go to the official website to download the required new version, then decompress the compressed package to the [apps] directory, and rename the decompressed file, then modify the corresponding directory in the configuration file, and finally Just restart the service or computer.
    phpMyAdmin 2338 2019-12-09 11:26:56
  • Solution to 403 error reported when phpmyadmin cannot be opened
    Solution to 403 error reported when phpmyadmin cannot be opened
    403 error solution: Open the apache-Alias ​​directory-http://localhost/phpmyadmin/-Edit alias in sequence, and change "Allow from 127.0.0.1" to "Allow from all" to solve the problem.
    phpMyAdmin 2800 2019-12-09 11:18:12
  • How to import the database into phpmyadmin
    How to import the database into phpmyadmin
    How to import the database into phpmyadmin: 1. Open phpMyadmin, enter your account and password, and enter the home page. 2. Select or create a database. 3. Click Import on the menu bar, select the database to be imported, and click Execute.
    phpMyAdmin 2241 2019-12-09 11:08:55
  • How to use phpmyadmin to change administrator and user passwords
    How to use phpmyadmin to change administrator and user passwords
    The method to use phpmyadmin to change the administrator and user passwords is: first log in to the management background of phpmyadmin, then enter the database table list, find the user table, enter the database table editing page, click [Edit], then enter the new password, and select the function [ MD5] is enough.
    phpMyAdmin 2855 2019-12-09 10:59:40

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28