Category: MySQL

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

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

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

0

Backup and Restore MySQL Databases With Mysqldump In Linux

One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular database server and provides tool named mysqldump for backup and restore operations. We will look different usage types of mysqldump in this tutorial. Syntax

Help

Connect Remote Database Server...

0

How To Drop MySQL Database?

MySQL is very popular opensource database it is used by a lot of different type and size companies. In this post we will look how to drop or delete MySQL databases? Login MySQL Database Dropping/Deleting/Removing a database in MySQL server is simple and fast solution which will delete data as...

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

2

How To List MySQL / MariaDB Database?

MySQL is very popular opensource database. MySQL is created by MySQL AB a Swedish company and then bought by Sun. Sun is bought by Oracle and MySQL is currently owned by Oracle. MySQL is very popular at opensource community. In this post we will look how to list databases in...

0

How To Recover or Reset Lost MySQL Password On Linux?

I have some php applications that runs with MySQL database server. I have  setup MySQL database long time ago and I have forgotten root password of MySQL server. How can I recover and reset MySQL Server password? One way to reset MySQL password is stopping MySQL daemon. Starting it with recovery mode...

0

How To Create Fast Simple Database and Table With Php and Sqlite

Php is web programming language very popular among developers. Php is actually a scripting language which means there is no need to compile the code to run. So write and run is the motto of php language. Php scripts can be run on Linux systems like bash, Perl scripts too....

Enjoy this blog? Please spread the word :)