1.连接数据库: mysql -uroot -p (密码:123456)
2.创建数据库:create database sonar;
3.显示数据库:show databases;
4.查看数据库的版本:mysql -V (大写的V)
5. 创建用户和密码,并授权
MySQL> CREATE USER 'sonar'@'%' IDENTIFIED BY 'sonar123';
MySQL> CREATE DATABASE sonar CHARACTER SET UTF8;
MySQL> GRANT ALL PRIVILEGES ON sonar.* TO 'sonar'@'%';