从CentOS进入Mariadb
# mysql -h 127.0.0.1 -P 3306 -u root -p
----------------------------------------------------------------------------
进入数据库管理系统后,
显示管理系统信息
MariaDB [(none)]>status;
显示库
MariaDB [(none)]>show databases; (是databases不是database)
删除库
MariaDB [(none)]>drop database `ku-ming`; (是`不是';反引号是为了应对库名中带有特殊字符,比如 - )
显示用户
MariaDB [(none)]>select user,host,password from mysql.user;
显示用的授权
MariaDB [(none)]>show grants for 'yonghuming'@'127.0.0.1';
删除用户
MariaDB [(none)]>drop user 'yonghuming'@'127.0.0.1';