apache - Block all users except localhost from phpmyadmin and mysql -


i installed xampp stack on desktop , connected via laptop on local network. surprise, able access phpmyadmin , delete update mysql tables. though understand shouldn't use xampp production (and i'm not), still learn how manage these types of obvious security flaws. know can block access directories via .htacces (http://forum.directadmin.com/showthread.php?t=29089), little more comprehensive. how restrict running of mysql queries anywhere except localhost? there way without .htaccess? thought partially purpose of root user.

mysql defined users domains. if @ user_privileges table in information_schema database see have domains. if users defined strictly localhost, there no remote access.

also, can edit my.cnf turn off tcp access database, forcing connections socket. under [mysqld], include line skip-networking. have configure apps use socket connection, socket better anyway.

this nothing protect data using phpmyadmin, if phpmyadmin installed on same machine database. safest thing rid of app. that's not practical, however, it's useful tool, , need configure phpmyadmin require users authenticate themselves. means not putting password in config file. need think how long sessions before reauthentication, , things that.

phpmyadmin fills me rage hotter thousand suns whenever try configure it, possible set things password required each time connect database through phpmyadmin. can further limit damage phpmyadmin abusers can making sure connects user limited privileges (for instance, able modify database you're working on @ moment).


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more