mysql > GRANT ALL PRIVILEGES ON dbdevel.* TO userdevel@localhost;mysql > GRANT ALL PRIVILEGES ON dbdevel.* TO userdevel@localhost WITH GRANT OPTION;mysql> show grants for 'userdevel'@'localhost';
+------------------------------------------------------------------------+
| Grants for userdevel@localhost |
+------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'userdevel'@'localhost' |
| GRANT ALL PRIVILEGES ON `dbdevel`.* TO 'userdevel'@'localhost' |
+------------------------------------------------------------------------+
2 rows in set (0.04 sec)
mysql> show grants for 'userdevel'@'127.0.0.1';
+------------------------------------------------------------------------+
| Grants for userdevel@127.0.0.1 |
+------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'userdevel'@'127.0.0.1' |
| GRANT ALL PRIVILEGES ON `dbdevel`.* TO 'userdevel'@'127.0.0.1' |
+------------------------------------------------------------------------+
2 rows in set (0.00 sec)mysql> grant all privileges on dbdevel.* to userdevel@127.0.0.1 identified by '0000';
Query OK, 0 rows affected, 1 warning (0.05 sec)
mysql> select user,host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| userdevel | % |
| userdevel | 127.0.0.1 |
| debian-sys-maint | localhost |
| mysql.sys | localhost |
| root | localhost |
| userdevel | localhost |
| usertest | localhost |
| userwork | localhost |
+------------------+-----------+
8 rows in set (0.00 sec)Access denied for user 'userdevel'@'localhost' (using password: YES)
(function() {
var employee_or_subdivision;
employee_or_subdivision = function(a) {
var label;
label = a.value;
if (label === '1') {
$('#position_name').style.display = 'block';
} else {
$('#position_name').style.display = 'none';
}
};
window._ = employee_or_subdivision;
}).call(this);