Pi MySql

From OpenCircuits
Jump to navigation Jump to search

next mysql


sudo apt-get install mysql-server --fix-missing  

set password ****** same as for others

sudo apt-get install mysql-client php5-mysql

sudo apt-get install mysql-workbench

mySql workbench now on menu


enable remote access

If your issue is not able to remotely connect with MySQL on Raspberry Pi, then try below steps. I had the same issue and got it resolved by performing below commands.

sudo leafpad /etc/mysql/my.cnf

2) # bind-address = 127.0.0.1 // comment this line out

bind-address = 0.0.0.0          //add this line just below above line 
3) sudo /etc/init.d/mysql restart //restart mysql

make non root user

misc

Restarting The MySQL service

sudo service mysql restart

make db

for python

and that did it the pip now worked then

pip install pymysql