mysql - Eduguru - Page 14

php-mysql

mysql PHP php-mysql

PHP MySQL Database Connection

February 6, 2016February 8, 2016 Satya Prakash 2 Comments Below example will create a Database from php code, create a Database from php code, example to create a Database from php code, Example to create table from php code, example will create a Database from php code, php connect database, php connect db, php database connection, php db connection, PHP MySQL Database Connection

PHP 5 and later can work with a MySQL database using: MySQLi extension (the “i” stands for improved) PDO (PHP

MySQL Cluster

MySQL Index : Understanding MySQL indexing

January 11, 2016January 11, 2016 Satya Prakash 1 Comment Facts about Indexes, How MySQL Uses Indexes, How to create Index, MySQL Index, MySQL Index : Understanding MySQL indexing, MySQL indexing, SQL CREATE INDEX Syntax, Understanding MySQL indexing, Verifying Index Usage, What is Indexing

What is Indexing? A database index is a data structure that improves the speed of operations in a table. Indexes

MySQL Cluster

MySQL Database Administration – Part1

December 28, 2015December 28, 2015 Satya Prakash 0 Comments creating a MySQL User Account, Execute simple SQL commands using MySQL Client, including the PRIMARY KEY. SHOW TABLE STATUS LIKE tablename\G, Installing MySQL on Linux/UNIX, Installing MySQL on Windows:, MySQL Database Administration - Part1, mysql Post-installation Steps:, Running and Shutting down MySQL Server:, Setting Up a MySQL User Account:, SHOW INDEX FROM tablename, SHOW INDEX FROM tablename: Presents the details of all indexes on the table, Verifying MySQL Installation

Running and Shutting down MySQL Server: First check if your MySQL server is running or not. You can use the

MySQL Cluster

Creating Views in MySQL : How to create mysql views

December 11, 2015December 11, 2015 eduguru 0 Comments

Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement

MySQL Cluster

mysql query log – Log all queries on mysql database

December 11, 2015February 28, 2016 Satya Prakash 0 Comments log mysql queries, mysql query log - Log all queries on mysql database, mysql query log in to database table, mysql query log into file

To enable the query log, put this in /etc/my.cnf in the [mysqld] section log = /path/to/query.log #works for mysql < 5.1.29 Also, to enable

phpmyadmin

phpMyAdmin : What is phpMyAdmin?

August 8, 2015March 27, 2018 Satya Prakash 0 Comments introduction to phpmyadmin, mysql gui, mysql gui administration, mysql gui management, mysql management interface, php mysql adimin, phpmyadmin, what can we do with mysql, what is phpmyadmin, why phpmyadmin

phpMyAdmin is one of the most popular applications, free and open source tool written in PHP, Intended to handle the administration

mysql replication process

How Does MySQL Replication Works?

August 1, 2015February 24, 2016 Satya Prakash 0 Comments How Does MySQL Replication Works?, how replication events are written on the master, how they are transferred to the replication slave, mysql repolication

Of course, there are many aspects of MySQL replication, but my main focus will be the logistics – how replication

MySQL Cluster

mysqldump – MySQL Database Backup and restore program

July 30, 2015 Satya Prakash 3 Comments mysql database backup[, mysql database restore, mysql dump option, mysqldump, mysqldump - mysql backup, mysqldump - MySQL Database Backup and restore program, mysqldump options

What is mysqldump The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be run

MySQL Cluster

How to reset mysql root password

May 15, 2015 Satya Prakash 0 Comments forget mysql password, How to reset mysql root password, recover mysql root password, Reset mysql root password, root password recover, set mysql root password

it is quiet easy to reset mysql root password, here are the steps SSH as root to your machine Turn

mysql sqery output into txt file

save mysql sqery output into txt file

February 20, 2015February 20, 2015 Satya Prakash 21 Comments save mysql sqery output into txt file, You just need to modify the query and login credential then run the below command of database server . mysql -e "select * FROM tabledata" -u satya -pPrakash databasename > /home/ob_cdr.txt However

You just need to modify the query and login credential then run the below command of database server . mysql