DevArticles.In
  • Home
  • Hindi to Unicode
  • PHP Debug
  • CakePHP Captcha
  • How-To
  • About
  • Contact

Tag: mariadb

How to create a user in MySQL/MariaDB and grant permissions on a specific database

September 11, 2021September 11, 2021 Arvind KumarMySQLLeave a Comment on How to create a user in MySQL/MariaDB and grant permissions on a specific database
mysql-logo

To create a user in MySQL or MariaDB and granting it permissions to access a database is a basic task when deploying a new website on a LAMP stack server. To read and write data on a database is a very common…

Read More→

MySQL ‘show tables’: How to list tables in a MySQL database?

February 21, 2019February 21, 2019 Arvind KumarMySQLLeave a Comment on MySQL ‘show tables’: How to list tables in a MySQL database?
mysql-logo

This is very commonly asked question: How do I show or list all the tables in a MySQL (or MariaDB) database using mysql command line tool? In brief, to show the tables in a MySQL database, run the command:

Recent Posts

  • Sending Laravel Notifications Email to Single Email Address
  • Database rollback transactions in Laravel
  • Automatic Deployment of your Git Push to Remote Server
  • CSV Content Validation with FormRequest Rules in Laravel
  • Using Unique Validation Rule in Form Request in Laravel
Copyright © All rights reserved.
Blog Kit by WP Charms