Useful Raspbian commands

By -

Check free disk space

df -h

Install MySQL Server

sudo apt-get install mysql-server
sudo mysql_secure_installation
sudo mysql -u root -p
sudo apt-get install python-mysqldb
sudo mysql -u root -p
GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'localhost' IDENTIFIED BY 'password';

https://pimylifeup.com/raspberry-pi-mysql-phpmyadmin/

Install myPHPAdmin

sudo apt-get install phpmyadmin


Restart Apache server

sudo service apache2 restart

Restart MySQL server

sudo service mysql restart

Change file permissions

sudo chmod -R 777 phpmyadmin

Edit phpmyadmin blowfish configuration file

sudo nano /var/lib/phpmyadmin/blowfish_secret.inc.php
sudo nano /etc/phpMyAdmin/config.inc.php


Comments

Post a Comment

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

By Dora -
Image
https://developers.google.com/chart/interactive/docs/gallery/orgchart While googling for some information on organizational charts of various companies, I came across this cool visualization tool on Google Developers. If you are comfortable with JavaScript and want a quick and easy way to churn out a simple organizational chart that displays on a webpage, this tool is quite useful. Organizational chart churned out using Google's Visualization OrgChart object To use it, follow these few steps Step 1: Include this tag in your <head> tag in your HTML file <script type = 'text/javascript' src = 'https://www.google.com/jsapi' ></script> Step 2: Load visualization package and set callback method when page loads In this case, the callback method is "drawChart". <script type = 'text/javascript' >       google . load ( 'visualization' , '1' , { packages :[ 'orgchart' ]});     ...
Read more

Embed JSX code with if condition in React app

By -
     renderPrice(pt)  {    if (pt.amountpaid!="") {        let ctrl = (           <>             <div>                 <label>Price</label><br/>                 <input type="text" readOnly name="amountpaid" value={pt.amountpaid} />             </div>           </>          );          return ctrl;     } //end if } //end renderPrice render () {   const   priceElement  =  this . renderPrice ( purchasetransaction ); return  (                  < div   style = { { marginTop :   '5em' , marginLeft : '2em' } } >  ...
Read more

How to remove “Git” from Windows 7 context menu

By Dora -
Image
Click “Start->Run->cmd” to open up a command prompt window Type the following commands in the command prompt Technorati Tags: Git , Windows 7 , context menu You should see the above "success" message to inform you that the DLL has been unregistered and you should no longer see the "Git" menu items on your context menu
Read more