Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv ,Ĭreate_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv ,įile_priv, Grant_priv, References_priv, Index_priv, Alter_priv , * TO 'pma' IDENTIFIED BY 'pmapass' GRANT SELECT ( Run the queries below, with the username and password you defined. Next, we need to create the user with the password we configured. If you changed any table name in the config above, make sure you change the name of the table here too. Run this SQL file against your newly created database. In the case of a Linux machine, you can probably find it in /usr/share/phpMyAdmin/examples/ or /usr/share/doc/phpmyadmin/scripts/. Next, you can search for a file named create_tables.sql on your machine, probably in PhpMyAdmin’s root folder or the scripts subfolder. Create a database with the name you defined in the config file. When done, it’s time to create the database. In this case, I used the 4.2.x version of PhpMyAdmin. Depending on your PhpMyAdmin version, not all config values will be available by default. However, if you want to activate any, I would suggest to keep the same name as I provided above. By leaving these blank, you will deactivate these extensions. All the other config values are table names. $cfg = 'pma' $cfg = 'pmapass' $cfg = 'phpmyadmin' $cfg = 'pma_bookmark' $cfg = 'pma_relation' $cfg = 'pma_table_info' $cfg = 'pma_pdf_pages' $cfg = 'pma_table_coords' $cfg = 'pma_column_info' $cfg = 'pma_history' $cfg = 'pma_recent' $cfg = 'pma_table_uiprefs' $cfg = 'pma_users' $cfg = 'pma_usergroups' $cfg = 'pma_navigationhiding' $cfg = 'pma_tracking' $cfg = 'pma_userconfig' $cfg = 'pma_designer_coords' $cfg = ‘pma_favorite’ $cfg = 'pma_savedsearches' Ĭhange the username, password and database name to your own liking. You can activate them by changing the file and adding the following lines. Ĭlicking on here will lead you to a page indicating that you didn’t activate all extensions yet. After logging in, you will probably notice this message at the bottom of the main panel: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Before you can continue, please make sure PhpMyAdmin is up and running.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |