大连密封材料 发表于 2024-8-7 14:56:54

2024.8.2（MySQL）

一、mysql

1、下载mysql软件包

   # yum -y install wget
# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
2、解压

   # tar -xf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar 
3、安装依靠包

   # rpm -e --nodeps mariadb-libs
# rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm
# rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm
# rpm -ivh mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm
# rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm
4、初始化mysqld服务

   # mysqld --initialize --console
5、添加权限 启动服务

   # chown -R mysql:mysql /var/lib/mysql/
# systemctl start mysqld
6、在/var/log/mysqld.log中找到初始密码，复制

   # cat /var/log/mysqld.log | grep localhost
2024-08-02T01:49:19.435048Z 6 A temporary password is generated for root@localhost: dQ1o<YO&YNyX   密码
7、登录管理

   # mysql -uroot -p
Enter password:  密码
mysql> 
8、设置新的密码

   mysql> alter user 'root'@'localhost'identified by '123456';
Query OK, 0 rows affected (0.01 sec)
# mysql -uroot -p123456
mysql> quit
Bye
9、数据库对象

           1. 数据库系统 DBMS
        2. 数据库 DB
        3. 表 table
        4. 记载 record
        5. 字段 feild 
10、数据库操纵

        1. 数据库操纵

                1.1 查看数据库

                   https://i-blog.csdnimg.cn/direct/fc45d74899684f0581b4a01c3d1beb0f.png
                1.2 创建库

                   https://i-blog.csdnimg.cn/direct/82b154c2ef7d4da583ffa6817b3b6eb2.png
                https://i-blog.csdnimg.cn/direct/4995fff08d9c4fe787499dcff3f422ff.png
                1.3 删除库

                   https://i-blog.csdnimg.cn/direct/bc76fa7b71c1421e9bae86f53c866164.png
        2. 表的操纵

                2.1 选择库

                   https://i-blog.csdnimg.cn/direct/02620d9af67345a8be91d4669e9c9b87.png
                2.2 查看表

                   https://i-blog.csdnimg.cn/direct/fb8692a1cbbf4372b4be224a91db1c4d.png
                2.3 创建表

                   语法：create table user( id int primarykey,username varchar，password varchar );
                mysql> create table `test1`(
                     `id` int not null auto_increment,
                    `username` varchar(45) not null,
                    `password` varchar(45) not null,
                     primary key(`id`)
                     );
                https://i-blog.csdnimg.cn/direct/e2e974a464854bf3b33d5f37af575fab.png
                2.4 删除表

                   mysql> drop table user0;
                Query OK, 0 rows affected (0.01 sec)
                https://i-blog.csdnimg.cn/direct/87bcf2bb7b2f4c5e946fc06e267342f4.png
                2.5 其他

                        2.5.1 新增列

                           ALTER TABLE `test`
                         ADD COLUMN `realname` VARCHAR(45) NULL AFTER `password`;
                        2.5.2 修改列名

                           mysql> ALTER TABLE `test`   
                        -> CHANGE COLUMN `realname` `zsxm` VARCHAR(45) NULL DEFAULT NULL ;                         Query OK, 0 rows affected (0.02 sec)
                        Records: 0 Duplicates: 0 Warnings: 0
                        2.5.3 删除列

                           mysql> ALTER TABLE `test`   
                        -> DROP COLUMN `zsxm`;
                        Query OK, 0 rows affected (0.01 sec)
                        Records: 0 Duplicates: 0  Warnings: 0
        3. 记载的操纵

                1. 新增

                   #insert into 表名 (字段名列表) values (字段值列表)
                mysql> insert into test (id,username,password) values (3,'zhangsan','zhangsan');
                Query OK, 1 row affected (0.01 sec)
                mysql> insert into test(username,password)values('lisi','lisi');
                Query OK, 1 row affected (0.00 sec)
                2. 删除

                   delte from user where 条件;
                mysql> delete from test where username='zhangsan';
                Query OK, 1 row affected (0.00 sec)
                3. 修改

                   mysql> insert into user values (1,'zhangsan','zhangsan');
                Query OK, 1 row affected (0.00 sec)
                mysql> update user set password=123 where username='zhangsan';
                Query OK, 1 row affected (0.01 sec)
                Rows matched: 1  Changed: 1  Warnings: 0
           
          

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页: [1]
查看完整版本: 2024.8.2（MySQL）