Difference between revisions of "Pi MySql"
Jump to navigation
Jump to search
Russ hensel (talk | contribs) |
Russ hensel (talk | contribs) |
||
Line 26: | Line 26: | ||
3) sudo /etc/init.d/mysql restart //restart mysql | 3) sudo /etc/init.d/mysql restart //restart mysql | ||
</pre> | </pre> | ||
+ | |||
+ | later might want to look at https://serverfault.com/questions/139323/mysql-bind-to-more-than-one-ip-address | ||
== make non root user == | == make non root user == |
Revision as of 16:59, 21 November 2016
Contents
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
later might want to look at https://serverfault.com/questions/139323/mysql-bind-to-more-than-one-ip-address
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