visible > mysql -uroot -p visible > mysqladmin -uroot password "**"
visible > mysql -uroot -p mariadb > grant all privileges on *.* to {账户名}@"{ip}" identified by "***" with grant option; mariadb > flush privileges;
visible > mysql -uroot -p mariadb > create database db_name default character set utf8 collate utf8_general_ci;
visible > mysql -uidcv -p mariadb > use tbs_system_db mariadb > set names utf8; mariadb > source /webapp/**.sql
visible > mysql -uroot -p mariadb [(none)]> show databases; //查看数据库 mariadb [(none)]> drop database ***; //删除数据库 mariadb [(none)]> show variables like 'character_set%'; //查看数据库的字符设置
//查看连接进程 show full processlist
如对本文有疑问, 点击进行留言回复!!
linux下文本编辑器vim的使用方法(复制、粘贴、替换、行号、撤销、多文件操作)
网友评论