Monthly Archives: March 2014

---

block ip from ssh

This entry was posted in Linux Sys admin on March 19, 2014 by techstruggles.

/etc/hosts.deny ALL: 23.234.61.51   (substitute all for whatever daemon name)

---

Mysql create database then create user. New user can’t login

This entry was posted in database on March 3, 2014 by techstruggles.

When you try to login to mysql with a newly created user, you may get:   ERROR 1044 (42000): Access denied for user Try to ensure the user’s been granted sufficient privileges for the database.   For example, create databases db; create user ‘blah’@’localhost’ with password ‘password’; grant all privileges on db.* to ‘blah’@’%’;  <—–IMPORTANT. […]

---