mysql database – POFTUT

Tagged: mysql database


How To List MySQL Tables with “show tables” SQL Query

MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive Shell We need to connect or run command in MySQL to list table names. We will connect to the interactive...


How To List MySQL Database Users?

MySQL database server have users to connect and use databases and tables. Users provides security for database operations. MySQL server comes with default users or in the operations a lot of users are created. In this post we will look how to list these users. Connect To Database We will connect to the MySQL database server to list user. MySQL is a tool used to manage databases, tables, users and...

Enjoy this blog? Please spread the word :)