Now we write mysql -u root -py we put the password of phpMyAdmin (the one from step 10).We return to the terminal, write sudo -i (or sudo su) and put our password.We will see that it enters, but we do not have privileges. We do another check: we put the default user, which is phpmyadmin, and the password that we have configured in step 10.We go back to the browser and add “phpmyadmin” to “localhost”, which would be localhost/phpmyadmin.We accept the first window, which does not offer more options, and we go to the second, we say yes and we put a password to phpMyAdmin (twice): It will notify us that it is necessary to have an active database, and if we want to manage it with dbconfig-common.We choose apache2 with the space bar, then tab and OK. There will come a time when it will ask us for the server to use.To improve the user experience, we continue. In the next step, if we do not have it, we install the P of LAMP (PHP):Īnd with this we would have everything necessary to use MySQL in Ubuntu.As another optional step, which are not important but indicate that we are doing well, we return to the browser, put "localhost" and verify that now something like the following appears:.We go to the terminal and install the A of LAMP: Apache.We will see an error because there is no server doing its job. As an optional step, we go to the browser and put "localhost", making sure to remove the S from HTTPS if it does.To make sure everything is up to date, we update all packages, either from Software Update or with the command sudo apt update & sudo apt upgrade.With the above explained, let's go with the steps to follow to install LAMP together with phpMyAdmin and make everything work in Ubuntu. So, if you run into any bugs, I would recommend going back to what you did to find this article (if you didn't find it on social media): search for the specific bug on Google Duckucko How to install MySQL on Ubuntu Seeing as there are no packages or anything special, it should work in past and future versions, but it's not guaranteed. It also seems important to me to mention that what is described here works at the time of writing this article, and has been tested on Ubuntu 22.10. Depending on how it is configured, we can enter phpMyAdmin or we will find one of the many errors that it can show us. To improve the user experience, you must also install and configure phpMyAdmin. Its installation is rather simple, but only with MySQL would we have to carry out all the queries from the terminal. MySQL is a tool without a graphical interface that works from the terminal by command line (CLI). 5 Managing databases with LibreOffice Base.4 Hiding databases and changing the theme.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |