我要评论1、下载mysql数据库
yum install -y wget perl net-tools libtirpc # 安装wget和perl、net-tools、libtirpc wget https://dev.mysql.com/get/downloads/mysql-8.4/mysql-8.4.0-1.el9.x86_64.rpm-bundle.tar # 下载安装包 tar -xvf mysql-8.4.0-1.el9.x86_64.rpm-bundle.tar # 解压安装包 rpm -ivh mysql-community-common-8.4.0-1.el9.x86_64.rpm rpm -ivh mysql-community-client-8.4.0-1.el9.x86_64.rpm rpm -ivh mysql-community-client-plugins-8.4.0-1.el9.x86_64.rpm rpm -ivh mysql-community-libs-8.4.0-1.el9.x86_64.rpm rpm -ivh mysql-community-icu-data-files-8.4.0-1.el9.x86_64.rpm rpm -ivh mysql-community-server-8.4.0-1.el9.x86_64.rpm # 安装mysql
2、配置数据库
systemctl start mysqld # 启动数据库 systemctl enable mysqld # 设置开机启动 cat /var/log/mysqld.log # 查看下默认密码
如图：
3、修改默认管理员密码
mysql -uroot -p # 进入数据库
alter user 'root'@'localhost' identified by 'hadesr^000'; #修改下root初始密码，密码为：hadesr^000 flush privileges; # 刷新下权限 exit # 退出
mysql -uroot -phadesr^000 # 再重新进入，就需要新密码了
4、创建用户和数据库
create user 'hadesr'@'localhost' identified by 'hadesr^000'; # 创建用户 hadesr
如果需要外部远程访问，需要把'hadesr'@'localhost'改成'hadesr'@'%'
create database wifite character set utf8 collate utf8_bin; # 创建 wifite 数据库 grant all privileges on wifite.* to 'hadesr'@'localhost'; # wifite数据库用户赋权 flush privileges; # 刷新下权限 show databases; # 查看数据库中的所有数据库 ---------------------- mysql> show databases; +--------------------+ | database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | wifite | +--------------------+ 5 rows in set (0.00 sec)
wifite.* 为数据库名字，这里只把wifite库授权给hadesr用户，库名改成*.*，则把所有库都授权给hadesr用户
5、创建表
1、进入wifite 库
use wifite;
2、创建表
create table `dever` ( `name` text not null, `ip` varchar(15) not null, `username` text not null, `password` text not null, `port` char(32) ) ;
3、查询表和表结构
show tables; # 查询 wifite 库中表 --------------------- mysql> show tables; +--------------------+ | tables_in_wifite | +--------------------+ | dever | +--------------------+ select * from dever; # 查询 net_dev 表结构 ---------------------------------------------------------------------------- mysql> select * from dever; +------+----------+----------+------------+------+ | name | ip | username | password | port | +------+----------+----------+------------+------+ | test | 10.1.2.3 | hadesr | hadesr.com | 22 | +------+----------+----------+------------+------+
4、添加数据
1、插入数据
insert into `dever`(`name`,`ip`,`username`,`password`,`port`) values ('test','10.1.2.3','hadesr','123456','22');
2、删除信息
delete from dever where name = "test";
3、更新信息
update wifite.dever set password='hadesr.com' where name='test';
6、使用 navicat premium 编辑设备信息
mysql 下插入设备信息命令繁琐，设备多了不方便，可以使用navicat premium图形化进行操作
到此这篇关于mysql8.4数据库安装新建用户和库表的文章就介绍到这了,更多相关mysql8.4安装新建用户和库表内容请搜索3w代码以前的文章或继续浏览下面的相关文章希望大家以后多多支持3w代码！
发表评论