![]() | debian-sys-maint | mysql_native_password | You will get the following output on your screen: +-+-+ To check the authentication method of all of your users, you can execute the following: SELECT user,plugin FROM er This will take you to the MySQL shell as the MySQL root user. To do this, connect to your server via SSH, and then log in to your MySQL database server by typing the following command: sudo mysql If you want to be able to authenticate as the root user in your phpMyAdmin, you will have to change the authentication method from auth_socket to mysql_native_password. Log in as rootīy default, the root user is set to use the auth_socket plugin in order to authenticate to your MySQL database server. We will show you how to log in using both of these methods. To manage your databases using phpMyAdmin, you will need to either log in as the MySQL root user or as another MySQL user account with administrative privileges. To access your phpMyAdmin, first restart your apache2 web server with: systemctl restart apache2Īnd type in your browser to access the login page: ![]() With this last step, the phpMyAdmin installation has been completed. ![]() To install phpMyAdmin, along will all of the required dependencies, run the following command: sudo apt install phpmyadminĭuring the installation, you will be asked a couple of questions.Ĭhoose to configure a database for phpMyAdmin with dbconfig-common:Įnter and confirm a MySQL application password for phpMyAdmin: PhpMyAdmin is already available in the default Ubuntu package repositories. Sudo apt upgrade Step 2: Install phpMyAdmin Once logged in, make sure that your server is up-to-date by running the following commands: sudo apt update Make sure to replace IP_ADDRESS and PORT_NUMBER with your actual server IP address and SSH port number. To connect to your server as the root user, use the following command: ssh IP_ADDRESS -p PORT_NUMBER Full SSH root access or a user with sudo privileges is also required.īefore we begin, you need to connect to your server via SSH as the root user or any other user with sudo privileges.Our Ubuntu 18.04 VPS already comes pre-installed with a fully-configured LAMP stack. You will also need a working LAMP or LEMP (Linux, Apache/Nginx, MySQL, PHP) stack.For the purposes of this tutorial, we will be using an Ubuntu 18.04 VPS.We have an updated version of this tutorial – How to Install phpMyAdmin on Ubuntu 20.04 Requirements: Today, we are going to show you how to install phpMyAdmin on Ubuntu 18.04. You can create, modify, and delete databases or tables, execute SQL queries, manage your MySQL user accounts and privileges, and much more, all from your web browser. It can be used to handle the administration of MySQL as well as MariaDB databases. It is a free and open-source PHP application that allows users to manage single or multiple SQL database servers, both locally or on a remote server using a web browser with easy to use graphical user interface. PhpMyAdmin is one of the most popular and widely-used web-based database management tools on the market.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |