![]() When done, type the following to get done with the settings. Where ‘pmadmin’ will be the username you used to create. GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Replace ‘ super-siyar-wtd-i-hate-it-anime-jk-pw‘ with the desired password where ‘pmadmin’ is the username. CREATE USER IDENTIFIED BY 'super-siyar-wtd-i-hate-it-anime-jk-pw' Now the command line for MySQL will be accessible. To do so, we’ll need to access the MySQL terminal. Instead, we’ll use a separate MySQL user and grant them the administrative access. Step 3 – Creating A Separate MySQL Admin Userīy default in a Debian system, the MySQL authentication username is set to root by default. Now when the progress bar reaches 100%, it means we’ve successfully installed phpMyAdmin on our server. Press enter and then go for the password. Enter the root password for MySQL you’ve set while installing the LAMP stack. Now it will ask if you want to configure phpMyAdmin, of course yes! Then enter a secure password for the phpMyAdmin database and confirm it. You don’t need to brainstorm, just press enter for apache2. The one would be a selection between apache2 and lighttpd. While installing phpMyAdmin, you will see a few prompts. To do so, paste the below-mentioned command to begin installing. We now have updated and upgraded the packages. Step 2 – Installing phpMyAdmin On Debian 9 It’s time to update and upgrade the packages. To do so, use the below-mentioned command. Step 1 – Updating & Upgrading existing packagesĪs we always do, we’ll need to make sure that all packages and source files are updated and upgraded so that we don’t have any difficulties while installing. Requirementsīefore beginning to install, we’ll need to make sure that we meet all the requirements. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.”, says Wikipedia about PMA. “phpMyAdmin is a free and open-source administration tool for MySQL and MariaDB. ![]()
0 Comments
Leave a Reply. |