====== MySQL Tips&Tricks ======
===== set root password =====
<code sql>
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('password');
</code>
===== grant acces
ed user =====
Create a user with no shell and no password
<code bash>
# adduser
Username: gemini
Full name:... ectory permissions (Leave empty for default):
Use password-based authentication? [yes]: no
Lock out the account after creation? [no]:
Username : gemini
Password : <disabled>
Full Name : gemini
Uid : 1