mysql [JZ Wiki]

本頁是唯讀的，您可以看到原始碼，但不能更動它。您如果覺得它不應被鎖上，請詢問管理員。
===== Install mycli =====
[[https://github.com/dbcli/mycli|mycli]]

<code bash>
yaourt -S mycli
</code>

===== Login to mysql shell =====
<code bash>
mycli -u root -p
</code>

===== Create database =====
<code sql>
CREATE DATABASE newdatabase;
USE newdatabase
</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 =====
<code bash>
mysqladmin -u root 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>

===== Show grants =====
<code sql>
SHOW DATABASES;
SELECT host, user, password FROM mysql.user;
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>

===== List tables =====
<code sql>
SHOW TABLES
</code>