Difference between revisions of "Pi MySql"

From OpenCircuits
Jump to navigation Jump to search
Line 17: Line 17:
  
 
== enable remote access ==
 
== 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.
 +
<pre>
 +
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
 +
</pre>
  
 
== make non root user ==
 
== make non root user ==

Revision as of 17:50, 21 November 2016

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