We also have the guide for LAMP Stack as well. With phpMyAdmin, managing and administering databases becomes much easier and more efficient, even for users with little or no experience with command-line interfaces. It is a popular tool among developers, database administrators, and webmasters who work with MySQL or MariaDB databases. PhpMyAdmin is written in PHP and can be installed on any web server that supports PHP and MySQL. It provides an easy-to-use graphical user interface that allows users to perform a wide range of database management tasks, such as creating and modifying tables, running queries, importing and exporting data, and managing users and permissions.
I am thankful for all the authors who have written all the above articles it was a great help.PhpMyAdmin is a free, open-source web application for managing and administering MySQL and MariaDB databases. You can follow the rest of the instructions just as they have been described in Step 3 of the following link. Please remember to replace ‘password’ with your own password. To fix this I used the following MySQL Command alter user identified with mysql_native_password by 'password' I also updated the authentication method for the root user because it was throwing an error. GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO remember to replace the password with your own password. sudo mysql -pĪlter user identified with mysql_native_password by 'password' This would prompt for the password which you can enter.įrom there on you can use the following commands. Was altered to the following sudo mysql -p < /usr/share/phpmyadmin/sql/create_tables.sql sudo mariadb < /usr/share/phpmyadmin/sql/create_tables.sql The following are the commands which were altered. I used the following guide but since it used MariaDB I altered the command to suite MySQL I used the following article to install Apache and PHP but since the used Maria DB I skipped that part It would have been wonderful to install everything from a single command. I tried to use Tasksel for some reason it just did not work. I found great help on the internet and I would be using articles. Writing this guide to help anyone who would like to install LAMP Debian 10 with MySQL (not maria DB).
0 kommentar(er)
