If PHP is not installed, you won’t be able to access PHPMyAdmin as it is written in PHP. Either you can log in as root, or you can log in as a user with sudo privileges.Īlso, Make sure you have PHP and MySQL installed on the server. Make sure you have root access to the user so that you can install PHPMyAdmin package. Normally, It will take 5-10 minutes to install PHPMyAdmin on Ubuntu 16.04. The installation process is pretty straightforward and easy. If you are not a ServerAvatar user, Just follow the tutorial. You can access PHPMyAdmin directly from the Databases section of your Server Panel just like the following image. Install PHPMyAdmin on Ubuntu 16.04įirst of all, If you are a ServerAvatar user, you don’t have to install PHPMyAdmin Manually. So, let’s get started with the installation. We have to have to install it manually on our server. Not only add, update and delete, but there are hundreds of features available in PHPMyAdmin. So, It makes everything very easy and professionals love it. Once you will correct the email and hit Enter key, It will execute a query to update email field for the record you are updating, behind the scenes! So, You will click on the field, and the field will convert into the input box in which you can edit data. Now, Let’s assume you want to change the email field of any specific user which is incorrect currently. So, You will click on the users table in the database, and you will get a list of users stored in the table.īehind the scenes, PHPMyAdmin will execute the following query in MySQL and will display the data returned by MySQL in tabular form. For instance, you want to see the records stored in the users table. PHPMyAdmin will execute the queries behind the scenes as you work on your database. The tagline of PHPMyAdmin is Bringing MySQL to the web. And the slogan is utterly perfect! That’s what it does! In most straightforward words, PHPMyAdmin is the GUI version of MySQL. How? Let’s understand what PHPMyAdmin is. PHPMyAdmin allows you to execute these queries without actually writing them. Still, It’s hard for new MySQL users or non-tech people like bloggers. Mysql> SELECT * from users where is the simplest query that is executed on MySQL console. For example, If you want to select a user that has specific email address users table, You will have to execute the following query in your MySQL console to select a record. MySQL is hard to deal with in case you don’t know SQL queries.
0 Comments
Leave a Reply. |