Once you’ve filled out those bits of information, scroll down and click the Go button. In the resulting window ( Figure B), name some columns, select a type (VARCHAR is always safe), and give them all a value (20 or so). Create a simple table by clicking New under the users database. Without this “dummy” table, you won’t be able to import the necessary table to enable configuration storage. You will then be prompted to create a new table. In the resulting window ( Figure A), type users in the Database name field and click the Create button. Log into phpMyAdmin and click on the New button in the left navigation. So, let’s create a database called users. However, we don’t want to just import those tables into any old database. In order to enable configuration storage, we have to import a set of tables. I’ll be demonstrating on phpMyAdmin 4.7.9, running on Ubuntu Server 16.04, via an Antsle virtual machine. I will assume you already have phpMyAdmin up and running and can log in with an admin account. The process is a bit cumbersome, but not terribly difficult. With configuration storage enabled, you can easily configure settings such as:īut since the process has changed for enabling configuration storage, you’ll probably find no configuration options can be saved on a new phpMyAdmin setup. If you want to be able to make permanent changes to your phpMyAdmin installation via the web-based interface, you’ll want this enabled. Unless you have configuration storage setup, every configuration option you change to phpMyAdmin through the web interface will only be stored on a per-instance basis. What is configuration storage? The name says it all. One of the biggest change is that configuration storage is a bit more challenging to setup. If you’re about to install a new instance of phpMyAdmin, you might be surprised that many things have changed. Jack Wallen walks you through the process of enabling configuration storage for phpMyAdmin to gain added security features for the web-based MySQL tool. How to enable phpMyadmin configuration storage to gain more options and security
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |