mysql – POFTUT

Tagged: mysql

0

How To Connect MySQL/MariaDB Server From Command Line On Linux and Windows?

MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases command line connection may be required to connect and management MySQL and MariaDB database server. Install MySQL/MariaDB Client For Ubuntu, Debian, Kali, Mint We will start by installing MySQL/MariaDB command line client in the deb based distributions like Ubuntu, Debian, Kali, Mint etc. The package is...

0

How To Install LAMP Stack On Linux, Ubuntu, Debian,Mint,Fedora

LAMP stack is a popular term in IT world. It is used to express multiple application package to server PHP applications. Here is the formula Linux+Apache+MySQL+PHP=LAMP . LAMP stack can be created by installing these components one by one. In this tutorial we assume that we have already installed the Linux distribution like Ubuntu, Debian, CentOS, Mint . Installing Apache or Httpd We will start by installing Apache web server. Apache...

0

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...

0

How To Install MySQL On Ubuntu, Debian, Mint Kali

MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of applications and companies like Facebook, Google etc. In this tutorial we will learn how to install MySQL into deb or apt based distributions like Ubuntu, Debian, Mint and Kali. This guide can be used for other deb or apt based distributions too. Update Repository Information It is not a reuirement but a best practice...

0

What Is MySQL Default Port Number?

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is TCP 3306. This port can be also used for MariaDB database server. List with netstat Command We can use netstat...

0

How To Connect MySQL Database From Python Application and Execute Sql Query with Examples

MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application we need some libraries. There are different libraries those supports running sql queries on MySQL but we will stick with...

0

Mysql Database Import Tutorial with Examples

Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the name of the database we want to import FILE is the file which contains the data and schema Import SQL File...

2

Php Tutorial

[rps-include post=6522] Php is a programming language mainly developed for web programming. Php language is created by Rasmus Lerdorf in 1994. Php have different version those have create in history. Most recent version of Php is 7.0 but the 5.X series Php is most popular version. Features Php gets it features from different languages like C, C++, Java etc. Php supports class, inheritance, primitive types, file operations. Php generally used...

0

How To Create Database and Table In MySQL and MariaDB?

MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql Server in Linux Fedora? Following operations can be done in MariaDB without any problem. MariaDB is the...

0

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 :)