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