无常是常

无常是常

分享技术见解、学习心得和生活感悟

浏览文章 了解更多

最新文章

MySQL常用命令

创建表空间

1
2
3
4
5
6
7
./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;

创建表空间

1
2
3
4
5
6
7
./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;

MySQL