Error 2002 after changing datadir in mysql.cnf - Raspberry Pi Forums

-

hello, new raspberry , linux.
bought pi2 piface digital 2, no problems raspbian , mysql + php5 installs.

tried move newly created database nas (buffalo terastation); found lots of infos on net, mounted ok destination folder, copied db, , changed "datadir" in /etc/mysql/my.cnf file.
but: no way restart mysql, consistently following "error 2002 (hy000): can't connect local mysql server through socket '/var/run/mysqld/mysqld.sock' (2)".

fooled around lot different parameters, changed "bind-address" 0.0.0.0 or pi2 ip address, socket location (also in debian.cnf) etc.
tried install apparmor, problem still there. reversible though, return "datadir = /var/lib/mysql" starts working again.
way, "$ sudo service mysql restart" works, "$ sudo /etc/init.d/mysql stop" consistently fails.

appreciate help, issue drives me crazy !

you need move /var/mysql (including subdirectories) new device update /etc/mysql/my.cnf reflect new location. there's lots of meta-data tables created when start running mysql first time.


raspberrypi



Comments

Post a Comment

Popular posts from this blog

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

-
dear all, working on image processing using raspberry pi, have installed intex usb web camera on raspberry pi. have used basic python script of image processing https://www.cl.cam.ac.uk/projects/raspb ... first.html required libraries installed on raspberry pi. script code: import imgproc imgproc import * # open webcam take pictures camera = camera(160, 120) # open viewer window display images viewer = viewer(160, 120, "the first step") # take picture camera img = camera.grabimage() # display image in viewer viewer.displayimage(img) # iterate on each pixel in image x in range(0, img.width): for y in range(0, img.height): # value @ xth column , yth row, place intensities variables red, green, blue = img[x, y] # test find colour dominant if red > green , red > blue: # red dominant, set pixel red img[x, y] = 255, 0, 0 elif green > red , green > blue: img[x, y] = 0, 255, 0 else: # if red or gr
Read more

using a laptop skeleton to build a pi laptop - Raspberry Pi Forums

-
Image
i have laptop dead motherboard . can remove components laptop , in anyway possible connect raspberry pi inbuilt display , keyboard on laptop ? (and touchpad if possible). (i figured remove components inside , fix pie inside , use extended usb cable , connect available usb ports respective holes in laptop skeleton, same headphone out ) . i'm noob when comes pi . on topic appreciated if screen lvds type may possible use screen installing converter board. this: http://www.ebay.com/itm/hdmi-dvi-vga-dr ... 3027&rt=nc need model number of screen , ask seller if work. or search ebay using brand , model number. assuming screen in working order..... back-light not burnt out etc.. other devices...... can used if have usb interface not part of motherboard. have make connector. raspberrypi
Read more

Forum for Joomla? - Joomla! Forum - community, help and support

-
heya, i need forum joomla works community builder , not joomlaboard. im using jb right now, , not working me >< what other *proper* installations there available? i recommend smf, that's forum using here, see link on bottom of page. there's called smf/joomla "bridge" available, see http://extensions.joomla.org/component/ ... itemid,35/ Board index Joomla! Older Version Support Joomla! 1.0 Extensions - 1.0.x Components
Read more