Author Archives: paulschreiber

If you want to give a user permissions to back up a MySQL database, what do you do? The MySQL GRANT page didn’t tell me. Searching wasn’t helpful. Here’s the answer, in the hopes it will help others: SELECT and LOCK TABLES. mysql> grant select, lock tables on foo.* to bar@localhost indentified by ‘ugh’; mysql> …

Continue reading “MySQL: permissions needed for mysqldump”

In PHP, to get the name of the web server, you can print $_SERVER[“HTTP_HOST”]. However, if you use round-robin DNS or a load balancer, this will give you the name Apache thinks your machine is. What if you want the real hostname — what you’d get from hostname or uname? print gethostbyaddr(“127.0.0.1”); That’s all. It …

Continue reading “HOWTO get the real host name of your server in PHP”