Using the Setup script ¶
Instead of manually editing config.inc.php
, you can use phpMyAdmin's setup feature. The file can be generated using the setup and you can download it for upload to the server.
Next, open your browser and visit the location where you installed phpMyAdmin, with the /setup
suffix. The changes are not saved to the server, you need to use the Download button to save them to your computer and then upload to the server.
Now the file is ready to be used. You can choose to review or edit the file with your favorite editor, if you prefer to set some advanced options that the setup script does not provide.
- If you are using the
auth_type
"config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP-AUTH in a .htaccess file or switch to usingauth_type
cookie or http. See the ISPs, multi-user installations for additional information, especially 4.4 phpMyAdmin always gives "Access denied" when using HTTP authentication.. - Open the main phpMyAdmin directory in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode.
Setup script on Debian, Ubuntu and derivatives¶
Debian and Ubuntu have changed the way in which the setup script is enabled and disabled, in a way that single command has to be executed for either of these.
To allow editing configuration invoke:
/usr/sbin/pma-configure
To block editing configuration invoke:
/usr/sbin/pma-secure
Setup script on openSUSE¶
Some openSUSE releases do not include setup script in the package. In case you want to generate configuration on these you can either download original package from <https://www.phpmyadmin.net/> or use setup script on our demo server: <https://demo.phpmyadmin.net/master/setup/>.