mysql

差異處

這裏顯示兩個版本的差異處。

連向這個比對檢視

兩邊的前次修訂版 前次修改
下次修改		 前次修改
mysql [2017/04/17 00:44] – jzmysql [2019/02/19 02:06] (目前版本) – [Change credential] jz
行 13: 行 13:
 ===== Create database ===== ===== Create database =====
 <code sql> <code sql>
-CREATE DATABASE menagerie; +CREATE DATABASE newdatabase; 
-USE menagerie+USE newdatabase
 </code> </code>
  
 +===== Create user and grant the database access =====
 +<code sql>
 +CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';
 +GRANT ALL PRIVILEGES ON newdatabase.* TO 'newuser'@'localhost';
 +</code>
  
 ===== Change credential ===== ===== Change credential =====
行 22: 行 27:
 mysqladmin -u root password 'new-password' mysqladmin -u root password 'new-password'
 mysqladmin -u root -h localhost password 'new-password' mysqladmin -u root -h localhost password 'new-password'
 +</code>
 +
 +<code mysql>
 +SET PASSWORD FOR 'user'@'localhost' = PASSWORD('password');
 +-- or
 +update mysql.user set password=PASSWORD(‘新password’) where User=’root’;­
 +-- and then
 +flush privileges;­
 +</code>
 +
 +===== Show users =====
 +<code sql>
 +select * from mysql.user;
 </code> </code>
  
行 29: 行 47:
 SELECT host, user, password FROM mysql.user; SELECT host, user, password FROM mysql.user;
 SHOW GRANTS FOR username@localhost; SHOW GRANTS FOR username@localhost;
 +</code>
 +
 +===== Remote grants =====
 +<code sql>
 +revoke all privileges on newdatabase.* from 'newuser'@'localhost';
 +flush privileges;
 +</code>
 +
 +===== List databases =====
 +<code sql>
 +SHOW DATABASES
 </code> </code>
  
  • mysql.1492361092.txt.gz
  • 上一次變更: 2017/04/17 00:44
  • 由 jz