Connect more than one instance in phpmyadmin

-
Go to phpmyadmin GUI
Go to previleges -> editprevileges -> Change Password type password -> retypepassword
After
Go to phpmyadmin folder chnage file config.inc.php
$cfg['Servers'][$i]['host'] = 'hostip';
        $cfg['Servers'][$i]['port'] = '3306';
        $cfg['Servers'][$i]['socket'] = '';
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['extension'] = 'mysqli';
        $cfg['Servers'][$i]['compress'] = TRUE;
        $cfg['Servers'][$i]['auth_type'] = 'config';
        $cfg['Servers'][$i]['user'] = 'admin';
        $cfg['Servers'][$i]['password'] = 'password';

Comments

Post a Comment

Popular posts from this blog

MySQL event scheduler and how to create MySQL events to automate database tasks

-
Working with MySQL Scheduled Event  SET GLOBAL event_scheduler = OFF;  SET GLOBAL event_scheduler = ON; MySQL event scheduler and how to create MySQL events to automate database tasks. A MySQL event is a task that runs based on a predefined schedule therefore sometimes it is referred to as a scheduled event. MySQL event is also known as “temporal trigger” because it is triggered by time, not by table update like a trigger. A MySQL event is similar to a cron job in UNIX or a task scheduler in Windows. You can use MySQL events in many cases such as optimizing database tables, cleaning up logs, archiving data, or generate complex reports during off-peak time. MySQL event scheduler configuration MySQL uses a special thread called event schedule thread to execute all scheduled events. You can see the status of event scheduler thread by executing the following command: SHOW PROCESSLIST; By default, the event scheduler thread is not enabled. To enable and start the event scheduler t...
Read more

GIT create a new repository on the command line

-
create a new repository on the command line echo "# mynewrepository" >> README.md git init git add README.md git commit -m "first commit" git remote add origin https://github.com/radheymishra/mynewrepository.git git push -u origin master …or push an existing repository from the command line git remote add origin https://github.com/radheymishra/mynewrepository.git git push -u origin master user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ ls user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git init Initialized empty Git repository in /home/user/Documents/devloper1/.git/ user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git clone https://github.com/radheymishra/mynewrepository.git Cloning into 'mynewrepository'... warning: You appear to have cloned an empty repository. Checking connectivity... done. user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git init Reinitialized existing Git repository in /home/user/Documents/devlope...
Read more

How to send Send Email with attached CSV file in codeigniter

-
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Home extends CI_Controller {     public function __construct() { parent::__construct(); $this->load->helper('url'); $this->load->library('email'); $this->load->helper('file'); $this->load->database(); } public function index() {     $data['rs'] =  $this->db->get('customer_profile');     $this->load->view('home', $data);    } // Download for CSV file. // http://localhost/codeigniterR/index.php/home/csv public function csv($query, $filename = 'CSV_Report.csv') { $this->load->dbutil(); $this->load->helper('download'); $delimiter = ","; $newline = "\r\n"; $enclosure = '"'; $query = $this->db->query("select customeremail as Radhey from customers"); $data = $this->dbutil->csv_from_result($query, $delimiter, $newline); // client ...
Read more