I need to create a new MySQL user to manage my wordpress site. What privellages are needed for wordpress? I assume INSERT is also needed and maybe DROP? Example GRANT SELECT ON database.* TO user@’localhost’; Asked by Henry Hoggard The official documentation says to give the user all privs. Others suggest that you can restrict it to INSERT UPDATE DELETE CREATE DROP ALTER INDEX Plugins etc can though call any statement they want so you [...]

Should I have a different MySQL user for each database so that if someone gets access to a mysql user they cannot effect the others? If so how would i go about doing this? Asked by Henry Hoggard Its a principle called “separation of privileges”, which reduces the impact of an intrusion. you can do something like GRANT ALL PRIVILEGES ON mydatabase.* TO ‘myuser’@’127.0.0.1′ IDENTIFIED BY ‘somepassword’; FLUSH PRIVILEGES; or you can provide some subset [...]

I have Debian (Kernel 2.6.26-2-686) installed on two computers. On one of them it reboots quite finely but I am having following problem with rebooting Debian on my second computer. When i type reboot at the Linux prompt, following messages appear and system hangs up after saying “Restarting System“: Broadcast message from root@myname (tty1) (Sun Jan 17 11:23:26 2010)The system is going down for reboot NOW! INIT: Switching to runlevel: 6 INIT: Sending processes the [...]

Suddenly and without any reason mysql stopped working. netstat -tap does not list the mysql process. I tried /etc/init.d/mysql restart|start But his produces an error message: /etc/init.d/mysql: error reading input file: Input/output error Any ideas what happend and how do I fix this problem? Asked by ArtWorkAD Oh dear, that sounds like a dead hard drive. I hope you have backups. Try dmesg and see if it complains about I/O errors, too. Answered by Janne [...]

Debian is running 2.6.32-5. Recent kernels seem to have addressed some kernel soft lockup issues, I’d like to try them. Although… the patches don’t seem to be in the Debian-stable repository. # dpkg -l linux-image-2.6.32-5-686 Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Description +++-======================-================================================================================== ii linux-image-2.6.32-5-6 2.6.32-44 Linux 2.6.32 for modern PCs Why is the Debian “Version” 2.6.32-44 when the kernel is 2.6.32-5 ? What does upgrading to Debian version 2.6.32-45 (of [...]

I am trying to install config server firewall however when i follow the tutorial and run install.sh i get the following error. Can anyone help? root@localhost:~/csf# sh install.shConfiguring for OSRunning csf generic installerInstalling generic csf and lfdCheck we’re running as rootChecking Perl modules… Can’t locate LWP/UserAgent.pm in @INC (@INC contains: /etc/csf /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at (eval 22) line 2. BEGIN failed–compilation aborted at (eval 22) line 2. Configuration modified [...]

I am creating a debian package. This will have to alter /etc/inittab to switch tty1 from /sbin/getty to /sbin/rungetty. Of course I can alter the line with an sed in the postinst. Is this the best way to do it or is there any debianish way to do it? Thanks in advance Asked by krissi the Debianish way to handle this is documented in the Debian Policy Manual in section 10.7.4 “Sharing Configuration Files”. The [...]

I have running system with low IO utilization: HP DL380G7 ( 24gb RAM ) Smart Array p410i with 512mb battary backed write cache 6x SAS 10k rpm 146gb drives in RAID10 Debian Squeze linux, ext4 + LVM, hpacucli installed iostat (cciss/c0d1 = raid10 array, dm-7 = 60G lvm partition for test): Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util cciss/c0d0 0,00 101,20 0,00 6,20 0,00 0,42 138,58 0,00 0,00 0,00 0,00 [...]

EDIT: Solved… There was a hardware firewall in the way! I installed node.js on a remote Debian GNU/Linux 6.0.4 (squeeze) server and ran this http server on port 8866. var http = require(‘http’);http.createServer(function (req, res) { res.writeHead(200, {‘Content-Type’: ‘text/plain’}); res.end(‘Hello World\n’); console.log(‘Someone set up us the bomb’); }).listen(8866, “0.0.0.0″); console.log(‘Server running at http://0.0.0.0:8866/’); It appears to run: node server.js root@pod:/var/www# Server running at http://0.0.0.0:8866/ But when I go to http://213.159.xxx.xxx:8866 nothing showsand it times out. [...]

After installing Debian stable (squeeze) I found that eth0 is not coming up, when I bring it up with “ifconfig eth0 up” only IPv6 is configured. Installation did happen in a network with IPv6 enabled through a tunnel and a radvd router. Which makes me think it may have decided to disable IPv4, don’t know how or why. I have done many installations in an IPv6 enabled network like this one and Debian (or Ubuntu) [...]