How to execute Mysql query and select list of users without phpMyAdmin in Ubuntu?

To execute Mysql query in Ubuntu you must have root access credentials.

Connect your server or cloud (If it is on another server) with Putty and then execute the following command.( You may required login details)

$ sudo mysql -u root # I had to use “sudo” since is new installation

This will display output something like this

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

Then select the database and execute the query:

mysql> USE mysql;

mysql> SELECT User, Host, plugin FROM mysql.user;
| User | Host | plugin |
| root | localhost | auth_socket |
| mysql.session | localhost | mysql_native_password |
| mysql.sys | localhost | mysql_native_password |
| debian-sys-maint | localhost | mysql_native_password |
4 rows in set (0.00 sec)

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

As you found this post useful...

Share this post on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?