MySQL常用命令

创建表空间

1
2
3
4
5
6
./mysql -uroot -p -hlocalhost -P3306

mysql> CREATE DATABASE cicro DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> CREATE USER 'cicrouser'@'%' IDENTIFIED BY 'cicropassword';
mysql> GRANT ALL PRIVILEGES ON cicro.* TO 'cicrouser'@'%';
mysql> flush privileges;
Licensed under CC BY-NC-SA 4.0
陕ICP备16008414号
使用 Hugo 构建
主题 StackJimmy 设计